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 conditional part of if statement consists of expression	A. arithmetic B. logical expression C. relational D. both b and c
2	In 3NF, a non-key attribute must not depend on a :	A. Non-key attribute B. Key attribute C. Composite key D. Sort key
3	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
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	------------------- is created when two different names are used for the same information	A. synonyms B. homonyms C. mutually exclusive data D. redundant information
6	Another term for a conditional operator is:	A. Ternary B. Binary C. Byte D. Iteration
7	Database integrity refers to the	A. correctness of data B. consistency of data C. both a and b D. none of these
8	In 3NT which form of dependency is removed ?	A. functional B. non-functional C. associative D. transitive
9	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
10	Which can be previewed on the screen before printing?	A. Report B. Form C. Sub-form D. None