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	The program structure that executes program statements in order is	A. selection B. sequence C. repetition D. iteration
3	The columns of a table correspond to:	A. Table B. Record C. Field D. Cell
4	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
5	Which form of dependency is removed in 2NF?	A. Functional B. Transitive C. Associative D. Partial
6	In relational data base, a table is also called:	A. Tuple B. Relation C. File D. Schema
7	The entity integrity rule states that:	A. No primary key attribute can be null B. Each entity must have a primary key C. Primary key must have only one attribute D. None
8	Which of the following are anomalies that can be caused by redundancy in tables?	A. Insertion B. Deletion C. Modification D. All
9	Any array script should be:	A. Int B. Float C. Double D. Array
10	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