SQL FOR DATABASE CONSTRUCTION QUIZ

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

All of these

INSTEAD OF

AFTER

BEFORE

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

What is an advantage of placing computations in SQL views?

To accomplish both of the above.

None of these

To save users from having to write an expression.

To ensure that the results are consistent.

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

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

True

False

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑