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 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
2	Two or more attributes with different name but same meaning create a problem:	A. Homonyms B. Synonyms C. Aliases D. Alternate attributes
3	The value of expression in switch statement must be type of	A. int B. char C. float D. both a and b
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	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
6	The goal of normalization is to:	A. Get stable data structure B. Increase number of relation C. Increase redundancy D. Remove constraints
7	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
8	Another term for a conditional operator is:	A. Ternary B. Binary C. Byte D. Iteration
9	The number of bytes used by 'int' data type in C are:	A. 2 B. 8 C. 12 D. 16
10	Which of the following is a decision making statement	A. break B. getch ( ) C. if D. all