單項選擇題

You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）

A. Index cluster
B. Hash cluster
C. Sorted Hash cluster
D. Real Application Cluster

你可能感興趣的試題

單項選擇題

You issued the following command：
ALTER TABLE SCOTT.EMP SHRINK SPACE；
The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties：
DATA1 is a read/write tablespace.
DATA1 is not autoextensible to an unlimited size. DATA1 is online.
Segment space management for the DATA1 tablespace is manual.
You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error：
ORA-10635： Invalid segment or tablespace type
What could be the reason for the failure of the command？（）

A. The tablespace， DATA1， is not read-only.
B. The tablespace， DATA1， is not autoextensible.
C. The tablespace， DATA1， is not offline.
D. The segment space management for the tablespace， DATA1， is manual.

單項選擇題

You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）

A. You must enable the row movement on the SCOTT.EMP table.
B. You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
C. You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
D. You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

感谢您访问我们的网站，您可能还对以下资源感兴趣：

国产黄色视屏

要久久爱在线观看免费观看国内少妇偷人精品 99人精品福利在线观看欧美精品国产国产视频久

You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）

你可能感興趣的試題

You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）

You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）

You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）