Wednesday, February 24, 2010

Why do stored procedures and functions improve performance? (Chose two)

  • They reduce network round trips.
  • They postpone PL SQL parsing until run tune.
  • They allow the application to perform high speed processing locally.
  • Thev reduce the number of calls to the database and decrease network traffic by bundling commands.
  • Thev reduce the number of calls to the database and decrease network traffic by using the local PL SQL engine.
B & D