Oracle Database 12c: Performance Management and Tuning Free Sample Questions

12 free sample questions119 in the full practice test Other version: 1Z0-084(188)

Try simulator

1z0-064 Sample Questions

  1. Question 1

    Multiple answers

    To investigate the slow response time of queries on the TRANS table, you gathered the table statistics and executed the query:

    The table is stored in a tablespace that has Automatic Segment Space Management (ASSM) enabled. The tablespace is created with a standard block size of 8192 bytes.

    Which three can be reasons for the slow response time of the queries? (Choose three.)

    Question 1 image
    Answer and explanation

    Correct answers: A, B, D

    A, B, D

  2. Question 2

    Multiple answers

    Examine the parameters set for your database instance:

    You are administrating a database that supports a DSS workload. You make some changes to the sizes of memory components. Consequently, you receive this error:

    Which three actions might resolve the issue?

    Question 2 image
    Answer and explanation

    Correct answers: C, D, F

    C, D, F -- https://docs.oracle.eom/en/database/oracle/oracle-database/19/refrn/PGA AGGREGATE TARGET.html#GUID-DEBBD3F7-9F6D-4AC8-952C-0E0B2E62312D

  3. Question 3

    You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.

    Which action would you take to achieve this? (Choose the best answer.)

    Answer and explanation

    Correct answer: C

    C

  4. Question 4

    Multiple answers

    Examine the parameters set for your database instance:

    To investigate the slow response time of queries on the TRANS table, you gather table and execute the query:

    The table is stored in a tablespace with Automatic Segment Space Management (ASSM), and some rows of the TRANS table are migrated and chained.

    Which two actions would you recommend to improve query response time?

    Question 4 image
    Answer and explanation

    Correct answers: A, D

    A, D

  5. Question 5

    Multiple answers

    You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%.

    Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)

    Answer and explanation

    Correct answers: A, F

    A, F

  6. Question 6

    Multiple answers

    Which three actions should you perform to reduce shared pool fragmentation and avoid the “ORA-04031: unable to allocate .... bytes of shared memory” error for the shared pool? (Choose three.)

    Answer and explanation

    Correct answers: A, B, D

    A, B, D

Register free for 6 more questions

Or unlock all 119 1z0-064 questions with explanations, timed mode and flashcards.