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

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

trigger

pseudofile

None of these

stored procedure

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an SQL trigger supported by Oracle?

AFTER

INSTEAD OF

All of these

BEFORE

TRUE ANSWER : ?
YOUR ANSWER : ?

What is not an advantage of stored procedures?

Code sharing

Increased network traffic

SQL can be optimized

Greater security

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑