12th class Computer Science chapter 2 online mcq test with answers for ICS part 2 Computer Science chapter 2 (Basic Concepts and Terminology of Databases)

ICS Part 2 Computer Science Chapter 2 Online Test

Sr. #	Questions	Answers Choice
1	Which of the following are properties of relations?	Each attribute has a unique name No two rows in a relation are identical There are no multivalued attributes in a relation All of the above
2	An index can be used to :	Improve the performance of the database Document the structure of the database Reduce data dependency for application programs All
3	Which of the following is NOT a characteristic of relation?	Each row is unique The order of columns is significant The order of rows is insignificant Columns are all elemental or atomic
4	The data or information that describes an entity is called:	Attribute Data item Record Tuple
5	A person, place, thing or event about which data is kept in the database is called:	Attribute Field Record Entity
6	A row of a relation is called:	Attribute Entity Tuple a and c
7	An attribute is also known as a:	Table Row Relation Field
8	A relation is also known as:	Table Tuple Relationship Attributes
9	A table is a two-dimensional structure that consists of:	x and y co-ordinates Matrix elements Rows and columns Intersection of data
10	A two-dimensional table of data is called:	Group Set Module Relation
11	A table should have :	Primary key Secondary key Composite key Sort key
12	The forein key is found in:	Parent table Dependent table Pivot table Index table
13	The columns of a table correspond to:	Table Record Field Cell
14	SQL is used for:	Data definition Data manipulaton Data control All
15	CREATE command is used to create:	Record View Report Query
16	The number of characters in variable field is:	Constant Variable 10 100
17	The number of characters in fixed-length field is:	Constant Variable 10 100

Download This Set