ICS Part 2 Computer Science Online Test With Answers

image
image
image

ICS Part 2 Computer Science Online Test

Sr. # Questions Answers Choice
1 An index may be created on: Primary key Secondary key Foreign key All
2 _______________ refers to a method of database distribution in which one database contains data that are included in another database. Splitting Partitioning Replication Dividing
3 _______________ refers to a method of database distribution in which different portions of database reside at different nodes in the network. Spliting Partitioning Replication Dividing
4 Which of the following is basic data distribution strategy? Centralized Partitioned Replication All
5 Which of the following is basic data distribution strategy? Centralized Partitioned Replication All
6 Organizing the database in computer disk storage is done in: Logical design Physical design Analysis Implimentation
7 An disadvantage of partitioning is: Complexity Extra space and update time Inconsistent access speed All
8 An advantage of partitioning is: Efficiency Extra space Reliabilty Accuracy
9 The relationship can be: One-to-one One-to-many Many-to-many All
10 Which of the following are ingredients of data modeling? Entities Attributes Relationship All
11 A factor to consider when choosing a file organization is: Fast retrieval Security Efficient storage All
12 A technique for physically arranging the records of a file on secondary storage devices is called: Physical pointer Retrieval program File organization Update program
13 A person's name, birthday and social security number are examples of: Attributes Entities Relationships Descriptors
14 Which of the following is NOT included in the definition of an entity? Person Object Concept Action
15 In an E-R diagram, a rectangle represents: Entity Attributes Relationship None
16 Customers,cars and parts are examples of: Entities Attributes Cardinals Relashionships
17 Which of the following is used to associate entities with one another? Entity Attribute Identifier Relationship
Download This Set
×