SQL FOR DATABASE CONSTRUCTION QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

What is not an advantage of stored procedures?

Greater security

SQL can be optimized

Code sharing

Increased network traffic

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

The SQL command to create a table is:

MAKE TABLE

ALTER TABLE

CREATE TABLE

DEFINE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑