FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Advanced Sql

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is a feature of a correlated subquery?

A) The inner subquery executes first.
B) The outer subquery initiates the process of execution in a subquery.
C) The inner subquery initiates the process of
D) The outer subquery executes independent
execution in a subquery. of the inner subquery

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

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

A(n) subquery is a subquery that executes once for each row in the outer query.

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

Stored procedures help reduce code duplication by means of code isolation and code sharing.

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

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

The IN subquery uses a(n) operator.

The data type is compatible with NUMBER.

Assume a designer is 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 Jenna and Howard are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator?

Cursor-style processing involves retrieving data from the cursor, one row at a time.

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

A row-level trigger requires use of the keywords and is executed once for each row affected by the triggering statement.

Assume you are using the INTERSECT 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 INTERSECT operator?

Describe the characteristics of an Oracle sequence.

Using Oracle , a designer can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

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

The syntax for the UNION query is .

A(n) is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

A join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

The statement combines the output of two SELECT queries.