单项选择题
A.Use the DROP DATAFILE command.
B.Use the DROP TABLESPACE command.
C.Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
D.Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
多项选择题 Examine the statement: SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully?()
单项选择题 The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command?() exp system/manager tablespaces=SAMPLE
单项选择题 Whatshouldyoulookatfirsttocomputethenumberofundoblockswrittenpersecondtodisk?()