Exam 8: Advanced Sql

A(n) join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

Variables can be declared inside a stored procedure.

Triggers can only be used to update table values.

functions extract a value of a given data type and convert it to the equivalent value in another data type.

When the critical application code is isolated in a single program, improves.

An explicit cursor must return two or more rows.

Every PL/SQL block must be given a name.

To test a trigger, one should use the EXECUTE TRIGGER command.

Stored procedures are executed using the EXEC command.