ENVIRONMENTAL ENGINEERING QUIZ

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 of the following is an SQL trigger supported by Oracle?

AFTER

INSTEAD OF

BEFORE

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL ALTER statement can be used to:

change the table structure.

change the table data.

add rows to the table.

delete rows from the table.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The LIMIT constraint

The CHECK constraint

None of these

The VALUE constraint

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A trigger is a stored program that is attached to a database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

embedded SELECT statement

trigger

None of these

pseudofile

TRUE ANSWER : ?
YOUR ANSWER : ?

↑