Test your knowledge
Q 1. Which of the following is NOT available following the startup of the instance?
a. Background processes
b. Database
c. Memory caches
d. The SGA
Q 2. During which database state is the control file located and its existence verified?
a. NOMOUNT
b. MOUNT
c. OPEN
d. DISMOUNT
Q 3. Which of these does NOT occur during a shutdown immediate command?
a. Active sessions are rolled back
b. Changed blocks in the SGA are flushed to disk
c. Database parameters are re-read
d. Database is dismounted
Q 4. Which database role gives the user the widest possible range of permissions when connecting to the database?
a. SYSOPER
b. SYSDBA
c. SYSTEM
d. SYSOSDBA
Q 5. Which is the highest administrative user possible in an Oracle database?
a. SYS
b. SYSTEM
c. ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
