Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA、Large PoolB、Redo Log BufferC、Database Buffe

第1题：

You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）

• A、 recycle buffer cache
• B、 large pool
• C、 streams pool
• D、 keep buffer cache
• E、 redo log buffer

第2题：

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）

• A、SMON would automatically restore the lost file.
• B、You would need to restore the whole database from the last backup.
• C、You would need to restore the file from the last full database backup.
• D、You would need to use flashback technology to restore the lost redo log member.
• E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
• F、You would need to restore the missing log file by copying one of the remaining files from the same group.

第3题：

第4题：

In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）

• A、 Recovery catalog
• B、 Oracle Enterprise Manager Repository
• C、 Automatic Workload Repository （AWR）
• D、 Oracle 10g Enterprise Manager Grid Control
• E、 Automatic Database Diagnostic Monitor （ADDM）

第5题：

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）  

• A、 The tape I/O performed is asynchronous
• B、 The tape buffer is allocated from the System Global Area （SGA）
• C、 The tape buffer is allocated from the Program Global Area （PGA）
• D、 Oracle I/O uses an interrupt mechanism to determine when each I/O completes

第6题：

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

• A、 MMAN
• B、 PMON
• C、 MMON
• D、 MMNL

第7题：

You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）

• A、Writes buffers to disk 
• B、Writes current redo log number to datafile headers 
• C、Writes redo log information to disk 
• D、Reads information into memory for users

第8题：

第9题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第10题：

You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）

• A、 streams pool
• B、 shared pool
• C、 log buffer
• D、 keep buffer cache
• E、 recycle buffer cache