DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
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)
116. What are the type of Synonyms
i) Public ii) Private iii) Constant
- i) only
- ii) only
- i) and ii)
- ) none
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