Database Reference
In-Depth Information
17. Shrinking segments is a good practice for which of the following reasons?
A. Full table scans of fragmented data blocks require more physical reads.
B. Each defragmented block takes up less space on disk.
C. Each defragmented block takes up less space in cache.
D. Shrinking segments should not be considered because of the requirement to drop
and recreate any indexes to prevent corruption.
E. None of the above
18. Which of the following options allows you to migrate a database from one platform
to another?
A. Transportable Database, for any source or target platform
B. Transportable Tablespace, for any source or target platform
C. Transportable Database, but only if the source and target have the same
endian format
D. Transportable Tablespace, and only for big endian format source and target
E. None of the above
19. Use the DBMS_TDB.CHECK_EXTERNAL supplied function to identify which of the following?
A. External tables
B. Directories
C. BFILES
D. All of the above
E. None of the above
20. In the multitenant environment, is it true that you can create a permanent tablespace
that can be used by multiple containers?
A. True, common users can share objects in different PDBs that share the same
permanent tablespace.
B. False, a permanent tablespace can be associated with only one container.
C. True, common and local users can share the same permanent tablespaces across
multiple PDBs
D. True, common users create common tablespaces in the root that are shared to
all PDBs.
E. None of the above
Search WWH ::




Custom Search