SQL FOR DATABASE CONSTRUCTION QUIZ

What is an advantage of placing computations in SQL views?

To ensure that the results are consistent.

To save users from having to write an expression.

To accomplish both of the above.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

A reason for using an SQL view to hide columns is:

None of these

to simplify a result only.

to prevent the display of sensitive data only.

to accomplish both of the above.

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is NOT a type of SQL constraint?

FOREIGN KEY

ALTERNATE KEY

UNIQUE

PRIMARY KEY

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

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

A relation

A view

Query results

Just another table

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL statement used to create a view is CREATE VIEW.

False

True

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

↑