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 type of expression x > y is	A. arithmetic B. logical C. relational D. conditional
2	Storing the same information in two different ways or forms is called	A. database integrity B. redundant information C. homonyms D. mutually exclusive data
3	Which can be previewed on the screen before printing?	A. Report B. Form C. Sub-form D. None
4	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
5	The number of bytes used by 'int' data type in C are:	A. 2 B. 8 C. 12 D. 16
6	The operator that is used in decision making is	A. increment operator B. decrement operator C. condition operator D. none
7	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
8	The columns of a table correspond to:	A. Table B. Record C. Field D. Cell
9	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
10	A constraint between two attributes is called:	A. Functional relation B. Attribute dependency C. Functional dependency D. Functional relation constaint