Answers to Review Questions - OCP: Oracle Database 12c Administrator Certified Professional - page 678

18. B, C. Option A is incorrect because the data divergence between the capture and replay
databases should be minimized. Option D is incorrect because the database should be
started in restricted mode, and then the workload capture process will switch the data-
base to unrestricted. Option E is incorrect because you can define either inclusion or
exclusion filters for a workload capture but not both.
19. E. Option A is incorrect because workload capture is for the database, not for individ-
ual instances. B is incorrect because the correct procedure is to shut down all instances
before you begin workload capture. Option C is incorrect; after the shutdown of all
instances, start one instance to begin workload capture, and then start the remaining
instances after capture begins. Workload capture and replay are supported in RAC, so
D is incorrect.
20. D. Option A is incorrect; DML and SQL results drive data divergence. Option B is incor-
rect because error divergence, not performance divergence, happens when errors that
occur in the capture system don't occur in the replay system. Top SQL statements should
behave the same in the capture and replay systems, unless there is a data-divergence
issue, so C is incorrect. E is incorrect because the time of day should have no impact on
differences between the capture and replay systems. It is possible that other workloads
running on the capture and replay systems that have a time-of-day trend might impact
performance, but that is an extraneous variable, not a cause.
Chapter 10: Managing
Database Resources
1. D. 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.
2. C. 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.
3. D. For the DBA_RESUMABLE view, the NAME column is populated with the username,
session ID, and instance number, in that order.
4. A, C. 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.