nerdexam
Oracle

1Z0-054 · Question #49

1Z0-054 Question #49: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.

Question

You are working on an online transaction processing (OLTP) system. The middle-tier applications use connection pooling to connect to the database. Presently, you have a single-node database. The company plans to migrate the database to a RAC environment. Before you move to a RAC environment, you want to test the performance of the SQL statements and the peak workload on the new environment. To accomplish the Database Capture for replay, you identified the peak workload period on the existing system and started the Database Capture. Which client requests to the database can be captured as part of the workload capture? (Choose all that apply.)

Options

  • Aflashback query
  • Bdistributed transactions
  • Clogging in and logging out of sessions
  • Dall DDL statements having bind variables
  • Edirect path load of data from external files

Unlock 1Z0-054 to see the answer

You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-054 Practice