SQL FOR DATABASE CONSTRUCTION QUIZ

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

False

True

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

SQL Server does not support the BEFORE trigger.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

BEFORE

AFTER

INSTEAD OF

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

A updatable view has its own data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL statements can be embedded in triggers, stored procedures, and program code.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

pseudofile

stored procedure

None of these

trigger

TRUE ANSWER : ?
YOUR ANSWER : ?

A reason for using an SQL view to hide columns is:

None of these

to accomplish both of the above.

to prevent the display of sensitive data only.

to simplify a result only.

TRUE ANSWER : ?
YOUR ANSWER : ?

What is an advantage of placing computations in SQL views?

To accomplish both of the above.

To ensure that the results are consistent.

None of these

To save users from having to write an expression.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑