FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Advanced Sql

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) NOT NULL
B) CASCADE
C) UNIQUE
D) DEFAULT

E) A) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

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

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

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

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 _____.

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

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

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

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

An explicit cursor must return two or more rows.

How are triggers critical to proper database operation and management?

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

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.

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

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

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.

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

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