Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（） Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）..

第1题

[] To examine the Exhibit, press the Exhibit button. Which option would produce this output from the errpt command? （） To examine the Exhibit, press the Exhibit button. Which option would produce this output from the errpt command? （）

A、A. errpt -t B、B. errpt -a C、C. errpt -D D、D. errpt

点击查看答案

第2题

[多选题] You are the administrator of a Windows Server 2003 computer named Server1. The hardware vendor for Server1 notifies you that a critical hotfix is available. This hotfix is required for all models of this computer that have a certain network interface card. You need to find out if the network interface card that requires the hotfix is installed in Server1. What are two possible ways to achieve this goal? （）(Each correct answer presents a complete solution. Choose two.)

A、Open Network Connections, and then examine the properties of each connection that is listed. B、Open the Component Services snap-in, expand Computers, expand My Computer, and then examine the list. C、Run the netsh interface command, and then examine the list. D、Open Device Manager, expand Network adapters, and then examine the list

点击查看答案

第3题

[单选题] View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.What is the reason for this error?（）

A、Another repair session is running concurrently. B、The failure ID has not been mentioned in the command for data file 5. C、There are new failures recorded in the Automatic Diagnostic Repository (ADR). D、The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

点击查看答案

第4题

[] Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（） Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（）

A、A. All three tables in the recycle bin are purged B、B. Only the table with the oldest DROPSCN is purged C、C. The command returns an error because multiple entries with the same name exist in the recycle bin D、D. Only the table with the latest DROPSCN is purged

点击查看答案

第5题

[] You are the network administrator for You administer a Windows Server 2003 computer named TestKing5. The hardware vendor for TestKing5 notifies you that a critical hotfix is available. This hotfix is required for all models of this computer that have a certain network interface card. You need to find out if the network interface card that requires the hotfix is installed in TestKing5. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)（） You are the network administrator for You administer a Windows Server 2003 computer named TestKing5. The hardware vendor for TestKing5 notifies you that a critical hotfix is available. This hotfix is required for all models of this computer that have a certain network interface card. You need to find out if the network interface card that requires the hotfix is installed in TestKing5. What are two possible ways to achieve this goal? (Each correct answer

A、A. Open Network Connections, and then examine the properties of each connection that is listed. B、B. Open the Component Services snap-in, expand Computers, expand My Computer, and then examine the list. C、C. Run the netsh interface command, and then examine the list. D、D. Open Device Manager, expand Network adapters, and then examine the list.

点击查看答案

第6题

[单选题] You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?（）

A、A different procedure is required to restore a database from compressed backups B、The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. C、Using this command to create backups minimizes the bandwidth consumed D、Using this command to create backups improves the performance of the backup process

点击查看答案

第7题

[单选题] Examine the following command that is executed for the TRANSPORT table in the SH schema: Which statement describes the significance of this command?（）

A、It collects statistics into the pending area in the data dictionary B、It creates a virtual hidden column in the CUSTOMERS_OBE table C、It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT D、It creates a histogram to hold skewed information about the data in the columns

点击查看答案

第8题

[] Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?（） Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?（）

A、A. Implement RMAN multiplexing B、B. Set the DEBUG ON in the RMAN script C、C. Specify the command ID in the RMAN script D、D. Use a tag with the RMAN BACKUP command

点击查看答案

第9题

[] 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（） 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、A. 4 B、B. 8 C、C. 7 D、D. 0

点击查看答案

请使用微信扫码支付