Database Systems MCQ Questions & Answers | Computer Science

A. DASD

B. FMS

C. EMMS

D. DBMS

E. None of the above

A. elimination of the data redundancy

B. ability to associate related data

C. increased security

D. program/data independence

E. All of the above are advantages

A. where data is located

B. the size of the disk storage device

C. It allows a many-to-many relationship

D. It is conceptually simple

E. It will be the dominant data base of the future

A. reducing storage space requirements

B. improving data integrity

C. protecting data in data communication systems

D. All of the above

E. None of the above

A. Database

B. Table

C. Record

D. Flat File

E. None of the above

A. is the entire database

B. is a standard way of organizing information into accessible parts

C. describes how data is actually stored on disk

D. All of the above

E. None of the above

A. are written in English

B. can use aggregate functions like SUM and COUNT

C. both (a) and (b)

D. All of the above

E. None of the above

A. You need to understand the low-level details of how information in stored

B. You need to understand the model the record management system uses.

C. Both (a) and (b)

D. All of the above

E. None of the above

A. SELECT DISTINCT

B. SELECT UNIQUE

C. SELECT DIFFERENT

D. All of the above

E. None of the above

A. a tree file

B. an indexed file

C. a hashed file

D. a sequential file

E. None of the above