Storage and File Structures Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” Storage and File Structures” in DBMS. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on Storage and File Structures comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Storage and File Structures Mcqs

1.
The storage structure which do not survive system crashes are ______

Volatile storage

Non-volatile storage

Stable storage

Dynamic storage

2.
Storage devices like tertiary storage , magnetic disk comes under

Volatile storage

Non-volatile storage

Stable storage

Dynamic storage

3.
For a transaction to be durable, its changes need to be written to ________ storage.

Volatile storage

Non-volatile storage

Stable storage

Dynamic storage

4.
The unit of storage that can store one are more records in a hash file organization are

Buckets

Disk pages

Blocks

Nodes

5.
A ______ file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.

Storage

Tertiary

Secondary

Cluster

6.
A file produced by a spreadsheet

Is generally stored on disk in an ASCII text format

Can be used as is by the DBMS

None of the above

Both a and b

7.
SDL means _____________

Storage Discrete Language

Storage Definition Language

Storage Definition Localisation

Storage Discrete Localisation

8.
Which of the following is the process of selecting the data storage and data access characteristics of the database?

Logical database design

Physical database design

Testing and performance tuning

Evaluation and selecting

9.
The process of saving information onto secondary storage devices is referred to as

Backing up

Restoring

Writing

Reading

10.
The file organization that provides very fast access to any arbitrary record of a file is

Ordered file

Unordered file

Hashed file

B-tree

12.
If the record management system allows you to edit values before they are recorded on disk, you can

Correct spelling changes before they are recorded

Change the name of a field

Change the width of a field

All of the above

13.
The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

Bits

Characters

Data field

Schema

14.
What is the name given to the database management system which is able to handle full text data, image data, audio and video?

Full media

Graphics media

Multimedia

Hypertext

15.
To have a file hold a list, it is necessary to

Identify the records in the list

Identify the name, width and type of the fields of each record.

Decide which fields will be used as sort or index keys

All of the above

0Shares
0
Scroll to Top