SQL FOR DATABASE CONSTRUCTION QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

What is an advantage of placing computations in SQL views?

None of these

To save users from having to write an expression.

To accomplish both of the above.

To ensure that the results are consistent.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

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

All of these

BEFORE

AFTER

INSTEAD OF

TRUE ANSWER : ?
YOUR ANSWER : ?

What is not an advantage of stored procedures?

Code sharing

Greater security

Increased network traffic

SQL can be optimized

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

There are three SQL data modification operations: insert, modify and delete.

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

↑