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

You database is running an ARCHIVELOG mode.<br /> The following parameter are set in your database instance:<br /> LOG_ARCHIVE_FORMAT = arch+%t_%r.arc<br /> LOG_ARCHIVE_DEST_1 = &lsquo;LOCATION = /disk1/archive&rsquo;<br /> DB_RECOVERY_FILE_DEST_SIZE = 50G<br /> DB_RECOVERY_FILE = &lsquo;/u01/oradata&rsquo;<br /> Which statement is true about the archived redo log files?（）

A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B、They are created only in the Fast Recovery Area.

C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

查看正确答案
更多“ You database is running an ARCHIVELOG mode.<br /> The following parameter are set in your database instance:<br /> LOG_ARCHIVE_FORMAT = arch+%t_%r.arc<br /> LOG_ARCHIVE_DEST_1 = &lsquo;LOCATION = /disk1/archive&rsquo;<br /> DB_RECOVERY_FILE_DEST_SIZE = 50G<br /> DB_RECOVERY_FILE = &lsquo;/u01/oradata&rsquo;<br /> Which statement is true about the archived redo log files?（）”相关的问题
第1题
[单选题] Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）

A、By default, EM express is available for a database after database creation.  B、You can use EM express to manage multiple databases running on the same server.  C、You can perform basic administrative tasks for pluggable databases by using the EM express interface.  D、You cannot start up or shut down a database Instance by using EM express.  E、You can create and configure pluggable databases by using EM express.  

点击查看答案
第2题
[单选题] Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

A、The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.  B、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.  C、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.  D、If you restart the database, the database will not be opened.  

点击查看答案
第3题
[单选题] Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

A、The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.  B、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.  C、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.  D、If you restart the database, the database will not be opened.  

点击查看答案
第4题
[单选题] You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

A、Run Segment Advisor  B、Run the SQL Tuning Advisor (STA)  C、Run the Automatic Workload Repository (AWR) report  D、Run the SQL Access Advisor with a hypothetical workload  

点击查看答案
第5题
[单选题] You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

A、Run Segment Advisor  B、Run the SQL Tuning Advisor (STA)  C、Run the Automatic Workload Repository (AWR) report  D、Run the SQL Access Advisor with a hypothetical workload  

点击查看答案
第6题
[] our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

A、A. Oracle Net Manager  B、B. Listener Control utility  C、C. Database Configuration Assistant  D、D. Oracle Net Configuration Assistant  

点击查看答案
第7题
[] Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

A、A. Oracle Net Manager  B、B. Listener Control utility  C、C. Database Configuration Assistant  D、D. Oracle Net Configuration Assistant  

点击查看答案
第8题
[多选题] You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

A、The source database backup must be copied over the net for test database.  B、The source database must be run in ARCHIVELOG mode if the database is open.  C、The source database must be shut down cleanly if the database is in mounted state.  D、A net service name should be set up and a listener configured with the target as well as the source database.  

点击查看答案
第9题
[单选题] The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

A、You should perform a log switch  B、You should make a backup of the database  C、You should switch the database to the NONARCHIVELOG mode  D、You should shut down the database instance and perform a complete database recovery  

点击查看答案
第10题
[单选题] The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

A、You should perform a log switch  B、You should make a backup of the database  C、You should switch the database to the NONARCHIVELOG mode  D、You should shut down the database instance and perform a complete database recovery  

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

请使用微信扫码支付

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