DIGITAL ELECTRONICS QUIZ

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

None of these

a particular row in a particular underlying table.

a particular column in a particular underlying table.

a particular column in a particular row.

TRUE ANSWER : ?
YOUR ANSWER : ?

What is an advantage of placing computations in SQL views?

To ensure that the results are consistent.

None of these

To accomplish both of the above.

To save users from having to write an expression.

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

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

Range checks

System date

Comparing one column value to another within the same table

Lists of values

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL DELETE statement is used to delete both the table structure and table data.

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

What is an SQL virtual table that is constructed from other tables?

Just another table

Query results

A view

A relation

TRUE ANSWER : ?
YOUR ANSWER : ?

What is not an advantage of stored procedures?

Increased network traffic

Greater security

SQL can be optimized

Code sharing

TRUE ANSWER : ?
YOUR ANSWER : ?

A trigger is a stored program that is attached to a database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?