Online Access Free 1z1-084 Practice Test

You manage a 19c database with default optimizer settings.
This statement is used extensively as subquery in the application queries:
SELECT city_id FROM sh2.sales WHERE city_id=:Bl
You notice the performance of these queries is often poor and, therefore, execute:
SELECT city_id,COUNT(*) FROM sh2.sales GROUP BY city_id;
Examine the results:

There is no index on the CITY_ID column.
Which two options improve the performance?

• A.Create an index on the CITY IP column.
• B.Activate the adaptive plans.
• C.Force the subquery to use dynamic sampling.
• D.Use a SQL Profile to enforce the appropriate plan.
• E.Generate frequency histograms on the CITY__ID column.

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

• A.GGREGATE_TARGET should be set to at least 700 MB.
• B.With a target of 800 MB or more, all one-pass execution work areas would be eliminated.
• C.With a target of 700 MB or more, all multipass executions work areas would be eliminated.
• D.PGAA_AGGREGATE should be set to at least 800 MB.

Examine this statement and output:

Which two situations can trigger this error?

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

Examine this statement and output:

Which three statements are true?

• A.Both 9822 and 8779 sessions are waiting for operating system resources.
• B.Session 9857 waited 1354 seconds for another process, which was also waiting for a transaction to end.
• C.Session 8779 may be waiting due to a network problem.
• D.Session 8779 may be waiting for a user or application response.
• E.Session 9822 will always stop waiting if the session that owns the TX enqueue issues a COMMIT statement as session 9822 is the first session in the transaction queue.
• F.Session 9857 is not waiting.

Which application lifecycle phase could be managed reactively?

• A.Testing
• B.Upgrade or migration
• C.Deployment
• D.Production
• E.Design and development