SQL FOR DATABASE CONSTRUCTION QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

stored procedure

trigger

pseudofile

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL statement to create a view is:

SELECT VIEW

INSERT VIEW

CREATE VIEW

MAKE VIEW

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL ALTER statement can be used to:

change the table data.

delete rows from the table.

change the table structure.

add rows to the table.

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

False

True

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

FOREIGN KEY

PRIMARY KEY

UNIQUE

ALTERNATE KEY

TRUE ANSWER : ?
YOUR ANSWER : ?