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

A. True
B. False


Correct Answer:  A. True

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

A. True
B. False


Correct Answer:  B. False

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

A. True
B. False


Correct Answer:  A. True

4. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

A. True
B. False


Correct Answer:  B. False

5. The SQL CHECK constraint is fully defined by the SQL-92 standard and is consistently implemented by all DBMS vendors.

A. True
B. False


Correct Answer:  B. False

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    five × five =