ICS Part 2 Computer Science Chapter 3 Online Test With Answers

image
image
image

ICS Part 2 Computer Science Chapter 3 Online Test

Sr. # Questions Answers Choice
1 Which of the following represents the entities? Teacher Student Aero plane All
2 Which of the following activities are involved in data analysis? Data flow diagram Decision Tables Decision Trees All
3 All of the following are components of physical database design EXCEPT: Data volume and usage anylisis Data distribution strategy File organization Normalize the relations
4 Which component of physical database design refers to the consistency of data? Indexes Integrity constaint File organization Data distribution strategy
5 An index may be created on: Primary key Secondary key Foreign key All
6 _______________ refers to a method of database distribution in which one database contains data that are included in another database. Splitting Partitioning Replication Dividing
7 _______________ refers to a method of database distribution in which different portions of database reside at different nodes in the network. Spliting Partitioning Replication Dividing
8 Which of the following is basic data distribution strategy? Centralized Partitioned Replication All
9 Which of the following is basic data distribution strategy? Centralized Partitioned Replication All
10 Organizing the database in computer disk storage is done in: Logical design Physical design Analysis Implimentation
11 An disadvantage of partitioning is: Complexity Extra space and update time Inconsistent access speed All
12 An advantage of partitioning is: Efficiency Extra space Reliabilty Accuracy
13 The relationship can be: One-to-one One-to-many Many-to-many All
14 Which of the following are ingredients of data modeling? Entities Attributes Relationship All
15 A factor to consider when choosing a file organization is: Fast retrieval Security Efficient storage All
16 A technique for physically arranging the records of a file on secondary storage devices is called: Physical pointer Retrieval program File organization Update program
17 A person's name, birthday and social security number are examples of: Attributes Entities Relationships Descriptors
Download This Set
×