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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) indexed
B) core
C) relation
D) base

E) None of the above
F) All of the above

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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.

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

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

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

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.

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 assigns a value to an attribute when a new row is added to a table.

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

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

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.

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

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

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

How are triggers critical to proper database operation and management?

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

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