data base management system (DBMS) set 4 Detailed Explanation And More Example

Question : 1

The following term applies to a collection of related records in a database

a) File

b) Layout

c) File

d) Field

Question : 2

If a piece of data is stored in two places in the database, then a

a) Storage space is wasted

b) Changing the data is one spot will cause data inconsistency

c) It can be more easily accessed

d) Both (A) and (B)

Question : 3

The raw facts are called

a) Data

b) Programs

c) Commands

d) Responses

Question : 4

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

Question : 5

A file containing relatively permanent data is

a) Random file

b) Transaction file

c) Master file

d) Sequential file

Question : 6

The term refers to a collection of related information

a) Database

b) List

c) Outline

d) Record