QUESTION 26
Examine this AWRreport excerpt:

You must reduce the impact of database I/O, without increasing buffer cache size and without modifying the SQL statements.
Which compression option satisfies this requirement?

QUESTION 27
A database supporting a mixed workload is hosted on a server with 64 CPUs.
A large number of free buffer waits and buffer busy waits occur affecting performance.
The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.
Examine these parameter settings:

Which two actions can help reduce the number of these waits7

QUESTION 28
Which two Oracle Database features use database services?

QUESTION 29
Which two actions can cause invalidation or loss of one or more results in the SQL Query Result Cache?

QUESTION 30
Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

QUESTION 31
Examine these statements and output:

What parameter change activates the generation and use of SQL Plan Directives7

QUESTION 32
Which two types of performance problems are reported by ADDM for PDBS?

QUESTION 33
Which statement is true about DB time in V$$YS_TIME_MODEL?

QUESTION 34
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?

QUESTION 35
Which two options are part of a Soft Parse operation?

QUESTION 36
You want to reduce the amount of db file scattered read that is generated in the database.You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?

QUESTION 37
Examine these commands, which execute successfully:

Which statement is true?

QUESTION 38
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?

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

QUESTION 40
You must write a statement that returns the ten most recent sales. Examine this statement:

Users complain that the query executes too slowly. Examine the statement’s current execution plan:

What must you do to reduce the execution time and why?

QUESTION 41
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?

QUESTION 42
Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true’

QUESTION 43
Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?

QUESTION 44
You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?

QUESTION 45
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?

QUESTION 46
Examine this command:

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

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

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