Web Applications   «Prev  Next»
 

Oracle Execution Plan Techniques - Quz

Advanced Execution Plan Techniques

1. Which were listed as tuning techniques for Web-based Oracle applications?
Please select all the correct answers.
  A. Use alternative locking mechanisms to avoid the SELECT FOR UPDATE clause
  B. Place the WebServer software on a separate computer
  C. Pre-aggregate any summary information that may be requested from the Web
  D. Limit the amount of returned Oracle data to the amount of data that the end-user will immediately require

2. Which platform layer would contain the WRB and the Web Listener?
Please select the best answer.
  A. The client platform
  B. The application server platform
  C. The database server platform

3. Which were listed as reasons for avoiding the SELECT FOR UPDATE with Web applications?
Please select all the correct answers.
  A. The Web connections are unreliable, and a disconnected client can lead to zombie locks in the shared pool.
  B. Disconnected clients can lead to unnecessary wasted memory in the data buffer memory.
  C. Disconnected clients can lead to unnecessary row locks.
  D. Disconnected clients can lead to runaway tasks, causing Oracle performance degradation.