SQL FOR DATABASE CONSTRUCTION QUIZ

The DROP TABLE statement:

works whether or not referential integrity constraints would be violated.

deletes the table structure along with the table data.

is not an SQL statement.

deletes the table structure only.

TRUE ANSWER : ?
YOUR ANSWER : ?

A trigger is a stored program that is attached to a database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

System date

Lists of values

Comparing one column value to another within the same table

Range checks

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL statement used to create a view is CREATE VIEW.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL statements can be embedded in triggers, stored procedures, and program code.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

a particular column in a particular row.

a particular row in a particular underlying table.

a particular column in a particular underlying table.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

What SQL structure is used to limit column values of a table?

The VALUE constraint

The CHECK constraint

None of these

The LIMIT constraint

TRUE ANSWER : ?
YOUR ANSWER : ?

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

ORDER BY

GROUP BY

WHERE

FROM

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?