Database Management System and Design MCQ Test 02 Online for Preparation

1. A record management system ?

A. can be used to extract information stored in a computer file

B. always uses a list as its model

C. both a and b

D. can handle many files of information at a time

2. A command that lets you change one or more fields in a record is ?

A. insert

B. lookup

C. none of above

D. modify

3. A set of programs that handle a firm's database responsibilities is called ?

A. data management system (DMS)

B. database management system (DBMS)

C. all of above

D. database processing system (DBPS)

4. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time ?

A. transaction log

B. data manipulation language

C. report writer

D. query language

5. Which of the following is not an advantage of the database approach ?

A. program/data independence

B. all of the above

C. Ability of associate deleted data

D. Elimination of data redundancy

6. In the DBMS approach, application programs perform the ?

A. access control

B. storage function

C. all of the above

D. processing functions

7. A transparent DBMS ?

A. both b and c

B. keeps its logical structure hidden from users

C. can not hide sensitive information from users

D. keeps its physical structure hidden from users

8. Which of the following fields in a student file can be used as a primary key ?

A. GPA

B. Major

C. Social Security Number

D. class

9. Which is the make given to the database management system which is able to handle full text data, image data, audio and video ?

A. multimedia

B. graphics media

C. hypertext

D. full media

10. A file produced by a spreadsheet ?

A. none of the above

B. both a and b

C. can be used as is by the DBMS

D. is generally stored on disk in an ASCII text format

Database Management System and Design MCQ Test 02 Online for Preparation

Leave a Reply Cancel reply