12th class Computer Science chapter 4 online mcq test with answers for ICS part 2 Computer Science chapter 4 (Data Integrity and Normalization)

ICS Part 2 Computer Science Chapter 4 Online Test

Sr. #	Questions	Answers Choice
1	The 1NF describes the tabular format in which:	All the key attributes are defined No repeating groups in the table All attributes are dependent on primary key All
2	A relation is in third normal form if it is in second normal form and:	Dependent on part of the key Dependent on the whole key Independent of the key Has no transitive dependencies
3	Which of the following anomalies result from a transitive dependency ?	Insertion Modification Deletion All
4	A functional dependency between two or more non-key attributes is called:	Partial functional dependency Partial non-key dependency Transitive dependency None
5	Which of the following are anomalies that can be caused by redundancy in tables?	Insertion Deletion Modification All
6	Which form of dependency is removed in 2NF?	Functional Transitive Associative Partial
7	A relation is in 2NF if it is in 1NF and all its non-key attributes are:	Dependent on part of the primary key Dependent on the entire primary key Independent on the primary key Independent of any other relation
8	The goal of normalization is to:	Get stable data structure Increase number of relation Increase redundancy Remove constraints
9	The attribute on the left side of the arrow in a functional dependency is called:	Candidate key Determinant Foreign key Primary key
10	A constraint between two attributes is called:	Functional relation Attribute dependency Functional dependency Functional relation constaint
11	Two or more attributes with different name but same meaning create a problem:	Homonyms Synonyms Aliases Alternate attributes
12	A rule that states each foreign key value must match a primary key value in the other relation is called:	Referential integrity constraints Key match rule Entity key group rule Foreign/ primary match rule
13	The entity integrity rule states that:	No primary key attribute can be null Each entity must have a primary key Primary key must have only one attribute None
14	Every relation should have :	Primary key Candidate key Secondary key Mutually exclusiveness
15	Different attributes in two different tables having same name are called:	Synonym Homonym Acronym Mutually exclusive
16	In 3NF, a non-key attribute must not depend on a :	Non-key attribute Key attribute Composite key Sort key
17	In relational data base, a table is also called:	Tuple Relation File Schema

Download This Set