12th Class ICS Computer Science Chapter Wise Online MCQ Test With Answers PDF

ICS Part 2 Computer Science Online Test

Sr. #	Questions	Answers Choice
1	Which form of dependency is removed in 2NF?	Functional Transitive Associative Partial
2	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
3	The goal of normalization is to:	Get stable data structure Increase number of relation Increase redundancy Remove constraints
4	The attribute on the left side of the arrow in a functional dependency is called:	Candidate key Determinant Foreign key Primary key
5	A constraint between two attributes is called:	Functional relation Attribute dependency Functional dependency Functional relation constaint
6	Two or more attributes with different name but same meaning create a problem:	Homonyms Synonyms Aliases Alternate attributes
7	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
8	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
9	Every relation should have :	Primary key Candidate key Secondary key Mutually exclusiveness
10	Different attributes in two different tables having same name are called:	Synonym Homonym Acronym Mutually exclusive
11	In 3NF, a non-key attribute must not depend on a :	Non-key attribute Key attribute Composite key Sort key
12	In relational data base, a table is also called:	Tuple Relation File Schema
13	Which form of dependency is removed n 3NF?	Functional Non-functional Associative Transitive
14	Which of the following represents the entities?	Teacher Student Aero plane All
15	Which of the following activities are involved in data analysis?	Data flow diagram Decision Tables Decision Trees All
16	All of the following are components of physical database design EXCEPT:	Data volume and usage anylisis Data distribution strategy File organization Normalize the relations
17	Which component of physical database design refers to the consistency of data?	Indexes Integrity constaint File organization Data distribution strategy

Download This Set