SQL FOR DATABASE CONSTRUCTION QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL ALTER statement can be used to:

add rows to the table.

change the table structure.

delete rows from the table.

change the table data.

TRUE ANSWER : ?
YOUR ANSWER : ?

When using the SQL INSERT statement:

rows can be inserted into a table only one at a time only.

rows can either be inserted into a table one at a time or in groups.

rows can be modified according to criteria only.

rows cannot be copied in mass from one table to another only.

TRUE ANSWER : ?
YOUR ANSWER : ?

Common types of SQL CHECK constraints include range checks and limiting columns values.

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 : ?

A updatable view has its own data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A stored procedure is a program that performs some common action on database data and is stored in the database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

FROM

WHERE

GROUP BY

ORDER BY

TRUE ANSWER : ?
YOUR ANSWER : ?

↑