SQL FOR DATABASE CONSTRUCTION QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL ALTER statement can be used to:

delete rows from the table.

change the table structure.

add rows to the table.

change the table data.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL views can be used to hide:

columns and rows only.

complicated SQL syntax only.

both of the above can be hidden by an SQL view.

None of these

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 view that contains a computed column can be easily updated.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The VALUE constraint

The CHECK constraint

The LIMIT constraint

None of these

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 cannot be copied in mass from one table to another only.

rows can be modified according to criteria only.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑