adplus-dvertising

Welcome to the Storage and File Structures MCQs Page

Dive deep into the fascinating world of Storage and File Structures with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Storage and File Structures, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of Storage and File Structures, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

frame-decoration

Check out the MCQs below to embark on an enriching journey through Storage and File Structures. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Storage and File Structures. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Storage and File Structures MCQs | Page 10 of 20

Explore more Topics under DBMS

Q91.
If the global depth in extendible hashing is equal to local depth then the operation must be performed in directory array is

a.

adding

b.

subtracting

c.

halving

d.

doubling

Discuss
Answer: (d).doubling
Q92.
In external hashing for files of disk, the pointers which contain record position and block address within the block are classified as

a.

position pointers

b.

address pointers

c.

block pointers

d.

record pointers

Discuss
Answer: (d).record pointers
Q93.
The technique which involves the arithmetic function or logical function is classified as

a.

clustering technique

b.

folding technique

c.

spanning technique

d.

hashing technique

Discuss
Answer: (b).folding technique
Q94.
The temporary unordered file is also called

a.

overflow file

b.

heap file

c.

sequential file

d.

spanned file

Discuss
Answer: (a).overflow file
Q95.
In high level programs, the command which is used to copy the current record from buffer to variable of user program is classified as

a.

read command

b.

find next command

c.

modify command

d.

insert command

Discuss
Answer: (a).read command
Q96.
In disks, the tracks having same diameter on different surfaces are classified as

a.

sector

b.

blocks

c.

track

d.

cylinder

Discuss
Answer: (d).cylinder
Q97.
In high level programs, the command which sets the pointer of file to the beginning of that file is classified as

a.

modify command

b.

open command

c.

locate command

d.

reset command

Discuss
Answer: (d).reset command
Q98.
The time required to position write or read track on correct place is classified as

a.

reel time

b.

seek time

c.

rotational delay

d.

transfer time of block

Discuss
Answer: (b).seek time
Q99.
Considering storage capacity, the 2000 bytes of data are equal to

a.

1 tera bytes

b.

2 kilobytes

c.

1 mega bytes

d.

2 mega bytes

Discuss
Answer: (b).2 kilobytes
Q100.
Statement 1: Cache storage is very fast
Statement 2: Cache storage is very cheap

a.

Both the statements are true

b.

Statement 1 is true but statement 2 is false

c.

Statement 1 is false but statement 2 is true

d.

Both the statements are false

Discuss
Answer: (b).Statement 1 is true but statement 2 is false
Page 10 of 20

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...