A execute the command alter session kill to kill the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: sion B. execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session C. execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking session D. execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking session E. execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session Answer: C QUESTION 107: Exhibit. Actualtests.com - The Power of Knowing 1Z0-042 Which two options are used to enable the connect-time failover feature? (Choose two.) A. Use only the first address. B. Try one address, selected at random. C. Try each address, in order, until one succeeds. D. Try each address, randomly, until one succeeds. E. Use each address in order until destination reached. Answer: C,D QUESTION 108: You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics? A. The baseline, once created, cannot be removed. B. Disable the baseline metrics in the Database Control Manage Metrics page. C. The baseline will be automatically removed once the database performance has been optimized. D. Drop the baseline metrics by using Actualtests.com - The Power of Knowing 1Z0-042 DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure. Answer: D QUESTION 109: Exhibit. Your Oracle 10g database has 6 tablespaces in which: -TEMP is the default temporary tablespace - UNDOTBS1 is the default undo tablespace - USERS is the default permanent tablespace In this database, which three tablespaces can be made offline? (Choose three.) A. TEMP B. PROD C. USERS D. SYSAUX E. SYSTEM F. UNDOTBS1 Answer: B,C,D QUESTION 110: A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on Actualtests.com...
View Full Document

Ask a homework question - tutors are online