单项选择题

A. B-tree IndexB. Bitmap IndexC. Function-based IndexD.……

Click the Exhibit（s） button to view the EMPLOYEES table.

The EMPLOYEE table contains thousands of rows. The EMP_CODE column is the primary key column. At the end of every month， you are required to perform search queries based on the BASIC_SAL+COMM column values. Which type of index will you create？（）

A. B-tree Index
B. Bitmap Index
C. Function-based Index
D. Partitioned Index

<上一题目录下一题>

热门试题

单项选择题You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（）

A. The operating system local time zone will be set for a user session using the operating system environment variable.
B. The database local time zone will be set for a user session using the operating system environment variable.
C. The operating system local time zone will be set for the database using the operating system environment
D. The database local time zone will be set for the database using the operating system environment variable.

单项选择题YouaremaintainingyourOracle10gdatabaseintheUNIXenvironment.Anapplicationrequiresoneoftheusersessionstoexistintheoperatingsystemlocaltimezone.Youdecidetosetthetimezoneforasessionusingtheoperatingsystemenvironmentvariable.Whichcommandwillyouissue？（）

A. setenv ORA_SDTZ ’DB_TZ’
B. setenv ORA_SDTZ ’+10：00’
C. setenv ORA_SDTZ ’OS-TZ’
D. setenv ORA_SDTZ ’Europe/London’

单项选择题YouarespecifyingFrenchcase-insensitivesortsbyusingtheNSL_SORTparameterfortheusersessionoftheuser，Scott.WhichvaluewillyousetfortheNLS_SORTparameter？（）

A. FRENCH_AI
B. FRENCH_CI
C. AI_FRENCH
D. CI_FRENCH

单项选择题You created the ORDERS table in your database by using the following code： SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America New_York’）； SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America New_York’）； SQL> COMMIT； Next， you issued the following statement to change the time zone for the database： SQL> ALTER DATABASE SET TIME_ZONE=’Europe London’； What will be the result of executing the above statement？（）

A. The statement will fail.
B. The statement will be executed successfully， and the new time zone will be set for the database.
C. The statement will be executed successfully， but the new time zone will be set for the current session.
D.The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

单项选择题Whichstatementmustyouissuetoanalready-runningAutomaticStorageManagement（ASM）instancetopreventdatabaseinstancesfromconnectingtotheASMinstance？（）

A. ALTER SYSTEM KILL SESSION
B. ALTER SYSTEM DISCONNECT SESSION
C. ALTER SYSTEM QUIESCE RESTRICTED
D. ALTER SYSTEM ENABLE RESTRICTED SESSION