Oracle 1Z0-084 Quiz 1 Topic 1 Questions 1-5

Question: 1

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?

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

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

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

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

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

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

Show Answer

Question: 2

SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.

MEMORY_target is then set to a nonzero value but memory_MAX_TARGT is not set.

Which two statements are true?

A)

q2_1Z0-084

B)

q2_1Z0-084

C)

q2_1Z0-084

D)

q2_1Z0-084

E)

q2_1Z0-084

F)

q2_1Z0-084

G)

q2_1Z0-084

AOption

BOption

COption

DOption

EOption

FOption

GOption

Show Answer

Question: 3

What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?

ASTATISTICS_LEVEL=ALL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING

BSTATISTICS_LEVEL=BASIC and CONTROL_MANAGEMENT_PACK ACCESS=DIAGOSTIC

CSTATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS-DIAGOSTIC*TUNING

DSTATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC

Show Answer

Question: 4

Examine this code block, which executes successfully:

DBMS_SERVER_ALERT. SET_THRESHOLD (

DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, DBMS_SERVER_ALERT. OPERATOR_GE, '8000',

DBMS_SERVER_ALERT.OPERATOR_GE, '10000', 1, 2, 'inst1',

DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, 'main.regress.rdbms.dev.us.example.com') ;

q4_1Z0-084

What will happen?

AA warning alert will be issued when CPU time exceeds 1 minute for each user call.

BA critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.

CA warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.

DA critical alert will be issued when CPU time exceeds 2 minutes for each user call.

Show Answer

Question: 5

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

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

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

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

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

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

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

Show Answer

Oracle 1Z0-084 Quiz:1 Topic:1 Questions:1-5