Oracle 1Z0-084 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-084
Exam Name/Title: Oracle Database 19c Performance and Tuning Management
Certification Provider: Oracle
Corresponding Certification: Oracle Database 19c

Exam Questions: 57
Updated On: Jul 12, 2026

Question #13

You execute the following:
EXECUTE DBMS_AuTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

A. Automatic SQL Tuning

B. Automatic Optimizer Statistics Collection

C. Automatic Segment Advisor

D. Optimizer Statistics Advisor

E. SQL Plan Management Evolve Advisor

Discussion 0

Correct Answer: B Vote an answer

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

Question #14

Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

A. 52

B. 5

C. 3

D. 1

Discussion 0

Correct Answer: A Vote an answer

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

Question #15

A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

A. Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25

B. Setting PARALLEL_DEGREE_POLICYAUTO

C. Increasing DB_CACHESIZE to 1 G

D. Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50

E. Setting PARALLEL_DEGREE_POLICYADAPTIVE

F. Setting DB_KEEP_CACHE_SIZE to at least 50M

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #16

Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time?

A. The proportion of WAIT TIME to CPU TIME always increases with increased system load.

B. Parse Time Elapsed accounts for successful soft and hard parse operations only.

C. When WAIT TIME is high, instance tuning may improve performance.

D. Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.

E. DB Time accounts for all time used by background processes and user sessions.

F. Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question #17

During which application lifecycle phase do you take baselines?

A. Deployment

B. Production

C. Testing

D. Migration or upgrade

E. Design and development

Discussion 0

Correct Answer: B Vote an answer

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

Question #18

Which two statements are true about space usage in temporary tablespaces?

A. A sort will fail if a sort to disk requires more disk space and no additional extent can be found/allocated in/for the sort segment.

B. Lack of temporary tablespace space for sort operations can be prevented by using temporary tablespace groups.

C. When a global temporary table instantiation is too large to fit in memory, space is allocated in a temporary tablespace.

D. Temporary tablespaces setting Includes quotas to limit temporary space used by a session for that Temporary tablespace.

E. When a session consumes all temporary tablespace storage, then the session would hang until the temporary space used by that session is cleared.

Discussion 0

Correct Answer: B,C Vote an answer

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

Download Free Oracle 1Z0-084 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-084 exam.