单项选择题

In which scenario will you create a hash cluster？（）

A. when you want the data to be returned automatically in chronological order
B. if the application uses queries joining tables only occasionally
C. if the queries against the clustered table use the equality operator （=） to retrieve the desired row
D. if the full table scan is executed often on only one of the clustered tables

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）

A. V$LOG
B. V$LOGFILE
C. DBA_LOG_GROUPS
D. V$LOG_HISTORY

单项选择题

You executed the following code：
SQL> CERATE TABLE COUNTRY
（COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，
COUNTRY_NAME VARCHAR2（20），
CURRENCY_NAME VARCHAR2（20），
CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））
ORGANIZATION INDEX；
Which types of tables will be created automatically？（）

A. journal table
B. clustered table
C. mapping table
D. partitioned table

单项选择题

You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）

A. LOGGING_OFF
B. LOGGING_RUNS
C. LOGGING_FULL
D. LOGGING_NULL