Exam 8: Advanced Sql

A row-level trigger requires use of the _____ keywords and is executed once for each row affected by the triggering statement.

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

The_____ constraint assigns a value to an attribute when a new row is added to a table.

A common practice is to create a(n) _____ on any field that is used as a search key, in comparison operations in a conditional expression, or when a user wants to list rows in a specific order.

SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language.

U.S. state abbreviations are always two characters, so _____(2) is a logical choice for the data type representing a state column.

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.

The _____ command is used to restore the database to its previous condition.

BEFORE means before the changes are made in memory but after the changes are permanently saved to disk.

No matter what language you use, if it contains embedded SQL statements, it is called the _____ language.

When writing SQL table-creating command sequences, the entire table definition is enclosed in _____.

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

An explicit cursor must return two or more rows.

The _____ constraint is used to validate data when an attribute value is entered.

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

_____is the process the DBMS uses to verify that only registered users access the database.

The tables on whicha view, or a virtual tablederived froma SELECT query, are based are called _____tables.

You cannot have an invalid entry in the foreign key column; at the same time, you cannot delete a vendor row as long as a product row references that vendor. This isknown as _____.

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

How are triggers critical to proper database operation and management?