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	In 3NF, a non-key attribute must not depend on a :	A. Non-key attribute B. Key attribute C. Composite key D. Sort key
2	The program structure that executes program statements in order is	A. selection B. sequence C. repetition D. iteration
3	A functional dependency between two or more non-key attributes is called:	A. Partial functional dependency B. Partial non-key dependency C. Transitive dependency D. None
4	The attribute on the left side of the arrow in a functional dependency is called:	A. Candidate key B. Determinant C. Foreign key D. Primary key
5	Which of the following are anomalies that can be caused by redundancy in tables?	A. Insertion B. Deletion C. Modification D. All
6	Which form of dependency is removed in 2NF?	A. Functional B. Transitive C. Associative D. Partial
7	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
8	The case block ends with:	A. End Select B. End case C. Break D. Case else
9	In 3NF, a non key attribute must not depend on a	A. non key attribute B. key attribute C. composite key D. sort key
10	A rule that states each foreign key value must match a primary key value in the other relation is called:	A. Referential integrity constraints B. Key match rule C. Entity key group rule D. Foreign/ primary match rule