Database Management System and Design MCQ Test 01 Online for Preparation

1. The ascending order of a data hierarchy is ?

A. bit-byte- file-record- field-database

B. bit-byte- record-field- file-database

C. byte-bit- field-record- file-database

D. bit-byte- field-record- file-database

2. The function of a database is ?

A. to check all input data

B. to output data

C. to check all spelling

D. to collect and organize input data

3. Which of the following is a problem of file management system ?

A. difficult to update

B. lack of data independence

C. data redundancy

D. all of above

4. What is the language used by most of the DBMSs for helping their users to access data ?

A. SQL

B. 4GL

C. Query Language

D. High level language

5. Primitive operations common to all record management system include ?

A. sort

B. print

C. look-up

D. all of above

6. Information can be transferred between the DBMS and a ?

A. word processor program

B. graphics program

C. spreadsheet program

D. all of the above

7. In a large DBMS ?

A. each user can "see" only a small part of the entire database

B. each sub-schema contains every field in the logical schema

C. All above

D. each user can access every sub-schema

8. Which of the following is true of a network structure ?

A. It allows a many-to- many relationship

B. It is conceptually simple

C. t is a physical representation of the data

D. It will be dominant data base of the future

9. One data dictionary software package is called ?

A. DB/DC dictionary

B. TOTAL

C. ACCESS

D. Datapac

10. The model for a record management system might be ?

A. all of above

B. a Rolodex card file

C. a business form

D. handwritten list

Database Management System and Design MCQ Test 01 Online for Preparation

Leave a Reply Cancel reply