Organization of Records in Files - DBMS

1.

An audit trail ___________ .

   A.) Is used to make backup copies
   B.) Is the recorded history of operations performed on a file
   C.) Can be used to restore lost information
   D.) None of the mentioned

Answer: Option 'B'

Is the recorded history of operations performed on a file

2.

Which of the following is not true of the traditional approach to information processing

   A.) There is common sharing of data among the various applications
   B.) It is file oriented
   C.) Programs are dependent on the file
   D.) It is inflexible

Answer: Option 'A'

There is common sharing of data among the various applications

3.

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

   A.) Storage space is wasted
   B.) Changing the data in one spot will cause data inconsistency
   C.) In can be more easily accessed
   D.) Both a and b

Answer: Option 'D'

Both a and b

4.

Which of these is not a feature of Hierarchical model?

   A.) Organizes the data in tree-like structure
   B.) Parent node can have any number of child nodes
   C.) Root node does not have any parent
   D.) Child node can have any number of parent nodes

Answer: Option 'D'

Child node can have any number of parent nodes

5.

A data dictionary is a special file that contains?

   A.) The names of all fields in all files
   B.) The data types of all fields in all files
   C.) The widths of all fields in all files
   D.) All of the mentioned

Answer: Option 'D'

All of the mentioned

Organization of Records in Files Download Pdf