1.Choose two SGA structures that are required in every Oracle instance.
A. Large pool
B. Shared pool
C. Buffer cache
D. Java pool
2. Which statement is true
A. A database can have only one control file.
B. A database must have at least two control files.
C. A database may have zero or more control files.
D. A database must have at least one control file.
3. Which component is configured at database startup and cannot be dynamically managed?
A. Redo log buffer.
B. Streams pool
C. Java pool
D. Shared pool
E. None of the above
4. Which component is not part of an Oracle instance?
A. System global area.
B. Process monitor
C. Control file
E. None
5. Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?
A. DBWn
B. PMON
C. LGWR
D. CKPT
E. ARCn
6. User John has updated several rows in a table and issued a commit. What does the DBWn (database writer) process do at this time in response to the commit event?
A. Writes the changed blocks to data files.
B. Writes the changed blocks to redo log files.
C. Triggers checkpoint and thus LGWR writes the changes to redo log files.
D. Does nothing.
7. Which of the following best describes a RAC configuration?
A. One database, multiple instances
B. One instance, multiple databases
C. Multiple databases plugged in from multiple servers
D. Multiple databases, multiple instances
8. Which component of the SGA contains the parsed SQL code?
A. Database buffer cache
B. Dictionary cache
C. Library cache
D. Parse cache
9. Which tasks are accomplished by the SMON process? (Choose all that apply.)
A. Performs recovery at instance startup
B. Performs cleanup after a user session is terminated
C. Starts any server process that stopped running
D. Coalesces contiguous free space in dictionary-managed tablespaces
10. Choose the best statement from the options related to segments.
A. A contiguous set of blocks constitutes a segment.
B. A nonpartitioned table can have only one segment.
C. A segment can belong to more than one tablespace.
D. All of the above are true.
11. From the following list, choose two processes that are optional in an Oracle Database 12c database.
A. MMON
B. MMNL
C. ARCn
D. MMAN
12. Which SGA component will you increase or configure so that RMAN tape backups do not use memory from the shared pool?
A. Java pool
C. Recovery pool
D. Large pool
13. When a user session is terminated, which processes are responsible for cleaning up and releasing locks? (Choose all that apply.)
B. LGWR
C. MMON
D. PMON
E. SMON
14. The LRU algorithm is used to manage what part of the Oracle architecture?
A. Users who log on to the database infrequently and may be candidates for being dropped
B. The data file that stores the least amount of information and will need the least frequent backup
C. The tables that users rarely access so that they can be moved to a less active tablespace
D. The shared pool and database buffer cache portions of the SGA
15. Two structures make up an Oracle server: an instance and a database. Which of the following best describes the difference between an Oracle instance and a database?
A. An instance consists of memory structures and processes, whereas a database is composed of physical files.
B. An instance is used only during database creation; after that, the database is all that is needed.
C. An instance is started whenever the demands on the database are high, but the database is used all the time.
D. An instance is configured using a pfile, whereas a database is configured using a spfile.
16. Which of the following is the proper order of Oracle’s storage hierarchy, from smallest to largest?
A. Operating-system block, database block, segment, extent
B. Operating-system block, database block, extent, segment
C. Segment, extent, database block, operating-system block
D. Segment, database block, extent, operating-system block
17. The DBA unknowingly terminated the process ID belonging to the PMON process of Oracle Database 12c database using the kill -9 command on Unix. Choose the best answer:
A. Oracle spawns another PMON process automatically.
B. The database hangs, and the DBA must manually start a PMON process.
C. If the database is in ARCHIVELOG mode, Oracle automatically starts another PMON process and recovers from the database hang.
D. The instance crashes and needs to be restarted.
18. When an incremental checkpoint happens in a database, which file(s) are updated with the checkpoint position? Choose all options that are correct.
A. Data files
B. Control files
C. Initialization Parameter Files
D. Redo log files
E. Archive log files
19. User Isabella updates a table and commits the change after a few seconds. Which of the following actions are happening in the database? Order them in the correct sequence and ignore the actions that are not relevant.
A. Oracle reads the blocks from data file to buffer cache and updates the blocks.
B. Changed blocks from the buffer cache are written to data files.
C. The user commits the change.
D. LGWR writes the changed blocks to the redo log buffer.
E. The server process writes the change vectors to the redo log buffer.
F. LGWR flushes the redo log buffer to redo log files.
G. A checkpoint occurs.
20. Querying the V$LOG file shows the following information. Which redo group files are required for instance crash recovery? SQL> select GROUP#, ARCHIVED, STATUS from V$LOG; GROUP# ARC STATUS ---------- --- ---------------- 1 NO CURRENT 2 NO INACTIVE 3 NO INACTIVE 4 NO ACTIVE
A. Group 1 and 4
B. Group 2 and 3
C. Groups 1 through 4
D. Group 1
E. Group 4
