多项选择题
Which of the following are included in a transportable tablespace set?()
A. The datafiles that make up a self-contained group of tablespaces required for copy
B. The system tablespace
C. An export of the tablespace metadata
D. The spfile
E. All of the above
相关考题
-
单项选择题
Whichofthefollowingdescribeshowadistributedresumabletransactionbehaves?()
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. -
单项选择题
Toenableresumablespaceallocationfortheinstance,whichofthefollowinginitializationparametersshouldyousettoanonzerovalue?()
A. RESUMABLE_SPACE_TIME
B. RESUMABLE_SPACE
C. RESUMABLE_TIME
D. RESUMABLE_TIMEOUT
E. TIME_RESUMABLE -
单项选择题
WhentuningAutomaticPGAMemoryManagement,whichofthefollowingviewswillprovidetheinformationspecified?()
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
