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	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
2	The case block ends with:	A. End Select B. End case C. Break D. Case else
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 program structure that executes program statements in order is	A. selection B. sequence C. repetition D. iteration
5	How many table views are available in MS Access?	A. 1 B. 3 C. 2 D. 4
6	Another term for a conditional operator is:	A. Ternary B. Binary C. Byte D. Iteration
7	Storing the same information in two different ways or forms is called	A. database integrity B. redundant information C. homonyms D. mutually exclusive data
8	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
9	A constraint between two attributes is called:	A. Functional relation B. Attribute dependency C. Functional dependency D. Functional relation constaint
10	The value of expression in switch statement must be type of	A. int B. char C. float D. both a and b