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 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
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	C was developed in the year:	A. 1970 B. 1972 C. 1976 D. 1995
4	The value of expression in switch statement must be type of	A. int B. char C. float D. both a and b
5	Which can be previewed on the screen before printing?	A. Report B. Form C. Sub-form D. None
6	The type of expression x > y is	A. arithmetic B. logical C. relational D. conditional
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	Which form of dependency is removed n 3NF?	A. Functional B. Non-functional C. Associative D. Transitive
9	The 1NF describes the tabular format in which:	A. All the key attributes are defined B. No repeating groups in the table C. All attributes are dependent on primary key D. All
10	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