Database Quiz

 



Database Quiz contain set of 10 MCQ questions for Database MCQ which will help you to clear beginner level quiz.



1. The DBMS acts as an interface between what two components of an enterprise-class database system?
A. Database application and the database
B. Data and the database
C.T he user and the database application
D. Database application and SQL
 
2. The following are components of a database except ________ .
A. user data
B. metadata
C. reports
D. indexes
 
3. Helping people keep track of things is the purpose of a(n) ________ .
A. database     
B. table
C. instance
D. relationship
 
4. The different classes of relations created by the technique for preventing modification anomalies are called:
A. normal forms.
B.referential integrity constraints.
C. functional dependencies.
D. None of the above is correct.
 
5. The primary key is selected from the:
A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.
 
 
6. A functional dependency is a relationship between or among:
A. tables.
B. r ows.
C. relations.
D. attributes.
 
 
7. In the relational model, relationships between relations or tables are created by using:
A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.
 
8. A transitive dependency is which of the following?
A. A functional dependency between two or more key attributes.
B. A functional dependency between two or more non key attributes.
C. A relation that is in first normal form.
D. A relation that is in second normal form.
 
9. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form
 
10. The relational model consists of:
A. data in the form of tables.
B. data redundancy.
C. operations using non-SQL languages.
D. unorganized data.