Tuesday, 30 June 2015

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:

No comments:

Post a Comment

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...