单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
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 markingB、status reportingC、stakeholder managementD、quality audit
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 fileB、the core dump filesC、the change tracking fileD、the user session trace filesE、the database audit trail filesF、the background process trace files
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A、 RBALB、 CKPTC、 SMOND、 PMONE、 MMONF、 CTWRG、 DBWR
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.
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.
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、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
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 optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number （SCN）
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 ；
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.
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A、 the system change numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
Which statement is true regarding checkpoints and recovery？（）A、A checkpoint defines the highest system change number （SCN）.B、All redo entries higher or at the SCN are known to be written to the data files.C、Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.D、The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
What does the SCN represent？（） A、 The system change number， which is a point in time relative to transactions within a given database.B、 A number that represents time. Thus， at 1300 hours， the SCN is the same on all databases. C、 The security change number， which represents the security code that is needed to access any database structure.D、 A conversion factor that converts internal database time to external clock time.E、 UTC time in the database，providing a standardized way of tracking time in Oracle.
You need to design a method to log changes that are made to servers and domain controllers. You also need to track when administrators modify local security account manager objects on servers. What should you do？（）A、Enable failure audit for privilege user and object access on all servers and domain controllersB、Enable success audit for policy change and account management on all servers and domain controllersC、Enable success audit for process tracking and logon events on all servers and domain controllersD、Enable failure audit for system events and directory service access on all servers and domain controllers
单选题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 should you use to enable the block change tracking feature?（）AALTER DATABASE ENABLE BLOCK CHANGE TRACKING;BALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;CALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;DALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
单选题What does the SCN represent？（）A The system change number， which is a point in time relative to transactions within a given database.B A number that represents time. Thus， at 1300 hours， the SCN is the same on all databases. C The security change number， which represents the security code that is needed to access any database structure.D A conversion factor that converts internal database time to external clock time.E UTC time in the database，providing a standardized way of tracking time in Oracle.
单选题You need to design a method to log changes that are made to servers and domain controllers. You also need to track when administrators modify local security account manager objects on servers. What should you do？（）AEnable failure audit for privilege user and object access on all servers and domain controllersBEnable success audit for policy change and account management on all servers and domain controllersCEnable success audit for process tracking and logon events on all servers and domain controllersDEnable failure audit for system events and directory service access on all servers and domain controllers
多选题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？（）Athe alert log fileBthe core dump filesCthe change tracking fileDthe user session trace filesEthe database audit trail filesFthe background process trace files
单选题You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A the system change numberB the locations of the redo log filesC the locations of the datafilesD the physical location of all the database changes
单选题Which statement is true regarding checkpoints and recovery？（）AA checkpoint defines the highest system change number （SCN）.BAll redo entries higher or at the SCN are known to be written to the data files.COnly the redo records containing SCNs higher then the checkpoint need to be applied during recovery.DThe LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
单选题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 should you use to enable the block change tracking feature?（）AALTER DATABASE ENABLE BLOCK CHANGE TRACKINGBALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE CALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE DALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
单选题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.
单选题You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
单选题You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A RBALB CKPTC SMOND PMONE MMONF CTWRG DBWR
单选题Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）AA database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. BDuring recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. CAfter 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. DAt 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.
多选题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？ （）AThe DBWn process writes to the datafile.BChanges in the background process are recorded.CThe log file is updated with the current SCN number.DThe System Change Number （SCN） is recorded in the control file.EThe changes to the listener configuration in the listener.ora file are recorded.