SQL FOR DATABASE CONSTRUCTION QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The DROP TABLE statement:

is not an SQL statement.

deletes the table structure only.

deletes the table structure along with the table data.

works whether or not referential integrity constraints would be violated.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

BEFORE

All of these

INSTEAD OF

AFTER

TRUE ANSWER : ?
YOUR ANSWER : ?

A ________ is a stored program that is attached to a table or a view.

embedded SELECT statement

pseudofile

trigger

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

to simplify a result only.

to prevent the display of sensitive data only.

to accomplish both of the above.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

A ________ is a program that performs some common action on database data and that is stored in the database.

trigger

None of these

pseudofile

stored procedure

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL ALTER statement can be used to:

add rows to the table.

delete rows from the table.

change the table data.

change the table structure.

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL views can be used to hide:

complicated SQL syntax only.

columns and rows only.

both of the above can be hidden by an SQL view.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

A relation

A view

Just another table

Query results

TRUE ANSWER : ?
YOUR ANSWER : ?

↑