违法和不良信息举报 联系客服
免费注册 登录

The database is configured for automatic archive logging. Al

题目
单选题
The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（）
A

control file

B

tnsnames.ora

C

data dictionary

D

initialization parameter file

参考答案和解析
正确答案： B
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)

A. Flash recovery area must be defined

B. Undo retention guarantee must be enabled.

C. Database must be running in archivelog mode.

D. Automatic undo management must be enabled.

E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).


参考答案：D, E

第2题：

You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.

You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.

You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?

A．Increase the maximum file size of Sales_Data to 1,500MB.

B．Use the DBCC SHRINKDATABASE statement.

C．Set automatic file growth to 10 percent.

D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.


正确答案：A
解析：Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.

Incorrect Answers:
B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.

C: The database is already set to automatic file growth, but it has reached the maximum size.

D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.

第3题：

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database

C. Create Flashback Data Archive in the tablespace where the tables are stored.

D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables


参考答案：D

第4题：

Which initialization parameter must you set to enable automatic archiving？ （）

  • A、LOG_ARCHIVE_DEST
  • B、LOG_ARCHIVE_START
  • C、LOG_ARCHIVE_FORMAT
  • D、LOG_ARCHIVE_MAX_PROCESSES

正确答案:B

第5题：

You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：   DROP FLASHBACK ARCHIVE fla1；   What is the effect of this command？（）

  • A、 The Flashback Archive FLA1 is dropped only if it is empty.
  • B、 The tablespace having Flashback Archive is dropped.
  • C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
  • D、 The Flashback Data Archive and historical data are dropped.

正确答案:D

第6题：

You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database.

C. Create a Flashback Data Archive in the tablespace where the tables are stored.

D. Create a Flashback Data Archive in any suitable tablespace.

E. Enable Flashback Data Archiving for the tables that require tracking


参考答案：D, E

第7题：

Your archive-log destination directory runs out of space. What is the impact of this on the database？（）  

  • A、 None. The database will switch over to the stand-by archive-log destination directory.
  • B、 A warning message will be written to the alert log of the database，but no adverse impacts to the database will be experienced.
  • C、 The database will shut down，and will not restart until you correct the out-of-space situation.
  • D、 The database will continue to try to write to the archive-log destination directory for one hour. After one hour，the database will shut down normally.
  • E、 Once Oracle has cycled through all online redo logs，it will stop processing any DML or DDL until the out-of-space condition is corrected.

正确答案:E

第8题：

Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)

A. Database must be running in archivelog mode.

B. Automatic undo management must be enabled.

C. Undo retention guarantee must be enabled.

D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).


参考答案：B, D

第9题：

Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

  • A、Flash recovery area must be defined
  • B、Undo retention guarantee must be enabled.
  • C、Database must be running in archivelog mode.
  • D、Automatic undo management must be enabled.
  • E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

正确答案:D,E

第10题：

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

  • A、 Enable Flashback Data Archive for the tables.
  • B、 Specify undo retention guarantee for the database.
  • C、 Enable supplemental logging for the database.
  • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
  • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

正确答案:A

更多相关问题
相关内容