OPEN
MOUNT
NORMAL
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
第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?()
第3题:
A. 4
B. 8
C. 7
D. 0
第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?()
第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?()
第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
第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?()
第8题:
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
第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?()
第10题:
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()