SQL FOR DATABASE CONSTRUCTION QUIZ

A updatable view has its own data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

The VALUE constraint

The CHECK constraint

The LIMIT constraint

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL command to create a table is:

CREATE TABLE

ALTER TABLE

MAKE TABLE

DEFINE TABLE

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

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

pseudofile

None of these

embedded SELECT statement

trigger

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

SQL Server does not support the BEFORE trigger.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Three types of triggers are: BEFORE, AFTER and EXCEPTION.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑