Home > Databases > Quizzes > RDBMS Basics Practice Test: Storage and File Structure
RDBMS Basics Practice Test: Storage and File Structure
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 79% Most missed: “The time from when a read or write request is issued to when the actual data tra…”
Quiz on magnetic disk, raid, file and record organization. A relational database management system (RDBMS) stores data in tables, which are organized into columns, and each column stores one type of data. The data for a single instance of a table is stored as a row. The primary key identifies each row in the table. Each column of the table holds attributes of the data, and each record usually has a value for each attribute. RDBMSs include functions that maintain the security, accuracy, integrity, and consistency of the data.  The fundamental physical element of an RDBMS is a block. In... Show more
RDBMS Basics Practice Test: Storage and File Structure
Time left 00:00
25 Questions

1. It is easier to delete a record from the fixed length records
2. Files that support log disks are called as ________
3. Using RAID increases the mean time to failure
4. DVD is a form of ______ storage
5. What does a null bitmap indicate?
6. RAID level 0 refers to?
7. Data striping by splitting bits across multiple disks is called as _______
8. Metadata about the relations are stored in ________
9. The process of duplicating every disk is called _______
10. NOR flash is cheaper than NAND flash
11. The subsystem responsible for the allocation of buffer space is called as _______
12. The time for repositioning the arm is called as _________
13. The time from when a read or write request is issued to when the actual data transfer begins is called _______
14. Which of the following is true about file header?
15. Which of the following need to be stored in the data dictionary?
16. Which of the following is a part of the Magnetic disk assembly?
17. Which of the following is a measure of reliability of a disk?
18. Statement 1: Cache storage is very fast
Statement 2: Cache storage is very cheap
19. What is the full form of RAID?
20. What is heap file organization?
21. The linked list formed by the deleted records is called as ______
22. What is the approximate storage capacity of CDs in MB
23. What is a multitable clustering file organization?
24. What is an NVRAM?
25. The logical to physical page mapping is represented in a ____________