单项选择题

Which of the following describes how a distributed resumable transaction behaves？（）

A. The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.
B. The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.
C. The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance； remote resumable settings determine the behavior of the distributed parts of the transaction.
D. None of the above.

点击查看答案

上一题目录下一题

相关考题

单项选择题

To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）

A. RESUMABLE_SPACE_TIME
B. RESUMABLE_SPACE
C. RESUMABLE_TIME
D. RESUMABLE_TIMEOUT
E. TIME_RESUMABLE

单项选择题

When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）

A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

多项选择题

Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（）

A. SORT_AREA_SIZE
B. HASH_AREA_SIZE
C. BITMAP_MERGE_AREA_SIZE
D. CREATE_BITMAP_AREA_SIZE
E. PGA_AGGREGATE_TARGET