ICS Part 2 Computer Science Online Test With Answers

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

Is this page helpful?

Share your comments & questions here

Guest

  • No comments yet. Be the first to comment!