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. DBA
d. OSDBA
Q 6. When a user executes the sqlplus / as sysdba
command, how is the user authenticated?
a. Using a local LDAP server
b. Using database credentials
c. Using operating system credentials
d. Using a remote RADIUS server
Q 7. Which command could...