Oracle Exam 1Z0-084 Topic 14 Question 26 Discussion

Actual exam question for Oracle's 1Z0-084 exam

Question #: 26
Topic #: 14

Which two statements are true about Data Pump import for objects that used the in Memory (IM) column store in their source database?

AIt always gives preference to the IM column store clause defined at the tablespace level over table-level definitions.

BIt must always transports existing INMEMORY attributes.

CIts INMEM0RY_CLAUSE of the Data Pump Export allows modifications to IM column store clause of a table with existing INMEMORY setting.

DIts TRANSFORM clause can be used to add the INMEMORV clause to exported tables that lack them.

EIt ignores the IM column store clause of the exporting objects.

FIt can generates the INMEMORY clause that matches the table settings at export time.

Show Suggested Answer

Suggested Answer: A, E, F

Statspack is a performance diagnostic tool provided by Oracle prior to the introduction of the Automatic Workload Repository (AWR). At snap level 6, Statspack captures the following types of statistics:

A (Correct): Parent and child latches are captured. Latch statistics provide information about contention for latches, which are low-level serialization mechanisms used by Oracle.

E (Correct): Enqueue statistics, which provide information on the waits for locks that manage the concurrency between users.

F (Correct): Segment-level statistics, which provide detailed information on database segments such as tables, indexes, etc., to identify I/O and contention issues.

C (Incorrect): While optimizer execution plans are an essential aspect of performance tuning, detailed execution plan capture is not part of the Statspack report at level 6.

D (Incorrect): Plan usage data refers to how frequently a plan is being used, which is more associated with AWR and not typically captured in Statspack reports.

Oracle Database Performance Tuning Guide: Using Statspack

by Elenore at Dec 07, 2024, 11:14 PM

Limited Time Offer

25%

27 days ago

I think statement A is true because tablespace level definitions should take precedence.

upvoted 0 times

...