SQL FOR DATABASE CONSTRUCTION QUIZ

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

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

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

INSTEAD OF

AFTER

All of these

BEFORE

TRUE ANSWER : ?
YOUR ANSWER : ?

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

stored procedure

None of these

pseudofile

trigger

TRUE ANSWER : ?
YOUR ANSWER : ?

For what purposes are views used?

To hide rows only

All of these

To hide complicated SQL statements only

To hide columns only

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL DELETE statement is used to delete both the table structure and table data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL command to create a table is:

CREATE TABLE

DEFINE TABLE

ALTER TABLE

MAKE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ALTERNATE KEY

UNIQUE

PRIMARY KEY

FOREIGN KEY

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑