SQL FOR DATABASE CONSTRUCTION QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL command to create a table is:

DEFINE TABLE

ALTER TABLE

MAKE TABLE

CREATE TABLE

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

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

embedded SELECT statement

None of these

pseudofile

trigger

TRUE ANSWER : ?
YOUR ANSWER : ?

What is an advantage of placing computations in SQL views?

To save users from having to write an expression.

To ensure that the results are consistent.

To accomplish both of the above.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

For what purposes are views used?

To hide complicated SQL statements only

To hide rows only

All of these

To hide columns only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL views can be used to hide:

complicated SQL syntax only.

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

None of these

columns and rows only.

TRUE ANSWER : ?
YOUR ANSWER : ?

A updatable view has its own data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑