单选题The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.A large poolB shared poolC data buffer cacheD redo log bufferE data dictionary cache

第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题：

Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）

• A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
• B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
• C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
• D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

第3题：

第4题：

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 operations 

• A、Large Pool
• B、Redo Log Buffer
• C、Database Buffer Cache
• D、Program Global Area （PGA）

第5题：

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

第6题：

在SQL语句执行前的解析阶段，要判断其中涉及的表名和列名是否合法，判断所依据的信息存放在（）

• A、PGA
• B、SHARED POOL
• C、DATABASE BUFFER CACHE
• D、REDO LOG BUFFER CACHE
• E、LARGE POOL

第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题：

Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

• A、 DBWn
• B、 RECO
• C、 RVWR
• D、 LGWR

第9题：

The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.

• A、large pool
• B、shared pool
• C、data buffer cache
• D、redo log buffer
• E、data dictionary cache

第10题：

Which two statements are true about checkpointing（）

• A、The checkpoint frequency decreases with the smaller redo log file size.
• B、It ensures that all committed data is written to the data files during normal shutdown.
• C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.
• D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.