DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q21
ORACLE database's data is stored in
  • A extent
  • B block
  • C segment
  • D links
Answer: Option B
Q22
Specific number of Contiguous data blocks are called as
  • A extent
  • B block
  • C segment
  • D links
Answer: Option A
Q23
a set of extents allocated for a certain logical structure is
  • A extent
  • B block
  • C segment
  • D links
Answer: Option C
Q24
The file which record all changes made to data is
  • A Data files
  • B Redo Log files
  • C Control files
  • D tablespaces
Answer: Option B
Q25
The file which records the physical structure of the database is
  • A Data files
  • B Redo Log files
  • C Control files
  • D tablespaces
Answer: Option C
Q26
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.
  • A i) and ii) only
  • B i), ii) and iii) only
  • C ii) and iii)
  • D none
Answer: Option B
Q27
_________ store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.
  • A buffer
  • B segment
  • C extent
  • D none of those
Answer: Option A
Q28
What is the main use of B & B+ trees in database
  • A To maintain the database
  • B To maintain the security
  • C For queries
  • D All the above
Answer: Option C
Q29
Oracle 8i Here
  • A Interface
  • B Interaction
  • C Internet
  • D none of the above
Answer: Option C
Q30
Oracle 8i Here
  • A Interface
  • B Interaction
  • C Internet
  • D none of the above
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test