Oracle Database 19c Performance and Tuning Management

QUESTION NO: 1
Examine these commands, which execute successfully:

Which statement is true?

A. AD DM is enabled for all pluggable databases. B. ADDM, AWR, and ASH reports can be purged automatically. C. AWR snapshots can be purged manually in pluggable databases. D. AWR- snapshots in all pluggable databases will be purged automatically after every 60 mins.

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

A. Compress the SALES table. B. Coalesce all sales table indexes. C. Re-create the SALES table. D. Partition the SALES table. E. Increase PCTFREE for the SALES table.

Correct Answer: A,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?

A. enq: HW - contention B. enq: TX - allocate ITL entry C. enq: SQ - contention D. enq: TM - contention

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
During which application lifecycle phase do you take baselines?

A. Deployment B. Production C. Design and development D. Testing E. Migration or upgrade

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed.
Which view has this information?

A. V$SESSTAT B. V$SESSION C. V$SESSION_LONGOPS D. V$RMAN_BACKUP_JOB_DETAILS

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
Which two options are part of a Soft Parse operation?

A. SQL Row Source Generation B. Semantic Check C. Shared Pool Memory Allocation D. SQL Optimization E. Syntax Check

Correct Answer: B,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

Oracle Database 19c Performance and Tuning Management - 1Z0-084 Exam Questions