单选题Which statement correctly describes the change tracking writer （CTWR） background process？（）A  It keeps track of changes in the background processes.B  It records the system change number （SCN） in the control file.C  It writes audit records for user cha

第1题：

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

• A、the alert log file
• B、the core dump files
• C、the change tracking file
• D、the user session trace files
• E、the database audit trail files
• F、the background process trace files

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

You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

• A、 The DBWn process writes to the datafile.
• B、 Changes in the background process are recorded.
• C、 The log file is updated with the current SCN number.
• D、 The System Change Number （SCN） is recorded in the control file.
• E、 The changes to the listener configuration in the listener.ora file are recorded.

第4题：

You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）

• A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
• B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
• C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；
• D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；

第5题：

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

• A、archival
• B、log writer
• C、database writer
• D、system monitor
• E、process monitor
• F、change tracking writer

第6题：

You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）

• A、 RBAL
• B、 CKPT
• C、 SMON
• D、 PMON
• E、 MMON
• F、 CTWR
• G、 DBWR

第7题：

Which statement correctly describes the change tracking writer （CTWR） background process？（）

• A、 It keeps track of changes in the background processes.
• B、 It records the system change number （SCN） in the control file.
• C、 It writes audit records for user changes to the change tracking file.
• D、 It records any changes to the listened configuration in the listener.ora file.
• E、 It records any changes to the database parameters in the change tracking file.
• F、 It records the physical location of all the changes that are made to the database in the change tracking file.

第8题：

Software configuration management (SCM) is the task of tracking and controlling changes in the software. Configuration management practices include configuration identification, change control, ( ) and configuration audit.

• A、milestones marking
• B、status reporting
• C、stakeholder management
• D、quality audit

第9题：

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

• A、 open the database with the RESTRICTED option
• B、 open the database with the RESETLOGS option
• C、 recover to the required SCN only that data file in which the error occurred
• D、 recover all the data files to the same system change number （SCN）

第10题：

You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）

• A、 The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
• B、 The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
• C、 The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
• D、 The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.