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

For what purposes are views used?

To hide complicated SQL statements only

All of these

To hide rows only

To hide columns only

TRUE ANSWER : ?
YOUR ANSWER : ?

A updatable view has its own data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

to accomplish both of the above.

None of these

to simplify a result only.

to prevent the display of sensitive data only.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

pseudofile

trigger

stored procedure

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The VALUE constraint

None of these

The LIMIT constraint

The CHECK constraint

TRUE ANSWER : ?
YOUR ANSWER : ?

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑