SQL FOR DATABASE CONSTRUCTION QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

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

What is not an advantage of stored procedures?

SQL can be optimized

Code sharing

Greater security

Increased network traffic

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL command to create a table is:

MAKE TABLE

DEFINE TABLE

ALTER TABLE

CREATE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

A updatable view has its own data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The DROP TABLE statement:

deletes the table structure only.

is not an SQL statement.

deletes the table structure along with the table data.

works whether or not referential integrity constraints would be violated.

TRUE ANSWER : ?
YOUR ANSWER : ?

When using the SQL INSERT statement:

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

rows can be modified according to criteria only.

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

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

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 row in a particular underlying table.

a particular column in a particular row.

a particular column in a particular underlying table.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?