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 of the following anomalies result from a transitive dependency ?	A. Insertion B. Modification C. Deletion D. All
2	Different attributes in two different tables having same name are called:	A. Synonym B. Homonym C. Acronym D. Mutually exclusive
3	The case block ends with:	A. End Select B. End case C. Break D. Case else
4	The operator that is used in decision making is	A. increment operator B. decrement operator C. condition operator D. none
5	Which are basic data distribution strategies?	A. Centralized B. Partitioned C. Replication D. All
6	Another term for a conditional operator is:	A. Ternary B. Binary C. Byte D. Iteration
7	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
8	The attribute on the left side of the arrow in a functional dependency is called:	A. Candidate key B. Determinant C. Foreign key D. Primary key
9	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
10	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