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	The scope of a variable refers to its:	A. Length B. Name C. Accessibility D. Data type
2	How many types of loop structure are available in C?	A. 4 B. 3 C. 2 D. 6
3	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
4	The value of expression in switch statement must be type of	A. int B. char C. float D. both a and b
5	How many table views are available in MS Access?	A. 1 B. 3 C. 2 D. 4
6	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
7	A constraint between two attributes is called:	A. Functional relation B. Attribute dependency C. Functional dependency D. Functional relation constaint
8	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
9	Which of the following anomalies result from a transitive dependency ?	A. Insertion B. Modification C. Deletion D. All
10	Every relation should have :	A. Primary key B. Candidate key C. Secondary key D. Mutually exclusiveness