itgle.com

单选题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 

题目
单选题
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.

相似考题

1.The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?（）A. All archived redo log files backed up at least twice to tape are deleted.B. All archived redo log files backed up at least once to tape are eligible for deletion.C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

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.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.

4. The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring instance recovery（）A、Inactive and current redo log files are required to accomplish recovery.B、Online and archived redo log files are required to accomplish instance recovery.C、All redo log entries after the last checkpoint are applied from redo log files to data files.D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题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 ”相关问题

  • 第1题：

    Which  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 onlineredo log files

    正确答案:B,C

  • 第2题：

    You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

    • A、This operation resets the SCN for the database.
    • B、This operation creates a new incarnation of the database.
    • C、This operation moves all the redo log files to a different location.
    • D、This operation deletes the old redo log files and creates new redo log files.
    • E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

    正确答案:B,E

  • 第3题：

    In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）

    • A、Complete Recovery with online redo log
    • B、Complete Recovery with archived redo log
    • C、Tablespace Point-in-Time Recovery (TSPITR)
    • D、Incomplete Recovery with system change number (SCN)

    正确答案:C

  • 第4题：

    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.

    正确答案:B,C

  • 第5题：

    The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）

    • A、Inactive and current redo log files are required to accomplish recovery.
    • B、Online and archived redo log files are required to accomplish instance recovery.
    • C、All redo log entries after the last checkpoint are applied from redo log files to data files.
    • D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.

    正确答案:C

  • 第6题：

    The loss of which two types of files may require a recovery with the RESETLOGS option？（）

    • A、 control files
    • B、 password file
    • C、 archived log files
    • D、 system-critical data files for which all the redo entries are present
    • E、 non-system-critical data files for which all the redo entries are present

    正确答案:A,C

  • 第7题：

    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

    • A、 You do not need to restore all the data files.
    • B、 You do not need to open the database with the RESETLOGS operation
    • C、 You do not need to perform a full backup after the RESETLOGS operation.
    • D、 You do not need to recover all the data files to the same system change number （SCN）.

    正确答案:C

  • 第8题：

    单选题
    The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）
    A

    Inactive and current redo log files are required to accomplish recovery.

    B

    Online and archived redo log files are required to accomplish instance recovery.

    C

    All redo log entries after the last checkpoint are applied from redo log files to data files.

    D

    All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    多选题
    The loss of which two types of files may require a recovery with the RESETLOGS option？（）
    A

    control files

    B

    password file

    C

    archived log files

    D

    system-critical data files for which all the redo entries are present

    E

    non-system-critical data files for which all the redo entries are present


    正确答案： B,C
    解析： 暂无解析

  • 第10题：

    单选题
    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）
    A

     You do not need to restore all the data files.

    B

     You do not need to open the database with the RESETLOGS operation

    C

     You do not need to perform a full backup after the RESETLOGS operation.

    D

     You do not need to recover all the data files to the same system change number （SCN）.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring instance recovery（）
    A

    Inactive and current redo log files are required to accomplish recovery.

    B

    Online and archived redo log files are required to accomplish instance recovery.

    C

    All redo log entries after the last checkpoint are applied from redo log files to data files.

    D

    All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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）

    正确答案:B,D

  • 第14题：

    Which two statements are true regarding the database in ARCHIVELOG mode？（）

    • A、You have to shut down the database to perform the backups.
    • B、Archiving information is written to the data files and redo log files.
    • C、You can perform complete database backups without closing the database.
    • D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
    • E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

    正确答案:C,E

  • 第15题：

    These are the details about V$FLASHBACK_DATABASE_STAT：  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）

    • A、BEGIN_TIME is the time at which Flashback logging is enabled.
    • B、END_TIME is the time at which the query is executed on the view.
    • C、REDO_DATA is the number of bytes of redo data written during the interval.
    • D、This view contains information about flashback data pertaining to the last 24 hours.
    • E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

    正确答案:C,D

  • 第16题：

    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 RESETLOGS option
    • B、open the database with the RESTRICTED option
    • C、recover all the data files to the same system change number （SCN）
    • D、recover to the required SCN only that data file in which the error occurred

    正确答案:A,C

  • 第17题：

    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.

    正确答案:C

  • 第18题：

    Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）

    • A、Transactions are rolled back using redo log files.
    • B、Transactions are rolled forward using redo log files.
    • C、Transactions are rolled back using redo log files and archived log files.
    • D、Transactions are rolled forward using redo log files and rolled back using redo log files.

    正确答案:B

  • 第19题：

    单选题
    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.


    正确答案： F
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）
    A

    Complete Recovery with online redo log

    B

    Complete Recovery with archived redo log

    C

    Tablespace Point-in-Time Recovery (TSPITR)

    D

    Incomplete Recovery with system change number (SCN)


    正确答案： C
    解析： 暂无解析

  • 第22题：

    多选题
    Which  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 onlineredo log files


    正确答案： C,B
    解析： 暂无解析

  • 第23题：

    多选题
    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.


    正确答案： B,D
    解析： 暂无解析

  • 第24题：

    单选题
    In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）
    A

     Complete Recovery with online redo log

    B

     Complete Recovery with archived redo log

    C

     Tablespace Point-in-Time Recovery （TSPITR）

    D

     Incomplete Recovery with system change number （SCN）


    正确答案： D
    解析： 暂无解析

相关内容