SQL FOR DATABASE CONSTRUCTION QUIZ

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

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

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

FOREIGN KEY

PRIMARY KEY

ALTERNATE KEY

UNIQUE

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

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

SQL views can be used to hide:

None of these

complicated SQL syntax only.

columns and rows only.

both of the above can be hidden by an SQL view.

TRUE ANSWER : ?
YOUR ANSWER : ?

A ________ is a stored program that is attached to a table or a view.

trigger

embedded SELECT statement

pseudofile

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑