data base management system (DBMS) Practice Questions Answers Test with Solutions & More Shortcuts

Question : 1

What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.

a) Information Processing

b) Spreadsheet

c) Operating system

d) Database

Question : 2

A top to bottom relationship among the items in a database is established by a

a) Hierarchical schema

b) Network Schema

c) Relational schema

d) All of the above

Question : 3

The term refers to a collection of related information

a) Database

b) List

c) Outline

d) Record

Question : 4

A file containing relatively permanent data is

a) Random file

b) Transaction file

c) Master file

d) Sequential file

Question : 5

The activity of a file

a) Is a low percentages of number of records added or deleted from a file

b) If high, reduces processing efficiency for sequential and non sequential files

c) Is a measure of the percentage of existing records updated during a run

d) Refers to how closely the files fit into the allocated