itgle.com

多选题Which three statements are true about database recovery operations？（）ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DT

题目
多选题
Which three statements are true about database recovery operations？（）
A

Damaged or lost data files are restored from backups.

B

Redo log file entries are used to roll forward the database.

C

Undo segments are used to roll back any uncommitted transactions.

D

Transactions that were active when the failure occurred are restarted.

E

Transactions that were active when the failure occurred are automatically committed during the recover procedure.

相似考题

1.Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database

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.Which two statements are true about Oracle Managed Files (OMF)?()A. OMF cannot be used in a database that already has data files created with user-specified directions.B. The file system directions that are specified by OMF parameters are created automatically.C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.D. OMF automatically creates unique file names for table spaces and control files.E. OMF may affect the location of the redo log files and archived log files.

更多“多选题Which three statements are true about database recovery operations？（）ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DT”相关问题

  • 第1题：

    You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）

    • A、The online redo log files and archived redo log files are required to accomplish the recovery.
    • B、The uncommitted transaction will be committed at the next startup of the database instance.
    • C、The uncommitted transaction is rolled back automatically at the next opening of the database.
    • D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

    正确答案:C

  • 第2题：

    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

    • A、Restore all the data files and open the database
    • B、Create the data file and performtablespacerecovery
    • C、No need to restore any file， just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第3题：

    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,D,E

  • 第4题：

    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

  • 第5题：

    Which three statements are true about database recovery operations？（）

    • A、Damaged or lost data files are restored from backups.
    • B、Redo log file entries are used to roll forward the database.
    • C、Undo segments are used to roll back any uncommitted transactions.
    • D、Transactions that were active when the failure occurred are restarted.
    • E、Transactions that were active when the failure occurred are automatically committed during the recover procedure.

    正确答案:A,B,C

  • 第6题：

    多选题
    Which two statements about Automatic Storage Management （ASM） are true？（）
    A

    ASM provides mirroring on file by file basis.

    B

    ASM provides automatic load balancing across all ASM disks.

    C

    ASM supports the Oracle database and operating system files.

    D

    ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.


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

  • 第7题：

    多选题
    Which two statements about the background process of the database writer are true（）
    A

    It is possible to have multiple database writers in an Oracle instance.

    B

    It writes dirty buffers， if any， to data files whenever a checkpoint occurs.

    C

    It writes dirty buffers， if any， to data files whenever a transaction commits.

    D

    It writes dirty buffers， if any， to data files before the log writer （LGWR） writes


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

  • 第8题：

    多选题
    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）
    A

    Restore the lost data file from the backup， and then flash back the database.

    B

    Restore the data file pertaining to index tablespace， and then recover the tablespace.

    C

    Restore all the data files， and then perform an incomplete recovery to get the tablespace back.

    D

    Restore all the data files， and then perform an incomplete recovery using the backup control file.

    E

    Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.


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

  • 第9题：

    多选题
    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
    A

    It releases the storage space used by the table.

    B

    It does not release the storage space used by the table.

    C

    You can roll back the deletion of rows after the statement executes.

    D

    You can NOT roll back the deletion of rows after the statement executes.

    E

    An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

    F

    You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table


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

  • 第10题：

    多选题
    Which two operations require undo data？（）
    A

    committing a transaction

    B

    rolling back a transaction

    C

    recovering from failed transactions

    D

    recording a transaction to redo log files

    E

    rolling forward during instance recovery


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

  • 第11题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第12题：

    单选题
    You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
    A

    Uses undo data for roll forward

    B

    Uses Flashback Log for recovery

    C

    Uses online redo logs to roll back

    D

    Uses undo data to roll back the transaction

    E

    Uses Recovery Manager （RMAN） to roll back

    F

    Uses the System Monitor （SMON） background process to perform instance recovery


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

  • 第13题：

    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第14题：

    Which three statements are true about Flashback Database?（）

    • A、Flashback logs are written sequentially, and are archived.
    • B、Flashback Database uses a restored control file to recover a database.
    • C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
    • D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
    • E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
    • F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

    正确答案:B,C,F

  • 第15题：

    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第16题：

    Which two statements about the background process of the database writer are true（）

    • A、It is possible to have multiple database writers in an Oracle instance.
    • B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
    • C、It writes dirty buffers， if any， to data files whenever a transaction commits.
    • D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes

    正确答案:A,B

  • 第17题：

    多选题
    Which three statements are true about Flashback Database?（）
    A

    Flashback logs are written sequentially, and are archived.

    B

    Flashback Database uses a restored control file to recover a database.

    C

    The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

    D

    Flashback Database can recover a database to the state that it was in before a reset logs operation.

    E

    Flashback Database can recover a data file that was dropped during the span of time of the flashback.

    F

    Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.


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

  • 第18题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


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

  • 第19题：

    单选题
    One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
    A

    uses undo data for roll forward

    B

    uses Flashback Log for recovery

    C

    uses online redo logs to roll back

    D

    uses undo data to roll back the transaction

    E

    uses Recovery Manager （RMAN） to roll back

    F

    uses the System Monitor （SMON） background process to perform instance recovery


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

  • 第20题：

    多选题
    Which two statements about Recovery Manager （RMAN） backups are true？ （）
    A

    Online redo log files can be backed up.

    B

    Archived redo log files are backed up.

    C

    Only used data blocks can be backed up as backup sets.

    D

    Only consistent database backups can be performed.

    E

    RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.


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

  • 第21题：

    多选题
    Which two statements are true about Oracle Managed Files (OMF)?（）
    A

    OMF cannot be used in a database that already has data files created with user-specified directions.

    B

    The file system directions that are specified by OMF parameters are created automatically.

    C

    OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

    D

    OMF automatically creates unique file names for table spaces and control files.

    E

    OMF may affect the location of the redo log files and archived log files.


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

  • 第22题：

    单选题
    You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
    A

    The online redo log files and archived redo log files are required to accomplish the recovery.

    B

    The uncommitted transaction will be committed at the next startup of the database instance.

    C

    The uncommitted transaction is rolled back automatically at the next opening of the database.

    D

    The DBA has to perform the recovery on the database to recover the uncommitted transaction


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

  • 第23题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


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

相关内容