單項選擇題

You want to drop the TBS1 tablespace from your database.
You also want to delete the corresponding data files automatically， and not have to do it manually.
What should you do？（）

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？（）

A.Oracle Managed Files are used for this instance.
B.The USER_DATA tablespace is managed using FET$/UET$ tables.
C.The COMPATIBLE initialization parameter must be 9.0.0 or higher.
D.Space within segments in the USER_DATA tablespace is managed with freelists.

單項選擇題

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

A.Only the EMPLOYEES table.
B.Only the EMPLOYEES table and its corresponding primary key index.
C.The EMPLOYEES table and partition P1.
D.The EMPLOYEES table， IPK_EMP index， and the SALES table.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）

你可能感興趣的試題

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？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You want to drop the TBS1 tablespace from your database.
You also want to delete the corresponding data files automatically， and not have to do it manually.
What should you do？（）

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？（）