1.
In Oracle, which of the following system global area components is responsible for holding the redo information until it is written into the physical redo log files stored on the disk?
2.
In Oracle, which of the following background processes performs recovery at the instance startup if required?
3.
In Oracle, Extents is a collection of ______________________
4.
In Oracle, which of the following tools is used to create a database?
5.
In Oracle, which of the following database shutdown modes requires an instance recovery during the next startup of a database?
6.
Which of these is the gateway to the Oracle instance for all the non-local user connections?
7.
In Oracle, which of the following naming methods does not require client-side configuration?
8.
In Oracle, which of the following provides read-consistency for queries against tables?
9.
In Oracle database, which of the following indexes will you use to index a column which contains many unique values in the given table?
10.
In Oracle, you are exploring a background process to trace the files for your LGWR process. In which of the following scenarios will you find a trace file generated for this process?