Free Test Storage Media and File... – Databas...

Q1: Which of the following is a primary storage device?

A. RAM B. Hard Disk C. Optical Disk D. Magnetic Tape

Q2: Which storage media is fastest for data access?

A. Solid State Drive (SSD) B. Magnetic Tape C. Optical Disk D. Hard Disk Drive (HDD)

Q3: What is the main disadvantage of magnetic tape storage?

A. Sequential access B. High cost C. Low capacity D. Volatility

Q4: What is file organization in DBMS?

A. The way records are stored in a file on storage medium B. The structure of tables C. The type of queries D. The indexing method

Q5: Which file organization method stores records in sequential order?

A. Sequential file organization B. Indexed file organization C. Hashed file organization D. Heap file organization

Q6: What is heap file organization?

A. Records stored in no particular order B. Records sorted by key C. Records stored with index D. Records stored in hashed form

Q7: Which file organization uses an index to directly access records?

A. Indexed file organization B. Heap file organization C. Sequential file organization D. Hashed file organization

Q8: What is a primary key in indexed file organization?

A. Field used to create index B. Any field in record C. Pointer to next record D. Storage location

Q9: What is the main purpose of hashing in file organization?

A. To provide direct access using hash function B. To store data sequentially C. To compress data D. To backup data

Q10: Which file organization is best for batch processing?

A. Sequential file organization B. Hashed file organization C. Indexed file organization D. Heap file organization

Q11: What is overflow in hashing?

A. When hash collisions cause records to be stored in overflow area B. Extra storage space C. Backup storage D. Sequential storage

Q12: What does “clustered file organization” mean?

A. Records with similar key values stored together physically B. Records stored randomly C. Records stored with hash function D. Records indexed

Q13: Which storage device is non-volatile?

A. Hard disk B. RAM C. Cache memory D. Registers

Q14: What is the block or page in storage?

A. A fixed-size unit of data transfer between memory and disk B. Entire file C. Record D. Query result

Q15: Which of the following is an advantage of indexed file organization?

A. Faster access to records B. Simple to implement C. Low storage overhead D. Supports sequential access only

Q16: What happens in direct file organization?

A. Record address is computed directly using hash function B. Records are stored sequentially C. Records are stored randomly D. Records are indexed

Q17: Which file organization is most suitable for online transaction processing?

A. Hashed file organization B. Sequential file organization C. Heap file organization D. Indexed file organization

Q18: What is seek time in storage devices?

A. Time to position the read/write head at the correct track B. Time to transfer data C. Time to back up data D. Time to execute query

Q19: What is latency in storage?

A. Delay between data request and start of data transfer B. Speed of CPU C. Memory capacity D. Query processing time

Q20: Which storage medium uses optical technology?

A. CD/DVD B. Hard disk C. RAM D. Magnetic tape

Quiz for Storage Media and File Organization