Exam 8: Advanced SQL

The IN subquery uses a(n)____________________ operator.

The Oracle string concatenation function is ____.

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

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

Oracle recommends ____ for creating audit logs.

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

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

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

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

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

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

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

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

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

A stored function is another name for a stored procedure.

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

Procedural code is executed on the database client machine.

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

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

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