12th class (Fsc) computer unit 4 MCQs
chapter 4 MCQs 12th Class computer
Data Integrity and Normalization:
1. In 3NF, which form of dependency is removed?
a. Associative
b. Functional
c. Transitive
d. Non-functional
2. In relational database, a table is also called a:
a. File
b. Tuple
c. Schema
d. Relation
3. In 3NF, a non-key attribute must not depend on a(n):
a. Composite key
b. Non-key attribute
c. Sort key
d. Key attribute
4. Different attributes in two different tables having same name are referred to as:
a. Acronym
b. Synonym
c. Mutually exclusive
d. Homonym
5. Every relation must have a:
a. Secondary key
b. Primary key
c. Composite key
d. Candidate key
6. Transitive dependency is removed in:
a. 3rd normal form
b. 1st normal form
c. 4th normal form
d. 2nd normal form
7. The goal of normalization is to:
a. Get stable
b. Increase
c. Increasing anomalies data structure
d. Increase inconsistency redundancy
8. Two or more attributes having different names but same meaning is called:
a. Synonyms
b. Homonyms
c. Alternate attributes
d. Aliases
9. In 2NF, which form of dependency is removed?
a. Associative
b. Functional
c. Transitive
d. Partial
10. Referential integrity is applied on:
a. Primary key
b. Foreign key
c. Sort key
d. Composite key
11. A primary key that consists of two or more attributes of a relation is called:
a. Sub key
b. Sort key
c. Composite key
d. Candidate key
12. A primary key value cannot be null is what kind of integrity?
a. data integrity
b. referential integrity
c. security integrity
d. entity integrity
13. The entity integrity rule states that:
a. Primary key must have only one attribute
b. No primary key attribute can be null
c. Each entity must have a primary key
d. None
14. A rule that states that each foreign key value must match a primary key value in the other relation is called:
a. Entity key group rule
b. Referential integrity constraint
c. Foreign/primary match rule
d. Key match rule
15. A constraint between two attributes is called a(n):
a. Functional dependency
b. Functional relation
c. Functional relation constraint
d. Attribute dependency
16. The attribute on the left-hand side of the arrow in a functional dependency is:
a. Foreign key
b. Candidate key
c. Primary key
d. Determinant
17. The goal of normalization is to:
a. Increase redundancy
b. Get stable data structure
c. Increase number of relation
d. None
18. A relation is in 2NF if it is in 1NF and all its non-key attribute are:
a. Independent of the primary key
b. Dependent on part of the primary key
c. Independent of any other relation
d. Dependent on the primary key
19. Which of the following are anomalies that can be caused by redundancy in tables?
a. Modification
b. Insertion
c. Deletion
d. All
20. A functional dependency between two or more non-key attributes is called:
a. Transitive dependency
b. Partial functional dependency
c. Partial non key dependency
d. None
21. Which of the following anomalies result from a transitive dependency?
a. Deleting
b. Insertion
c. Modification
d. All
22. A relation is in third normal form if it is in second normal form and:
a. Independent of the key
b. Dependent on part of the key
c. Has no transitive dependencies
d. Dependent on all of the key
23. A relation that contains minimal redundancy and allows easy se is called:
a. Complex
b. Clean
c. Well structured
d. Simple
24. The 1NF describe the tabular format in which:
a. All attributes are dependent on primary key
b. All the key attributes are defined
c. No repeating groups in the table
d. All
Click here to go directly on chapter no.5