DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
22. Specific number of Contiguous data blocks are called as
- extent
- block
- segment
- links
23. a set of extents allocated for a certain logical structure is
- extent
- block
- segment
- links
24. The file which record all changes made to data is
- Data files
- Redo Log files
- Control files
- tablespaces
25. The file which records the physical structure of the database is
- Data files
- Redo Log files
- Control files
- tablespaces
26. The control file contains i) Database Name ii) Names and locations of a database's files and redolog files. iii) Time stamp of database creation.
- i) and ii) only
- i), ii) and iii) only
- ii) and iii)
- none
27. _________ store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.
- buffer
- segment
- extent
- none of those
28. What is the main use of B & B+ trees in database
- To maintain the database
- To maintain the security
- For queries
- All the above