Exam 8: Advanced Sql

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

UNION, INTERSECT, and MINUS work properly only if relations are intersect-compatible, which means that the names of the relation attributes and their data types must be different.

Explain the different basic types of join operations. What are they and how do they work?

The syntax for a left outer join is .

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

The Oracle function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

is a cursor attribute that returns True if the last FETCH returned a row, and FALSE if not.

MySQL allows multiple triggering conditions per trigger.

The Oracle string concatenation function is .

A(n) join will select only the rows with matching values in the common attribute(s).

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

Oracle recommends for creating audit logs.

The statement can be used to combine rows from two queries, returning only the rows that appear in both sets.

The determines the common attribute or attributes by looking for identically named attributes and compatible data types.

Oracle uses the function to extract the various parts of a date.

A(n) query can be used to produce a relation that retains the duplicate rows.

Describe the important features and applications of SQL functions

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

The statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

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