nerdexam
Oracle

1Z0-054 · Question #49

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…

The correct answer is C. logging in and logging out of sessions D. all DDL statements having bind variables. See the full explanation below for the reasoning.

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

How the community answered

(46 responses)
  • A
    11% (5)
  • B
    15% (7)
  • C
    72% (33)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice