SQL FOR DATABASE CONSTRUCTION QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A SQL view is a virtual table that is constructed from other tables or views.

True

False

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 column in a particular underlying table.

a particular column in a particular row.

None of these

a particular row in a particular underlying table.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

What is not an advantage of stored procedures?

Code sharing

SQL can be optimized

Greater security

Increased network traffic

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL statement to create a view is:

SELECT VIEW

CREATE VIEW

MAKE VIEW

INSERT VIEW

TRUE ANSWER : ?
YOUR ANSWER : ?

A updatable view has its own data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑