- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
91.
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
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| For the instance, set the initialization parameter RESUMABLE_TIMEOUT to a nonzero value, representing the number of seconds for which an operation will suspend until an action is taken to repair the condition or the operation aborts due to the condition. |
92.
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
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| In a distributed transaction, the remote RESUMABLE_TIMEOUT initialization param- eter applies to the remote part of the transaction, and the remote-session resumable setting applies. Also, local resumable settings do not apply to the remote part of the distributed transactions. |
93.
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
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| For the DBA_RESUMABLE view, the NAME column is populated with the username, session ID, and instance number, in that order. |
94.
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
- Answer & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
| The transportable tablespace set is the self-contained group of tablespaces that encapsulate the objects that you wish to transport along with the exported metadata for the tablespaces. |
95.
The following query will provide what information about transportable tablespaces for
the current database? (Choose all that apply.)
select d.platform_name "Source", t.platform_name
"Compatible Targets", endian_format
from v$transportable_platform t, v$database d
where t.endian_format = (select endian_format
from v$transportable_platform t,
v$database d where d.platform_name = t.platform_name);
select d.platform_name "Source", t.platform_name
"Compatible Targets", endian_format
from v$transportable_platform t, v$database d
where t.endian_format = (select endian_format
from v$transportable_platform t,
v$database d where d.platform_name = t.platform_name);
- A.The list of target platforms having the same endian format as the source database
- B.The list of target platforms requiring endian conversion
- C.The list of target platforms that will not require endian conversion
- D.The list of all target platforms that can receive transportable tablespaces from the source database
- E.None of the above
- Answer & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
| The SQL query returns the list of target platforms that have the same endian for- mat and do not require RMAN conversion between source and destination databases. |
|
|
||||||||||||||||||||||||||||
