SQL FOR DATABASE CONSTRUCTION QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL statements can be embedded in triggers, stored procedures, and program code.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

All of these

AFTER

BEFORE

INSTEAD OF

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Comparing one column value to another within the same table

System date

Lists of values

Range checks

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

The LIMIT constraint

The VALUE constraint

The CHECK constraint

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

↑