Managing Database Resources - OCP: Oracle Database 12c Administrator Certified Professional - page 500

8. Which of the following supplied functions is used to identify external tables, directories,
and BFILES?
A. DBMS_TDB.CHECK_DIRECTORIES
B. DBMS_TDB.CHECK_EXTERNAL
C. DBMS_TDB.CHECK_BFILE
D. DBMS_TDB.CHECK_EXT
9. Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful
completion?
A. The database must be in read-write mode.
B. The database must have no external files.
C. The database must open in read-only mode.
D. The database must be mounted but not opened.
10. Which of the following options describes segment shrink?
A. Reclaims space above and below the high-water mark without using additional space
B. Moves rows to a new physical location, resetting the high-water mark, but uses
additional space during the operation
C. Deallocates space above the high-water mark that is currently not in use
D. None of the above
11. For which of the following can you use segment shrink? (Choose all that apply.)
A. Heap tables
B. Tables with function-based indexes
C. Indexes
D. Partitions and subpartitions
E. None of the above
12. When shrinking a table segment, you choose to shrink all the indexes for that table
using the SHRINK SPACE command. Which clause should you use?
A. INCLUDING DEPENDENCIES
B. INCLUDING DEPENDENCIES CASCADE
C. COMPACT
D. CASCADE
E. None of the above