Oracle Database 19c Performance and Tuning Management - 1Z0-084 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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$RMAN_BACKUP_JOB_DETAILS C. V$SESSION_LONGOPS D. V$SESSION

Discussion 0

Correct Answer: C Vote an answer

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

Question 2

Examine this statement and output:

Which two situations can trigger this error?

A. The instance is unable to access the capture directory. B. There is a file in the capture directory. C. The capture directory is part of the root file system. D. The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory. E. The syntax is incomplete.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question 3

You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:

Where do you find the output of this command?

A. By viewing V$SERV_MOD_ACT_STATS B. In the current working directory C. In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace D. By viewing V$SERVICE_STATS

Discussion 0

Correct Answer: A Vote an answer

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

Question 4

During which application lifecycle phase do you take baselines?

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

Discussion 0

Correct Answer: D Vote an answer

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

Question 5

Which two statements are true about disabling Automatic Shared Memory Management (ASMM)?

A. Both SGA_TARGET and SGA_MAX_SIZE must be set to zero. B. The SGA size remains unaffected after disabling ASMM. C. All auto-tuned SGA components are reset to their original user-defined values. D. It requires a database instance restart to take effect. E. All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM. F. All SGA components retain their current sizes at the time of disabling.

Discussion 0

Correct Answer: B,F Vote an answer

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

Question 6

What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?

A. STATISTICS_LEVEL=BASIC and CONTROL_MANAGEMENT_PACK ACCESS=DIAGOSTIC B. STATISTICS_LEVEL=ALL and
CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING C. STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS-
DIAGOSTIC*TUNING D. STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC

Discussion 0

Correct Answer: B Vote an answer

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