ICS Part 2 Computer Science Online Test With Answers

image
image
image

ICS Part 2 Computer Science Online Test

Sr. # Questions Answers Choice
1 Which of the following is used to describe the characteristics of an object? Attribute Relationship Cardinality Modality
2 A data model is : A logical representation of the structure of the database Shown as an entity-relationship diagram Transformed into tables and relationships All
3 In hybrid distribution, what types of fragments are stored at only one site? Critical fragments Non-critical fragments Critical and non-critical fragments Only large fragments
4 An entity related to itself in an ERD model refers to : Recursive relationship One-to-many relationship Many-to-many relationship One-to-one relationship
5 Which of the following keys us not unique: Candidate key Forein key Primary key Secondary key
6 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
7 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
8 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
9 The data or information that describes an entity is called: Attribute Data item Record Tuple
10 A person, place, thing or event about which data is kept in the database is called: Attribute Field Record Entity
11 A row of a relation is called: Attribute Entity Tuple a and c
12 An attribute is also known as a: Table Row Relation Field
13 A relation is also known as: Table Tuple Relationship Attributes
14 A table is a two-dimensional structure that consists of: x and y co-ordinates Matrix elements Rows and columns Intersection of data
15 A two-dimensional table of data is called: Group Set Module Relation
16 A table should have : Primary key Secondary key Composite key Sort key
17 The forein key is found in: Parent table Dependent table Pivot table Index table
Download This Set