SQL FOR DATABASE CONSTRUCTION QUIZ

Which of the following is NOT a type of SQL constraint?

UNIQUE

ALTERNATE KEY

FOREIGN KEY

PRIMARY KEY

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL views can be used to hide:

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

complicated SQL syntax only.

columns and rows only.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

embedded SELECT statement

None of these

trigger

pseudofile

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 underlying table.

a particular column in a particular row.

None of these

a particular row in a particular underlying table.

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

There are three SQL data modification operations: insert, modify and delete.

False

True

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.

True

False

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

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

rows can be modified according to criteria only.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

What is not an advantage of stored procedures?

Increased network traffic

SQL can be optimized

Greater security

Code sharing

TRUE ANSWER : ?
YOUR ANSWER : ?