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	Which form of dependency is removed in 2NF?	A. Functional B. Transitive C. Associative D. Partial
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	Different attributes in two different tables having same name are called:	A. Synonym B. Homonym C. Acronym D. Mutually exclusive
4	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
5	Which can be previewed on the screen before printing?	A. Report B. Form C. Sub-form D. None
6	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
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 value of expression in switch statement must be type of	A. int B. char C. float D. both a and b
9	The type of expression x > y is	A. arithmetic B. logical C. relational D. conditional
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