Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

The CURS0R_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an awr report are due to a large number of hard parses because of several almost identical SQL statements.

Which two actions could reduce the number of hard parses?

A.

Create the KEEP cache and cache tables accessed by the SQL statements.

B.

Create the RECYCLE cache and cache tables accessed by the SQL statements.

C.

Increase the size of the library cache.

D.

Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE.

E.

Set the CURSOR_SHARING parameter to FORCE.

Which three statements are true about using the in Memory (IM) column store?

A.

It does not improve performance for queries using cached results of function evaluations on columns from the same table.

B.

It does not improve performance for queries that use join groups on columns from different tables.

C.

It can improve OLTP workload performance by avoiding the use of indexes.

D.

It does not improve performance for queries using user-defined virtual column results.

E.

It does not require all database data to fit in memory to improve query performance.

F.

It improves performance for queries joining several tables using bloom filter joins.

Examine this statement and output:

Which two situations can trigger this error?

A.

The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory.

B.

There is a file in the capture directory.

C.

The syntax is incomplete.

D.

The capture directory is part of the root file system.

E.

The instance is unable to access the capture directory.

What is the right time to stop tuning an Oracle database?

A.

When the allocated budget for performance tuning has been exhausted

B.

When all the concurrency waits are eliminated from the Top 10

C.

When the buffer cache and library cache hit ratio is above 95%

D.

When the I/O is less than 10% of the DB time

E.

When the tuning goal has been met

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 $ORACLE_BASE/diag/rdbms///trace

C.

By viewing V$SERVICE_STATS

D.

In the current working directory

Examine this command:

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

A.

1

B.

3

C.

52

D.

5

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 expdp from Statspack and import it by using $ORACLE_HOME/rdbms/admin/awrload into the AWR repository.

B.

Export the data by using expdp from the ftatspack repository and import it by using impdp into the AWR repository.

C.

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.

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.

During which application lifecycle phase do you take baselines?

A.

Testing

B.

Migration or upgrade

C.

Design and development

D.

Deployment

E.

Production

Buffer cache access is too frequent when querying the SALES table. Examine this command which executes successfully:

ALTER TABLE SALES SHRINK SPACE;

For which access method does query performance on sales improve?

A.

db file scattered read

B.

db file sequential read

C.

index full scan

D.

index range scan

You use SQL Tuning Advisor to tune a given SQL statement.

The analysis eventually results in the implementation of a SQL Profile.

You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.

Which two statements are true?

A.

The existence of two concurrent plan stability methods generates a child cursor for every execution.

B.

The SQL Profiles as well as SQL Plan Baseline are implemented using hints, so they both generate the same plan.

C.

The execution plan is the one enforced by the SQL Profile.

D.

The execution plan is the one enforced by the SQL Plan Baseline.

E.

The SQL Plan Baseline must be accepted in order to be used for the execution plan.

F.

The conflict between the two plan stability methods results in an error.