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 can be previewed on the screen before printing?	A. Report B. Form C. Sub-form D. None
2	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
3	Which of the following is a decision making statement	A. break B. getch ( ) C. if D. all
4	Any array script should be:	A. Int B. Float C. Double D. Array
5	------------- is the process of converting complex data structures into simple and stable data structures	A. database integrity B. homonyms C. normalization D. mutually exclusive data
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	Which of the following are anomalies that can be caused by redundancy in tables?	A. Insertion B. Deletion C. Modification D. All
9	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
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