You execute the following command to start an Automatic Stor

题目
单选题
You execute the following command to start an Automatic Storage Management (ASM) instance:   SQL>STARTUP;   In which of the following modes will the ASM instance start?()
A

 OPEN

B

 MOUNT

C

 NORMAL

D

 NOMOUNT

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

第1题:

A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?()

A. The keep pool is not configured.

B. Automatic Workarea Management is not configured.

C. Automatic Shared Memory Management is not enabled.

D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view


参考答案:D

第2题:

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:   RESTORE CONTROLFILE FROM AUTOBACKUP;   Which of the following statements is true?() 

  • A、 The command restores only the missing control file.
  • B、 The command restores all the control files.
  • C、 The command fails because the database is running.
  • D、 This is the correct way to address this problem.
  • E、 This is not the correct way to address this problem.

正确答案:C,E

第3题:

View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()

A. 4

B. 8

C. 7

D. 0


参考答案:A

第4题:

A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?()

  • A、The keep pool is not configured.
  • B、Automatic Workarea Management is not configured.
  • C、Automatic Shared Memory Management is not enabled.
  • D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
  • E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

正确答案:D

第5题:

Your home computer runs Windows 2000 Professional. You have just installed a new application and restarted the computer. During the boot process you receive the following error message: "NTLDR is missing - Press any key to restart." You do not have an emergency repair disk. You want your computer to start properly. You want to do this with the least amount of administrative effort.  What should you do?()

  • A、Reinstall the operating system.
  • B、Start the computer by using the Windows 2000 Professional CD-ROM.
  • C、Select Repair option and choose the option to verify system files.
  • D、Start the recovery console and type Diskpart from the command prompt.
  • E、Start the recovery console and enter Fixmbr from the command prompt.

正确答案:B,C

第6题:

You are troubleshooting a WAN connection for TestKing, and on the router you execute the, "debug ppp authentication" command, and view the following output:What kind of handshake was used for the PPP authentication?()

A. one-way

B. two-way

C. three-way

D. No handshakes required during authentication

E. None of the above


参考答案:C

第7题:

Cer-tech .com has a single Active Directory domain called cer-tech.com. All servers in the domain runWindows Server 2008. There are two domain controllers in the network: ED1 and ED2 and the DNS service is installed on the domain controllers. Both DNS servers host Active Directory integrated zones thatare configured to allow the most secured updates. ED1 has a Key Management Services (KMS) installedand activated. During maintenance, you find that the service locater records from the cer-tech.com zonehosted on Server02 and Server02 are missing. You have to force registration of the KMS service locatorrecords in the Cer-tech .com zone. What should you do to correct this problem?()

  • A、Execute slmgr.vbs script on ED1 at the command prompt
  • B、Configure non-secure updates on cer-tech.com
  • C、Execute the net stop netlogon command on ED2 and run net start logon command
  • D、At the command prompt on ED1, run net stop sppsvc command and after that execute the net start sppsvc command

正确答案:D

第8题:

You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?()

A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE

B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE

C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE

D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE


参考答案:C

第9题:

You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error:   ERROR:   ORA-12541:TNS:no_listener   You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true?()

  • A、It would attempt to start the default listener
  • B、It would start the most recently created listener.
  • C、It would display an error with a message asking for the listener name to be specified.
  • D、It would show you a list of listeners and prompts for the listener name that you want to start.

正确答案:A

第10题:

Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()

  • A、Start the server with the – innodb_recover_options option set to FORCE
  • B、Start the server with the – innodb_force_recovery option set to a non-zero value
  • C、Start the server as usual, and then execute the REPAIR TABLE command
  • D、Start the server as usual, and then execute the CHECK TABLE command

正确答案:B

更多相关问题