單項(xiàng)選擇題

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

A. You must enable the block change tracking feature.
B. You must have enable the flashback feature.
C. You must use the OMF in your database.
D. You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

你可能感興趣的試題

單項(xiàng)選擇題

You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）

A. the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
B. the column of the V$INSTANCE_RECOVERY view
C. the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
D. the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

單項(xiàng)選擇題

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

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

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

你可能感興趣的試題

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

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

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

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