DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q111
ORACLE database is comprised of
  • A Data files
  • B Redo Log files
  • C Control files
  • D All the above
Answer: Option D
Q112
The components of Physical database structure of Oracle Database is
  • A Data files
  • B Redo Log files
  • C Control files
  • D All the above
Answer: Option D
Q113
The components of Physical database structure of Oracle Database is i) Data files ii) Redo Log files iii) Control files iv) Table Space
  • A i) , ii) only
  • B i) and iv) only
  • C i),ii) and iii) only
  • D i),ii), iii) and iv)
Answer: Option C
Q114
The components of logical database structure of Oracle Database is i) Data files ii) Data base Schema Objects iii) Control files iv) Table Space
  • A i) , ii) only
  • B ) ii) and iv) only
  • C i),ii) and iii) only
  • D i),ii), iii) and iv)
Answer: Option B
Q115
Alias for a table, view, sequence or program unit is
  • A Sequence
  • B Synonym
  • C Degree
  • D Order
Answer: Option B
Q116
What are the type of Synonyms i) Public ii) Private iii) Constant
  • A i) only
  • B ii) only
  • C i) and ii)
  • D ) none
Answer: Option C
Q117
ORACLE database's data is stored in
  • A extent
  • B block
  • C segment
  • D links
Answer: Option B
Q118
Specific number of Contiguous data blocks are called as
  • A extent
  • B block
  • C segment
  • D links
Answer: Option A
Q119
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
Q120
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

📚 More from Database

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