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

题目内容(请给出正确答案)

单选题

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？（）

Transactions are rolled back using redo log files.

Transactions are rolled forward using redo log files.

Transactions are rolled back using redo log files and archived log files.

Transactions are rolled forward using redo log files and rolled back using redo log files.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

多选题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？（）AThis operation resets the SCN for the database.BThis operation creates a new incarnation of the database.CThis operation moves all the redo log files to a different location.DThis operation deletes the old redo log files and creates new redo log files.EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

点击查看答案
第2题

单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）Aonline redo log filesBalert log filesCcontrol fileDdatafiles associated with the SYSTEM tablespace

点击查看答案
第3题

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

点击查看答案
第4题

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

点击查看答案
第5题

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

点击查看答案
第6题

单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）A Open the database in NORMAL modeB Open the database in read-only modeC Open the database in RESTRICTED modeD Open the database with the RESETLOGS option

点击查看答案
第7题

多选题In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）Athe V$LOG viewBthe V$DBFILE viewCthe V$LOGFILE viewDthe V$INSTANCE_RECOVERY viewEOracle Enterprise Manager Database Control

点击查看答案

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

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

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