Online Access Free 1z1-084 Practice Test

You need to transport performance data from a Standard Edition to an Enterprise Edition database. What is the recommended method to do this?

• A.Export the data by using the expdp utility and parameter file spuexp.par from the Statspack repository and import it by using impdp into Export the data by using expdp from the Statspack repository and import it by using impdp into the AWR repository.
• B.Export the data by using expdp from Statspack and import it by using $ORACLE_HOME/rdbms/admin
  /awrload into the AWR repository.
• C.Export the data by using expdp from the ftatspack repository and import it by using impdp into the AWR repository.
• D.Export the data by using the exp utility and parameter file spuexp.par from the Statspack repository and import it by using imp into a dedicated Statspack schema on the destination.

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

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

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.Force the subquery to use dynamic sampling.
• B.Create an index on the CITY IP column.
• C.Activate the adaptive plans.
• D.Use a SQL Profile to enforce the appropriate plan.
• E.Generate frequency histograms on the CITY__ID column.

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.In the current working directory
• B.By viewing V$SERVICE_STATS
• C.In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace
• D.By viewing V$SERV_MOD_ACT_STATS

During which application lifecycle phase do you take baselines?

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