1. NORMAL
2. ABORT
3. IMMEDIATE
4. NONE
1
Q. 8 : Which script file creates commonly used data dictionary views
1. sql.bsq
2. catalog.sql
3. utlmontr.sql
4. catproc.sql
2
Q. 9 : In order to perform a full media recovery, the Database must be¡
1. Mounted and Opened using RESETLOG option
2. Mounted but not Opened
3. Mounted and Opened using ARCHIVELOG option
4. You cannot perform a full media recovery
2
Q. 10 : When is the parameter file read during startup
1. When opening the Database
2. When mounting the Database
3. During instance startup
4. In every stage
3
Q. 11 : What is the default mount option for an Oracle Database
1. SHARED
2. PARALLEL
3. EXCLUSIVE
4. RETRY
3
Q. 12 : You cannot start a database instance if you are connected to the database via a shared server process.