SQL for Database Construction - Practice Questions

Question 1

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

Accepted Answer

Question 2

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

Accepted Answer

Question 3

The DROP TABLE statement:

Accepted Answer

Question 4

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

Accepted Answer

Question 5

The SQL command to create a table is:

Accepted Answer

Question 6

SQL views can be used to hide:

Accepted Answer

Question 7

What is not an advantage of stored procedures?

Accepted Answer

Question 8

What SQL structure is used to limit column values of a table?

Accepted Answer

Question 9

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

Accepted Answer

Question 10

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

Accepted Answer