Advanced Database Management System - Tutorials and Notes: Structured Query Language Quiz

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

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

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents