SQL FOR DATABASE CONSTRUCTION QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

When using the SQL INSERT statement:

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

rows can be modified according to criteria only.

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.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

embedded SELECT statement

pseudofile

trigger

None of these

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.

None of these

a particular column in a particular underlying table.

a particular column in a particular row.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Lists of values

Comparing one column value to another within the same table

System date

Range checks

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Views can be used to show the results of computed columns.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

PRIMARY KEY

FOREIGN KEY

UNIQUE

ALTERNATE KEY

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL statement to create a view is:

MAKE VIEW

SELECT VIEW

CREATE VIEW

INSERT VIEW

TRUE ANSWER : ?
YOUR ANSWER : ?