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 are basic data distribution strategies?	A. Centralized B. Partitioned C. Replication D. All
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	The case block ends with:	A. End Select B. End case C. Break D. Case else
4	Any array script should be:	A. Int B. Float C. Double D. Array
5	The program structure that executes program statements in order is	A. selection B. sequence C. repetition D. iteration
6	The value of expression in switch statement must be type of	A. int B. char C. float D. both a and b
7	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
8	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
9	------------ is a constraint on primary values that states that no attribute of a primary key should contain nulls	A. referential integrity B. entity integrity C. normalization D. acronyms
10	In 3NF, a non key attribute must not depend on a	A. non key attribute B. key attribute C. composite key D. sort key