单项选择题
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
