• Description:11i Applications DBA Fundamentals II
• Passing Score:75%
• Practice Test - Number of questions:105 questions
• Simulation Test - Number of questions:105 questions
• Simulation Test Duration:90 minutes
• Has explanations:No

Jones and a couple of other users complain that their transactions on one of the application tables, TECH, are waiting for a response. On investigation, you find that one of the users, Smith, has not committed his transaction on the TECH table and he is not at his desk. What would you do to release the lock irrespective of the end result of Smith's transaction?

Answer(s)

1. kill Smith's session
2. perform a rollback operation in your session on behalf of Smith's session
3. Smith's session will be terminated automatically by altering the user SMITH to use a profilewith an idle time limit.
4. no explicit action required (The lock will be released by the Oracle database automatically afterspecified number of seconds in the DML_LOCKS parameter.)

kill Smith's session