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 31

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 32

Multiple Choice

Review LaterAdd Note

Review Later

The Oracle string concatenation function is ____.

A) CONCAT
B) +
C) ||
D) &&

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

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

When using a subquery,the output of a(n)____________________ query is used as the input for the outer query.

Oracle recommends ____ for creating audit logs.

A stored function is another name for a stored procedure.

The IN subquery uses a(n)____________________ operator.

Cursors are held in a reserved memory area in the client computer.

The Oracle equivalent to an MS Access AutoNumber is a(n) ____.

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

The statement SELECT * FROM T1,T2 produces a(n) ____ join.

A(n)____________________ join returns the Cartesian product JOIN of T1 and T2 and is sometimes called "old style".

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

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

The ____ data type is considered compatible with VARCHAR(35) .

The ANSI standard defines ____ type(s) of outer join(s)

The ____ pseudo-column is used to select the next value from a sequence.

A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.

The ____________________ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

Procedural code is executed on the database client machine.