SQL FOR DATABASE CONSTRUCTION QUIZ

The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A SQL view is a virtual table that is constructed from other tables or views.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A benefit of using a stored procedure is that it can be distributed to client computers.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL ALTER statement can be used to:

change the table data.

add rows to the table.

change the table structure.

delete rows from the table.

TRUE ANSWER : ?
YOUR ANSWER : ?

Three types of triggers are: BEFORE, AFTER and EXCEPTION.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is NOT one of the most common types of SQL CHECK constraints?

Lists of values

System date

Range checks

Comparing one column value to another within the same table

TRUE ANSWER : ?
YOUR ANSWER : ?

What is an advantage of placing computations in SQL views?

To save users from having to write an expression.

None of these

To accomplish both of the above.

To ensure that the results are consistent.

TRUE ANSWER : ?
YOUR ANSWER : ?

A ________ is a stored program that is attached to a table or a view.

pseudofile

trigger

embedded SELECT statement

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL DELETE statement is used to delete both the table structure and table data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A view that contains a computed column can be easily updated.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑