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
111. ORACLE database is comprised of
- Data files
- Redo Log files
- Control files
- All the above
112. The components of Physical database structure of Oracle Database is
- Data files
- Redo Log files
- Control files
- All the above
113. The components of Physical database structure of Oracle Database is i) Data files ii) Redo Log files iii) Control files iv) Table Space
- i) , ii) only
- i) and iv) only
- i),ii) and iii) only
- i),ii), iii) and iv)
114. The components of logical database structure of Oracle Database is i) Data files ii) Data base Schema Objects iii) Control files iv) Table Space
- i) , ii) only
- ) ii) and iv) only
- i),ii) and iii) only
- i),ii), iii) and iv)
115. Alias for a table, view, sequence or program unit is
- Sequence
- Synonym
- Degree
- Order
116. What are the type of Synonyms i) Public ii) Private iii) Constant
- i) only
- ii) only
- i) and ii)
- ) none
118. Specific number of Contiguous data blocks are called as
- extent
- block
- segment
- links
119. The file which record all changes made to data is
- Data files
- Redo Log files
- Control files
- tablespaces
120. The file which records the physical structure of the database is
- Data files
- Redo Log files
- Control files
- tablespaces