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 onto the database to continue his work. 
ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

单项选择题Youhavecreatedabaselinemetric，DISK_IO_BL，forthediskI OmetricsinyourPRODdatabaseandyouhavebeengettingnotificationswheneverthedatabaseperformancedegrades.YouoptimizethedatabaseI Otogaintheperformanceandyoudecidetoremovethebaselinemetrics.WhichmethodwouldyouusetoremovetheDISK_IO_BLbaselinemetrics？（）

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 usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.

多项选择题Exhibit. Which two options are used to enable the connect-time failover feature？（）

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.

单项选择题One of the users in the PROD database，Adams，complains that his update on the table，TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions，and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority.  Which method would you use to overcome this problem？（）

A.execute the command， ALTER SESSION KILL ..， to kill the blocking session
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

单项选择题Whatadvantagewouldyougetifyouincreasethelengthoftimeduringwhichtheundoinformationwouldbestoredinthedatabase？（）

A.roll back of large transactions
B.roll forward to redo a transaction
C.data concurrency for large updates
D.read consistency for long-running transactions

单项选择题The database users are connecting to the PROD database from different  applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one.  Which action would you take to achieve this objective？（）

A.set the SESSIONS to 1 in the parameter file
B.grant SINGLE SESSION privilege to all of the users
C.set the SESSIONS_PER_USER to 1 in the users’ profile
D.grant RESTRICTED SESSION privilege to all of the database users
E.create a role with SINGLE SESSION privilege and assign the role to the users