Data Integrity and Normalization - MCQ Quiz

Data Integrity and Normalization - MCQs. Find the most important and more conceptual multiple-choice questions (MCQs) with answers of Computer Chapter No.4: Data Integrity and Normalization, ICS Part 2 | 2nd Year, on the database management system (DBMS) normalization for the interview and final examinations for all boards of Pakistan and entry test for admission in universities.

This post contains the multiple-choice questions (MCQs) - online quiz online on the data integrity & normalization that covers the topics i.e., entity integrity, referential integrity, normalization, partial & functional dependency, synonyms, homonyms, redundant information, mutually exclusive data, First Normal Form, Second Normal Form, and Third Normal Form.

 

➤ Database Design Process
➤ Basic Concepts & Terminology of Databases
➤ Data Basics
➤ Getting Started with C
➤ Elements of C
➤ Input/Output 
➤ Decision Constructs
➤ Loop Constructs
➤ Functions in C
➤ File Handling

Chapter No.4: 
Data Integrity and Normalization | MCQs

 

1. A relation is in 1st normal form if and only if its underlying domains contain?
   1.   atomic value
   2.   multiple values
   3.   unique values
   4.   none of these
2. For the 2nd normal for, which conditions should be fulfilled?
   1.   it should be in 1st NF
   2.   every non key attribute is functionally dependent on primary key
   3.   it should be in 1st NF & every non key attribute is functionally dependent on primary key
   4.   none of these
3. If same names are used for different attributes, the error is?
   1.   synonym
   2.   data redundancy
   3.   homonym
   4.   none of these
4. In a relation, consider X \(\rightarrow\) Y, here X is called?
   1.   dependent
   2.   depending
   3.   determinant
   4.   none of these
5. In a relation, consider X \(\rightarrow\) Y, here Y is called?
   1.   dependent
   2.   depending
   3.   determinant
   4.   none of these
6. In a relation, if value of an attribute A uniquely determines the value of an attribute B, the relationship is?
   1.   functional dependent
   2.   transitive
   3.   partial dependent
   4.   none of these
7. In database, a synonym is created when same attributes are given?
   1.   same names
   2.   duplicate names
   3.   different names
   4.   none of these
8. In mutually exclusive data, we can select?
   1.   single option
   2.   more than one options
   3.   we cannot select any option
   4.   none of these
9. In which normal form, study the relationship that were the repeating attributes came from and went to?
   1.   1st NF
   2.   2nd NF
   3.   3rd NF
   4.   none of these
10. Referential integrity is applied on ___ type of key?
    1.   primary key
    2.   candidate key
    3.   foreign key
    4.   composite key
11. The 3rd NF is based on the concept of?
    1.   partially dependency
    2.   transitive dependency
    3.   full dependency
    4.   none of these
12. The constraint which states that in a relation no primary key can have a null value?
    1.   entity integrity
    2.   referential integrity
    3.   DBMS integrity
    4.   all of these
13. The dependency in which one or more non-key attributes are dependent on other non-key attributes?
    1.   partially dependency
    2.   transitive dependency
    3.   full dependency
    4.   none of these
14. The dependency in which one or more non-key attributes are functionally on a part of primary key is called?
    1.   partially dependency
    2.   transitive dependency
    3.   full dependency
    4.   none of these
15. The process of efficiently organizing data in database is called?
    1.   correction of data
    2.   normalization
    3.   conversion
    4.   none of these
16. The studying of the entities or attribute lists to confirm that attributes are stored where they belong is called?
    1.   checking of data
    2.   normalization
    3.   reviewing
    4.   none of these
17. Which of the following is a type of data integrity in database?
    1.   entity integrity
    2.   DBMS integrity
    3.   referential integrity
    4.   entity & referential integrity
18. Which of the following is an anomaly in database?
    1.   insertion
    2.   deletion
    3.   update
    4.   all of these
19. Which of the following symbol is used to represent functional dependence?
    1.   arrow \((\rightarrow)\)
    2.   dot (.)
    3.   hyphen (-)
    4.   semicolon (;)
20. Which of the following term is consistency rules, the database must not violate?
    1.   data integration
    2.   data independence
    3.   database integrity
    4.   modality