ANTIGEN QUIZ

The SQL ALTER statement can be used to:

change the table data.

add rows to the table.

change the table structure.

delete rows from the table.

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

SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is NOT one of the most common types of SQL CHECK constraints?

System date

Comparing one column value to another within the same table

Range checks

Lists of values

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A updatable view has its own data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The DROP TABLE statement:

deletes the table structure only.

is not an SQL statement.

works whether or not referential integrity constraints would be violated.

deletes the table structure along with the table data.

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑