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

You want to enable archiving on your database. Presently， th

题目
单选题
You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
A

4， 1， 3， 2， 5

B

1， 3， 4， 5， 2

C

1， 3， 2， 5； 4 not required

D

4， 1， 5， 2； 3 not required

E

1， 3， 4， 5； 2 not required

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

第1题：

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.

Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

What should you do?

A．Enable the torn page detection database option for each database.

B．Disable write caching on all disk controllers.

C．Ensure that write caching disk controllers have battery backups.

D．Create a database maintenance plan to check database integrity and make repairs each night.


正确答案：C
解析：Explanation:Thescenariostatesthatpowerinterruptionshaveoccurredinthepast.Bybuyingabatterybackupsolutionforthediskcontrollersthepowerinterruptionproblemwouldbeprevented.IncorrectAnswers:A:Tornpagedetectionisareactivesolutionwhichwouldslowdownperformancesincerestoreswouldhavetobemade.Itwouldbettertouseapreventivesolution.Note:Tornpagedetection:Ifatornpageisdetected,thedatabasemustberestoredfrombackupbecauseitwillbephysicallyinconsistent.B:Cachingisveryimportforperformance.Disablingwrite-cachingwouldbeabadidea.D:Repairingthedatabaseeverynightisnotagoodsolution.Databaseerrorscannotbeaccepted.Itisbettertopreventtheprobleminsteadoftryingtofixitafterithashappened.

第2题：

You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）

  • A、to enable the ASM instance to identify the alert log file
  • B、to enable the ASM instance to identify the server parameter file
  • C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
  • D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

正确答案:B

第3题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()

A. Set MEMORY_TARGET to zero

B. Set the STATISTICS_LEVEL parameter to BASIC

C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value


参考答案：D

第4题：

You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet. What should you do？ （）

  • A、Enable Internet Connection Sharing
  • B、Enable on-demand dialing
  • C、Enable sharing a modem on one computer on the network
  • D、Configure a DHCP Server
  • E、Disable Internet Connection Sharing

正确答案:A

第5题：

You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）

  • A、 Enable the flash recovery area and specify it as the archived redo log destination.
  • B、 Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
  • C、 Enable the flash recovery area but do not specify it as the archived redo log destination. 
  • D、 Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

正确答案:A

第6题：

You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）

  • A、 Open the database in read-only mode.
  • B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
  • C、 Enable the block change tracking feature.
  • D、 Execute the ALTER DATABASE FLASHBACK ON statement.

正确答案:A,C

第7题：

You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet.  You have enabled Internet connection sharing. You do not want to initiate this connection automatically when a request for Internet reaches your computer. What should you do? （）

  • A、You should uncheck “Enable on demand dialing
  • B、Enable on-demand dialing
  • C、Enable sharing a modem on one computer on the network
  • D、Configure a DHCP Server
  • E、Disable Internet Connection Sharing

正确答案:A

第8题：

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;


参考答案：C

第9题：

You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）

  • A、 the system change number
  • B、 the locations of the redo log files
  • C、 the locations of the datafiles
  • D、 the physical location of all the database changes

正确答案:D

第10题：

You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet. What should you do？ （）

  • A、Enable Internet Connection Sharing
  • B、Enable on-demand dialing
  • C、Enable sharing a modem on one computer on the network
  • D、Configure a DHCP Server
  • E、Disable Internet Connection Sharing
  • F、Configure all the other computers to be DHCP enabled.

正确答案:A,F

更多相关问题
相关内容