SQL FOR DATABASE CONSTRUCTION QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A view that contains a computed column can be easily updated.

True

False

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

GROUP BY

WHERE

FROM

ORDER BY

TRUE ANSWER : ?
YOUR ANSWER : ?

When using the SQL INSERT statement:

rows can be modified according to criteria only.

rows can either be inserted into a table one at a time or in groups.

rows can be inserted into a table only one at a time only.

rows cannot be copied in mass from one table to another only.

TRUE ANSWER : ?
YOUR ANSWER : ?

For what purposes are views used?

All of these

To hide rows only

To hide columns only

To hide complicated SQL statements only

TRUE ANSWER : ?
YOUR ANSWER : ?

Common types of SQL CHECK constraints include range checks and limiting columns values.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑