7.Which of the following is one reason for using the package, DBMS_TTS?
A. To verify that a tablespace is self-contained.
B. To drop indexes outside a transportable tablespace.
C. To create the metadata for a transportable tablespace.
D. To attach transportable tablespaces datafiles to the database
我选A
8.Consider the following command to create the user 憄eter?
CREATE USER peter
IDENTIFIED by pan
TEMPORARY TABLESPACE temp
PASSWORD EXPIRE;
Since no default tablespace was specified, what will happen if this command is
executed?
A. The user will not own a home directory.
B. The user peter will be created using the TEMP tablespace as the default.
C. The user peter will be created using the SYSTEM tablespace as the default.
D. The code will produce an error message, the user peter will not be created.
我选了c
9.Which class of segments is most likely to cause fragmentation in permanent
tablespace?
A. Index segments.
B. Rollback segments.
C. User data segments.
D. Temporary segments.
E. Data dictionary segments
我选了d
