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

5. A, C. 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.
6. B. Execute the DBMS_TTS.TRANSPORT_SET_CHECK procedure using the proposed list of
tablespaces for the transportable set. Optionally, the last parameter should be TRUE to
verify referential integrity constraints.
7. B, C, D. Option A is incorrect because the correct view name is V$DB_TRANSPORTABLE_
PLATFORM . You'll need to verify that there are no restrictions or limitations such as stor-
age or memory, verify that the version levels are the same, and determine where you will
perform the conversion.
8. B. The DBMS_TDB.CHECK_EXTERNAL function returns the list of external files that will
need to be copied to the destination system. The other options are not valid.
9. C. The DBMS_TDB.CHECK_DB function must execute with the database open and in
read-only mode.
10. A. The segment shrink feature reclaims space above and below the high-water mark
without using additional space to perform an operation.
11. A, C, D. The segment shrink feature can be used on tables, indexes, and partitions but
not on tables with function-based indexes.
12. D. The segment shrink SHRINK SPACE command specifying the table name, and then
including the CASCADE clause, will reclaim space from the table segment and all dependent
index segments, as reported by the DBMS_SPACE.OBJECT_DEPENDENT_SEGMENT function.
13. D. A PDB may have its own default temporary tablespace or use the root CDB default
temporary tablespace.
14. A. None of the other answers are correct syntax, and therefore they are incorrect.
15. D. Each of these is a true statement about transportable tablespaces; therefore D is the
correct answer.
16. A, B. C is incorrect because the tablespace must be in read-only mode. D is incorrect
because 8.0-Compatible AQ with multiple recipients are not transportable.
17. A. A defragmented block takes up the same amount of space on disk or in cache as a
fragmented block. D is incorrect because the segment shrink operation can be performed
on indexes as well as tables.
18. C. Use the Transportable Database feature to migrate an entire database from one plat-
form to another, as long as the endian format is the same for both source and target.
19. D. Use the DBMS_TDB.CHECK_EXTERNAL supplied function to identify external tables, direc-
tories, and BFILES that you'll need to move as part of a transportable database migration.
20. B. A permanent tablespace may be associated with only one container.