单选题During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）A DBW0 B LGWR C ARCH D SMON E PMON

第1题：

Note the functionalities of various background processes：  1：Perform recovery at instance startup. SMON  2：Free the resources used by a user process when it fails. PMON  3：Cleanup the database buffer cache when a process fails. PMON  4：Dynamically register database services with listeners. PMON  5：Monitor sessions for idle session timeout. PMON  6：Cleanup unused temporary segments. SMON  7：Record the checkpoint information in control file. CKPT  Which option has the correct functionalities listed for a background process（）

• A、Checkpoint （CKPT）： 1， 2， 5
• B、System Monitor （SMON）： 1， 6
• C、Process Monitor （PMON）： 4， 6， 7
• D、Database Writer （DBWR）： 1， 3， 4

第2题：

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)

• A、An entry is created in the alert log file and the database instance continues to function normally
• B、The log switch hangs occur for transactions until free space is available in the flash recovery area
• C、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
• D、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

第3题：

第4题：

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

• A、Coalesce the application tables at a regular interval.
• B、Export and Import the application tables a regular interval.
• C、Drop and recreate the application tables at a regular interval.
• D、Move the application tables to a tablespace with less space usage.
• E、Distribute the application tables across multiple tablespaces depending on usage.
• F、Move the application tables to automatic segment space management tablespace.

第5题：

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

• A、run a procedure to check the tablespace space usage
• B、define the warning threshold for the tablespace at 75% in Database Control
• C、create a trigger to be executed when tablespace space usage reaches 75%
• D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
• E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

第6题：

An administrator has added a new hard drive to a server that is running out of space on its C Drive and is experiencing slow performance.  The administrator needs to free up space on the C Drive.Which of the following is the BEST action for the administrator to take to free up space on the drive？（）

• A、Move the page file to the new drive.
• B、Copy the system32 directory to the new drive.
• C、Convert the C drive to a basic disk.
• D、Setup a software RAID to mirror the C drive.

第7题：

Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）

• A、 FREE_SPACE indicates only the space that is currently unallocated.
• B、 ALLOCATED_SPACE indicates only the space currently allocated and in use.
• C、 FREE_SPACE indicates only the space that is currently allocated and available for reuse.
• D、 ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
• E、 FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

第8题：

第9题：

During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）

• A、DBW0 
• B、LGWR 
• C、ARCH 
• D、SMON 
• E、PMON

第10题：

Note the following functionalities of various background processes：  1：Record the checkpoint information in data file headers. CKPT  2：Perform recovery at instance startup. SMON  3：Cleanup unused temporary segments. SMON  4：Free the resources used by a user process when it fails.  5：Dynamically register database services with listeners.  6：Monitor sessions for idle session timeout.  Which option has the correct functionalities listed for a background process（）

• A、Archiver Process （ARCn）：1， 2，5
• B、System Monitor Process （SMON）：1，4，5
• C、Process Monitor Process （PMON）：4，5，6
• D、Database Writer Process （DBWn）：1，3，4