DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
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