SQL FOR DATABASE CONSTRUCTION QUIZ

The SQL statement to create a view is:

MAKE VIEW

SELECT VIEW

CREATE VIEW

INSERT VIEW

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The CHECK constraint

None of these

The VALUE constraint

The LIMIT constraint

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL command to create a table is:

CREATE TABLE

ALTER TABLE

MAKE TABLE

DEFINE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

a particular column in a particular row.

None of these

a particular column in a particular underlying table.

a particular row in a particular underlying table.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Views can be used to show the results of computed columns.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A benefit of using a stored procedure is that it can be distributed to client computers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑