SQL FOR DATABASE CONSTRUCTION QUIZ

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

The SQL statement used to create a view is CREATE VIEW.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an SQL trigger supported by Oracle?

All of these

INSTEAD OF

AFTER

BEFORE

TRUE ANSWER : ?
YOUR ANSWER : ?

If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

True

False

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

The SQL ALTER statement can be used to:

delete rows from the table.

add rows to the table.

change the table data.

change the table structure.

TRUE ANSWER : ?
YOUR ANSWER : ?

A benefit of using a stored procedure is that it can be distributed to client computers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Range checks

Lists of values

Comparing one column value to another within the same table

System date

TRUE ANSWER : ?
YOUR ANSWER : ?

For what purposes are views used?

To hide rows only

To hide complicated SQL statements only

All of these

To hide columns only

TRUE ANSWER : ?
YOUR ANSWER : ?