12th class Computer Science chapter 4 online mcq test with answers for ICS part 2 Computer Science chapter 4 (Data Integrity and Normalization)

Top Scorers Of Chapter 0 "ICS Part 2 Computer Science Chapter 4 Online Test" MCQ`s Test

Sr.#	Question	Answer
1	Which of the following anomalies result from a transitive dependency ?	A. Insertion B. Modification C. Deletion D. All
2	A relation is in 2NF if it is in 1NF and all its non-key attributes are:	A. Dependent on part of the primary key B. Dependent on the entire primary key C. Independent on the primary key D. Independent of any other relation
3	The type of expression x > y is	A. arithmetic B. logical C. relational D. conditional
4	Which of the following is a decision making statement	A. break B. getch ( ) C. if D. all
5	Which form of dependency is removed n 3NF?	A. Functional B. Non-functional C. Associative D. Transitive
6	Every relation should have :	A. Primary key B. Candidate key C. Secondary key D. Mutually exclusiveness
7	A relation is in third normal form if it is in second normal form and:	A. Dependent on part of the key B. Dependent on the whole key C. Independent of the key D. Has no transitive dependencies
8	The 1NF describes the tabular format in which:	A. All the key attributes are defined B. No repeating groups in the table C. All attributes are dependent on primary key D. All
9	How many types of loop structure are available in C?	A. 4 B. 3 C. 2 D. 6
10	The entity integrity rule states that:	A. No primary key attribute can be null B. Each entity must have a primary key C. Primary key must have only one attribute D. None