ADVANCED SQL QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

GROUP BY

ORDER BY

WHERE

FROM

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A trigger is a stored program that is attached to a database.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

For what purposes are views used?

To hide complicated SQL statements only

To hide rows only

To hide columns only

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

to prevent the display of sensitive data only.

None of these

to accomplish both of the above.

to simplify a result only.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

a particular row in a particular underlying table.

a particular column in a particular row.

a particular column in a particular underlying table.

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑