Database Reference
In-Depth Information
13. Which is true regarding the default temporary tablespace?
A. Each CDB in a PDB can have its own default temporary tablespace.
B. Each CDB and PDB must have its own default temporary tablespace.
C. A PDB may have only one temporary tablespace.
D. A PDB may use the CDB's default temporary tablespace or have its own.
E. There is only one default temporary tablespace allowed for a CDB and all of its PDBs.
14. Which of these system privileges must be granted to a user for resumable operations to
work at a session level?
A. RESUMABLE
B. RESUME
C. SYSTEM RESUMABLE
D. SESSION RESUMABLE
E. None of the above
15. Which of the following are not true regarding transportable tablespaces?
A. In order for an object to be transportable, all of the partitions that contain its
dependent objects such as indexes, materialized views, and partitioned tables
must be included in the tablespace set.
B. Tablespaces that do not use block encryption but have tables that have encrypted
columns are not transportable.
C. You can't transport the SYSTEM tablespace or objects owned by the SYS user.
D. None of the above
E. All of the above
16. Which of the following are true statements about transportable tablespaces? (Choose
all that apply.)
A. The tablespaces can be locally managed or dictionary managed.
B. In Oracle 9i or higher, the transported tablespace does not have to be the same
block size as the target database's standard block size. However, the target data-
base must have a DB_ n K_CACHE_SIZE initialization parameter set, where n is
the block size of the transportable tablespace.
C. The tablespace must be placed in read-write mode during the transport process.
D. Tablespaces with 8.0-compatible advanced queues with multiple recipients are
transportable.
E. None of the above
Search WWH ::




Custom Search