Database Management System and Design MCQ Test 03 Online for Preparation

1. If a piece of data is stored in two places in the database, then ?

A. changing the data in one spot will cause data inconsistency

B. storage space is wasted

C. in can be more easily accessed

D. both and b

2. Which of the following is not true of the traditional approach to information processing ?

A. there is common sharing of data among the various applications

B. it is file oriented

C. it is inflexible

D. programs are dependent on the file

3. Large collection of files are called ?

A. database

B. fields

C. records

D. sectors

4. Sort/Report generators ?

A. are faster than index/report generators

B. require more disk space than indexed/report generators

C. do not need to sort before generating report

D. both a and b

5. An audit trail ?

A. is the recorded history of operations performed on a file

B. is used to make backup copies

C. can be used to restore lost information

D. none of the above

6. Batch processing is appropriate if ?

A. only a few transactions are involved

B. only a small computer system is available

C. none of the above

D. large computer system is available

7. In order to use a record management system ?

A. you need to understand the low level details of how information is stored

B. none of the above

C. you need to understand the model the record management system uses

D. both a and b

8. Which of the following hardware component is the most important to the operation of database management system ?

A. high resolution video display

B. high speed, large capacity disk

C. printer

D. plotter

9. Which of the following is not a relational database ?

A. 4th Dimension

B. dBase IV

C. Reflex

D. FoxPro

10. Large collection of files are called ?

A. database

B. fields

C. sectors

D. records

Database Management System and Design MCQ Test 03 Online for Preparation

Database Management System and Design MCQs Test 03 Online for Preparation

Leave a Reply Cancel reply