FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Procedural Language Sql and Advanced Sql

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

A) 8
B) 18
C) 26
D) 144

E) B) and C)
F) C) and D)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator?

A) 0
B) 2
C) 8
D) 10

E) A) and C)
F) B) and C)

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

In MS Access, you can use the ____________________ data type to define a column in your table that will be automatically populated with unique numeric values.

The use of the ____________________ operator allows you to compare a single value with a list of values returned by the first subquery (sqA) using a comparison operator other than EQUALS.

The following SQL statement uses a(n) ____. SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

An alternate syntax for a join is SELECT column-list FROM table1 JOIN table2 ____________________ (common-column).

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

A(n) ____________________ join returns not only the matching rows but also the rows with unmatched attribute values for one or both tables to be joined.

Procedural code is executed on the database client machine.

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.

What are SQL functions and when are they used? Provide a couple of examples of situations in which they are necessary.

In a subquery, the ____ query is executed first.

The Oracle string concatenation function is ____.

In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE) , basic loops (FOR and WHILE loops,) and error trapping.

Assume you are using the UNION operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator?

One of the disadvantages of stored procedures is that they increase network traffic.

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.