Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
13 Cards in this Set
- Front
- Back
|
Which background process and associated database component guarantee that committed data is saved even when the changes have not been recorded in the datafiles? CKPT and the control files |
LGWR and the online redo log files |
|
|
In which situations does DBWn write the data from the database buffer cache to datafiles? (Choose all that apply.) |
when the database is shut down cleanly when a tablespace in the database is taken offline using OFFLINE NORMAL or OFFLINE TEMPORARY when the server process cannot find free buffers in the database buffer cache |
|
|
User A has locked some tables in the database. Users of this database cannot access the data in the locked tables. To solve the problem, you kill user A's session. Which two statements are true in this scenario? (Choose two.) |
The PMON process will perform an implied rollback on user A's transaction The PMON process will release the locks held by user A's transaction. |
|
|
Users of your database application complain of slow response time for queries. Upon analysis, you realize that the queries are being reparsed because they are aged out quickly. Which component of the System Global Area (SGA) should you modify to reduce the reparsing of queries? |
library cache |
|
|
Your database is running and virtually all of the users are connected in shared server mode. You want to ensure that the memory allocated to the shared pool is used only by the application users, and not by RMAN processes or any other I/O server processes. Which component of the System Global Area (SGA) should be allocated memory to achieve the objective? |
large pool |
|
|
When an Oracle user process is terminated abnormally, the Oracle background process PMON cleans up the terminated process. Which tasks are accomplished by PMON when it attempts to clean up this abnormally terminated process? (Choose all that apply.) |
releasing the resources held by the failed process rolling back the current transaction of that user releasing the table and row level locks held by the failed process |
|
|
Which task does the RBAL process perform? |
It coordinates rebalance activity for disk groups |
|
|
Which statement about setting the DB_CACHE_SIZE initialization parameter is TRUE? |
f the DB_CACHE_SIZE parameter is not set to a value that is a multiple of the granule size, the actual size that Oracle will allocate for the database cache is rounded up to the nearest whole number multiple of the granule size. |
|
|
Which two structures are physical structures in an Oracle database? (Choose two.) |
datafile control file |
|
|
When a segment requires additional space, which logical database components would you add? |
extents |
|
|
Which statement about extents is TRUE? |
Extents are collections of contiguous database blocks. |
|
|
Which structure is a part of the logical database structure and is contained within a tablespace? |
segment |
|
|
Which term describes blocks in the database buffer cache that are holding rows that have changed, and must be written back to disk by the DBWn process before being aged out? free |
dirty |
