SQL FOR DATABASE CONSTRUCTION QUIZ

What is an SQL virtual table that is constructed from other tables?

Just another table

Query results

A relation

A view

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL command to create a table is:

DEFINE TABLE

ALTER TABLE

MAKE TABLE

CREATE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

A view that contains a computed column can be easily updated.

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Common types of SQL CHECK constraints include range checks and limiting columns values.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL statement to create a view is:

MAKE VIEW

SELECT VIEW

INSERT VIEW

CREATE VIEW

TRUE ANSWER : ?
YOUR ANSWER : ?

A SQL view is a virtual table that is constructed from other tables or views.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

FOREIGN KEY

PRIMARY KEY

ALTERNATE KEY

UNIQUE

TRUE ANSWER : ?
YOUR ANSWER : ?

↑