多选题When a check point occurs the （）. （）. and （） are synchronized.Adata filesBcontrol filesCredo log filesDparameter filesEarchive log files

题目
多选题
When a check point occurs the （）. （）. and （） are synchronized.
A

data files

B

control files

C

redo log files

D

parameter files

E

archive log files

相似考题

1.You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?()A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

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

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

4.When a check point occurs the （）. （）. and （） are synchronized.A、data filesB、control filesC、redo log filesD、parameter filesE、archive log files

参考答案和解析
正确答案： B,C
解析： 暂无解析
更多“多选题When a check point occurs the （）. （）. and （） are synchronized.Adata filesBcontrol filesCredo log filesDparameter filesEarchive log files”相关问题

  • 第1题：

    When a problem occurs in an HACMP cluster，which log file will show the high level overview of the cluster operation？（）  

    • A、 /tmp/hacmp.out
    • B、 /tmp/clstrmgr.debug
    • C、 /usr/es/adm/cluster.log
    • D、 /var/hacrmp/clverify/clverify.log

    正确答案:C

  • 第2题：

    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

    • A、Increase the size of redo log files
    • B、Increase the size of redo log buffer
    • C、Increase the number of redo log files
    • D、Place the redo log files on a separate disk
    • E、Decrease the number of redo log groups to two
    • F、Increate the number Log Writer （LGWR） process

    正确答案:B,D

  • 第3题：

    You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）  

    • A、the value of the UNDO_RETENTION initialization parameter
    • B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
    • C、the online redo log files size
    • D、the number of redo log members in a group

    正确答案:C

  • 第4题：

    Examine the command：   ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS；   What does the command accomplish？（）

    • A、Creates an additional copy of the database online redo log files. 
    • B、Stores the primary key column values of each row involved in a DML operation in the online redo log files. 
    • C、Stores the primary key column values of each row involved in a DML operation in the supplemental log files. 
    • D、Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.

    正确答案:B

  • 第5题：

    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

  • 第6题：

    TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do？（）

    • A、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， maintain default schedule settings for both the log shipping copy and the restore jobs.
    • B、On SQL1，change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.
    • C、On SQL1， maintain default schedule settings for the transaction log backup job. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.
    • D、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， reschedule both the log shipping copy and the restore jobs so that they occur every minute.

    正确答案:D

  • 第7题：

    单选题
    You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）
    A

     The archived redo log files will be overwritten.

    B

     The archived redo log files are deleted automatically.

    C

     The archived redo log files should be moved to some other location.

    D

     The archived redo log files are still maintained because the file names are unique.


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

  • 第8题：

    单选题
    Which of the following files cannot be cataloged using the CATALOG command？（）
    A

    Data files

    B

    Control files

    C

    Archived log files

    D

    Files storing RMAN scripts


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

  • 第9题：

    多选题
    Which three statements are true about the stages of database startup？（）
    A

    Data files and redo log files can be renamed at the MOUNT stage.

    B

    Control files are read at the OPEN stage for the location of data files.

    C

    Control files are required to bring the database to the NOMOUNT stage.

    D

    Data files and redo log files are made available to users at the OPEN stage.

    E

    Data files and online redo log files are checked for consistency while opening the database


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

  • 第10题：

    多选题
    On which three can you use Recovery Manager （RMAN） to perform incremental backup？（）
    A

    data files

    B

    control files

    C

    tablespaces

    D

    password file

    E

    parameter file

    F

    whole database

    G

    flashback log file

    H

    archived log files

    I

    change tracking file


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

  • 第11题：

    多选题
    Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）
    A

    Data files

    B

    Control files

    C

    Parameter file

    D

    Online redo log files

    E

    Server parameter file


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

  • 第12题：

    单选题
    You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）
    A

    the value of the UNDO_RETENTION initialization parameter

    B

    the value of the optimal redo log file size provided by the Redo Logfile Size Advisor

    C

    the online redo log files size

    D

    the number of redo log members in a group


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

  • 第13题：

    You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） 

    • A、to uniquely identify the archived log files with the restore operation
    • B、to uniquely identify the archived log files with the redo log group number
    • C、to uniquely identify the archived log files for each incarnation of the database
    • D、to uniquely identify the archived log files with the number of recovery operations performed

    正确答案:C

  • 第14题：

    You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）

    • A、 The archived redo log files will be overwritten.
    • B、 The archived redo log files are deleted automatically.
    • C、 The archived redo log files should be moved to some other location.
    • D、 The archived redo log files are still maintained because the file names are unique.

    正确答案:D

  • 第15题：

    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

  • 第16题：

    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

    • A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
    • B、 Before the instance starts， you receive an error about the missing redo log files of a group.
    • C、 The instance starts and the database opens with an error message written to the alert log file.
    • D、 The instance starts and the database opens because two redo log groups still exist.
    • E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

    正确答案:A

  • 第17题：

    In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

    • A、 when all the online redo log groups are multiplexed and one of the members of a group is missing
    • B、 when all the online redo log groups are not multiplexed and one log group is missing
    • C、 when all the control files are missing
    • D、 when some important tables are deleted from the database and purged from the Recycle Bin

    正确答案:A

  • 第18题：

    多选题
    An administrator receives an error when attempting to execute a WebSphere Commerce command and decides to take the following steps to troubleshoot the problem：   Check to see if the request was processed by the WebSphere plug-in but was never received by the WebSphere Application Server  Check for Java errors from EJBs and servlets  Trace WebSphere Commerce Server subsystems and commands  Which of the following files should the administrator check to accomplish these steps？（）
    A

    error.log

    B

    trace.log

    C

    http_plugin.log

    D

    servlet.log

    E

    SystemOut.log


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

  • 第19题：

    多选题
    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
    A

    Increase the size of redo log files

    B

    Increase the size of redo log buffer

    C

    Increase the number of redo log files

    D

    Place the redo log files on a separate disk

    E

    Decrease the number of redo log groups to two

    F

    Increate the number Log Writer （LGWR） process


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

  • 第20题：

    多选题
    When a check point occurs the （）. （）. and （） are synchronized.
    A

    data files

    B

    control files

    C

    redo log files

    D

    parameter files

    E

    archive log files


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

  • 第21题：

    单选题
    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
    A

     The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.

    B

     Before the instance starts， you receive an error about the missing redo log files of a group.

    C

     The instance starts and the database opens with an error message written to the alert log file.

    D

     The instance starts and the database opens because two redo log groups still exist.

    E

     The instance starts and the database opens， but every attempt to write to redo log files fails with an error.


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

  • 第22题：

    多选题
    Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）
    A

    data files

    B

    control files

    C

    parameter file

    D

    online redo log files

    E

    server parameter file


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

  • 第23题：

    单选题
    In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）
    A

     when all the online redo log groups are multiplexed and one of the members of a group is missing

    B

     when all the online redo log groups are not multiplexed and one log group is missing

    C

     when all the control files are missing

    D

     when some important tables are deleted from the database and purged from the Recycle Bin


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

  • 第24题：

    单选题
    You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（）
    A

    to uniquely identify the archived log files with the restore operation

    B

    to uniquely identify the archived log files with the redo log group number

    C

    to uniquely identify the archived log files for each incarnation of the database

    D

    to uniquely identify the archived log files with the number of recovery operations performed


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

相关内容