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
D. execute the command, ALTER SESSION UNLOCK .., to release the lock for the
E. execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock
for the blocking session
Exhibit. Actualtests.com - The Power of Knowing 1Z0-042 Which two options are used to enable the connect-time failover feature? (Choose
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.
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
D. Drop the baseline metrics by using
Actualtests.com - The Power of Knowing 1Z0-042
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 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
View Full Document
- Fall '09
- administrator, Oracle Database, Certkiller