Exam 8: Advanced Sql

A persistent stored module is stored and executed on the database client machine.

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

Using the _____ command, SQL indexes can be created on the basis of any selected attribute.

The DECLARE section in the trigger is used to declare any variables used inside the trigger code.

A(n) _____ cursor is automatically created in procedural SQL when the SQL statement returns only one value.

If the NOT NULL and UNIQUE specifications are not supported when using a command sequence, use _____ without the specifications.

To delete an index, one must use the _____ command.

When you create a new database, the RDBMS automatically creates the data_____ tables in which to store the metadata and creates a default database administrator.

The PL/SQL block starts with the _____ section.

A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

Oracle recommends _____ for creating audit logs.

To make the SQL code more _____, most SQL programmers use one line per column (attribute) definition.

Which command is used to save changes to the database? What is the syntax for this command?

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

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

SQL requires the use of the _____ command to enter data into a table.

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

In an INSERT command, a user can indicate just the attributes that have required values by listing the _____ inside parentheses after the table name.

In MS Access, a designer can use the _____ data type to define a column in his table that will be automatically populated with unique numeric values.

Just like database triggers, stored procedures are stored in the database.