Exam 1z0-062 topic 1 question 286 discussion

Actual exam question from Oracle's 1z0-062

Question #: 286
Topic #: 1

Examine the parameters:

Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.
Which two actions would you take to prevent this problem? (Choose two.)

A. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.
B. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
C. Set a limit in the profiles of blocking users to control the number of data blocks that can be accessed in a session.
D. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.
E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.

Show Suggested Answer

Suggested Answer: DE 🗳️

by khan at April 2, 2019, 12:02 a.m.

Comments

Submit Cancel

khan

Highly Voted 5 years, 8 months ago

think, DE If a user exceeds the CONNECT_TIME or IDLE_TIME session resource limit, then the database rolls back the current transaction and ends the session. When the user process next issues a call, the database returns an error. https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310

upvoted 11 times

...

Sugar

Highly Voted 5 years, 1 month ago

Agree with khan DE

upvoted 7 times

...

dfabac

Most Recent 2 years, 6 months ago

Selected Answer: DE

I think DE

upvoted 1 times

...

jackymak

2 years, 8 months ago

Selected Answer: DE

Agree DE

upvoted 3 times

NorwayOracle

2 years, 8 months ago

Agree.

upvoted 1 times

...

Muhammadnagah

5 years, 1 month ago

i think DE

upvoted 5 times

...

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam