Database Reference
In-Depth Information
Review Questions
1.
To enable resumable space allocation for the instance, which of the following initializa-
tion parameters should you set to a nonzero value?
A.
RESUMABLE_SPACE_TIME
B.
RESUMABLE_SPACE
C.
RESUMABLE_TIME
D.
RESUMABLE_TIMEOUT
E.
TIME_RESUMABLE
2.
Which of the following describes how a distributed resumable transaction behaves?
A.
The resumable setting on the initiating session determines the resumable condi-
tions for the entire distributed transaction.
B.
The resumable setting for the initiating instance determines the resumable condi-
tions for the entire distributed transaction.
C.
The resumable setting on the initiating session controls only that part of the trans-
action that occurs within the local instance; remote resumable settings determine
the behavior of the distributed parts of the transaction.
D.
None of the above
3.
Which of these components, in order, correctly identify the unique value of the
NAME
column in the
DBA_RESUMABLE
view?
A.
Username, instance number, session ID
B.
Instance number, username, session ID
C.
Instance number, session ID, username
D.
Username, session ID, instance number
E.
None of the above
4.
Which of the following are included in a transportable tablespace set? (Choose all
that apply.)
A.
The data files 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
Search WWH ::
Custom Search