搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one<br /> redo member. When you attempt to start the database, you receive the following errors:<br /> ORA-00313: open failed for members of log group 1 of thread 1<br /> ORA-00312: online log 1 thread 1: &#39;D:\REDO01.LOG&#39;<br /> You discover that the online redo log file of the current redo group is corrupted.<br /> Which statement should you use to resolve this issue?（）

A、ALTER DATABASE DROP LOGFILE GROUP 1;

B、ALTER DATABASE CLEAR LOGFILE GROUP 1;

C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D、ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG

查看正确答案
更多“ Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one<br /> redo member. When you attempt to start the database, you receive the following errors:<br /> ORA-00313: open failed for members of log group 1 of thread 1<br /> ORA-00312: online log 1 thread 1: &#39;D:\REDO01.LOG&#39;<br /> You discover that the online redo log file of the current redo group is corrupted.<br /> Which statement should you use to resolve this issue?（）”相关的问题
第1题
[单选题] You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A、Mount the database  B、Open the database in NORMAL mode  C、Open the database in RESTRICTED mode  D、Open the database with the RESETLOGS option  

点击查看答案
第2题
[单选题] You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A、Mount the database  B、Open the database in NORMAL mode  C、Open the database in RESTRICTED mode  D、Open the database with the RESETLOGS option  

点击查看答案
第3题
[] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（） You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、A. You must have change tracking enabled in your database  B、B. Your database must be running in NOARCHIVELOG mode  C、C. To back up a tablespace, it must be in backup mode  D、D. To back up a tablespace, it must first be taken offline  

点击查看答案
第4题
[单选题] Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

A、The database is in mount state.  B、One of the tablespaces is offline.  C、One of the tablespaces is read only.  D、The database operates in ARCHIEVELOG mode.  E、The database operates in NOARCHIEVELOG mode.  

点击查看答案
第5题
[单选题] Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

A、The database is in mount state.  B、One of the tablespaces is offline.  C、One of the tablespaces is read only.  D、The database operates in ARCHIEVELOG mode.   E、The database operates in NOARCHIEVELOG mode.  

点击查看答案
第6题
[多选题] In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）

A、The C # # ROLE1 role is created in the root database and all the PDBs.  B、The C # # ROLE1 role is created only in the root database because the container clause is not used.  C、Privileges are granted to the C##A_ADMIN user only in the root database.  D、Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.  E、The statement for granting a role to a user fails because the CONTAINER clause is not used.  

点击查看答案
第7题
[单选题] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、You must have change tracking enabled in your database  B、Your database must be running in NOARCHIVELOG mode  C、To back up a tablespace, it must be in backup mode  D、To back up a tablespace, it must first be taken offline  

点击查看答案
第8题
[] 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?（） 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 product

A、A. Open the database in NORMAL mode  B、B. Open the database in read-only mode  C、C. Open the database in RESTRICTED mode  D、D. Open the database with the RESETLOGS option  

点击查看答案
第9题
[] You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（） You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（）

A、A. Change the RMAN archived log deletion policy  B、B. Use the RMAN CROSSCHECK command to reclaim the archived log space  C、C. Change the RMAN retention policy to retain backups for a shorter period of time  D、D. Use OS command to move files from the flash recovery area to some other location  

点击查看答案
第10题
[单选题] 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 mode  B、Open the database in read-only mode  C、Open the database in RESTRICTED mode  D、Open the database with the RESETLOGS option  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服