Database Management System and Design MCQ Test 02 Online for Preparation

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

A. all of the above

B. program/data independence

C. Elimination of data redundancy

D. Ability of associate deleted data

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

A. database processing system (DBPS)

B. all of above

C. data management system (DMS)

D. database management system (DBMS)

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

A. lookup

B. insert

C. modify

D. none of above

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

A. all of the above

B. processing functions

C. access control

D. storage function

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

A. GPA

B. Social Security Number

C. class

D. Major

6. A record management system ?

A. both a and b

B. can handle many files of information at a time

C. always uses a list as its model

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

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

A. full media

B. graphics media

C. hypertext

D. multimedia

8. 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. query language

B. data manipulation language

C. report writer

D. transaction log

9. 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

10. A transparent DBMS ?

A. keeps its logical structure hidden from users

B. keeps its physical structure hidden from users

C. both b and c

D. can not hide sensitive information from users

Database Management System and Design MCQ Test 02 Online for Preparation

Leave a Reply Cancel reply