Structured Query Language Quiz

Relational model and Normalization Quiz

1. In a CREATE TABLE statement, each column/attribute must have a data type associated with it. TRUE / FALSE?

TRUE
FALSE

2. Referential integrity ensures that a value stored in the foreign key attribute matches a primary key attribute in the referred table. TRUE/FALSE?

TRUE
FALSE

3. A view is part of the external schema and is considered as an acceptable way to offer simpler tables with customized attribute names to the user. TRUE/FALSE?

TRUE
FALSE

4. A view can be referred to like a table in a SELECT. TRUE/FALSE?

TRUE
FALSE

5. Besides a shorthand reference to the table throughout the query, using an alias makes the query run much faster as a result. TRUE/FALSE?

TRUE
FALSE

6. Deleting from a view that is based on a natural join of its base tables is acceptable. TRUE/FALSE?

TRUE
FALSE

7. If both NOT NULL and UNIQUE integrity constraints are defined on an attribute, the designation implies that the attribute is a candidate key. TRUE/FALSE?

TRUE
FALSE

8. An INSERT requires the input values sequence to match the attribute sequence when the attributes are specified in the INSERT statement. TRUE/FALSE?

TRUE
FALSE

9. The SQL SELECT statement includes the sequence of steps to exectue a query besides the operations that the server uses to answer the query. TRUE/FALSE?

TRUE
FALSE

10. Triggers provide a mechanism to monitor specific changes to a table and perform additional actions based on the altered data. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers: