SQL FOR DATABASE CONSTRUCTION QUIZ

SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Query results

A view

A relation

Just another table

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL command to create a table is:

CREATE TABLE

MAKE TABLE

ALTER TABLE

DEFINE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL statement to create a view is:

SELECT VIEW

MAKE VIEW

CREATE VIEW

INSERT VIEW

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL views can be used to hide:

both of the above can be hidden by an SQL view.

None of these

columns and rows only.

complicated SQL syntax only.

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

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

When using the SQL INSERT statement:

rows can be inserted into a table only one at a time only.

rows cannot be copied in mass from one table to another only.

rows can be modified according to criteria only.

rows can either be inserted into a table one at a time or in groups.

TRUE ANSWER : ?
YOUR ANSWER : ?