Exam 8: Advanced Sql

If a user adds a new column to a table that already has rows, the existing rows will default to a value of _____ for the new column.

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

A(n) _____ routine pools multiple transactions into a single batch to update a master table field in a single operation.

Stored procedures must have at least one argument.

Which SQL format would be best used for a small, numeric data type?

Every PL/SQL block must be given a name.

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

In a 1:M relationship, a user must always create the table for the "_____" side first.

The Oracle string concatenation function is _____.

A table can be deleted from the database by using the _____ TABLE command.

A(n) _____ is a logical group of database objects, such as tables and indexes, that are related to each other.

The CREATE TABLE command lets you define constraints when you use the CONSTRAINT keyword, known as a(n) _____ constraint.

Triggers can only be used to update table values.

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