单项选择题

YouaremaintainingyourOracle10gdatabaseintheUNIXenvironm……

You are maintaining your Oracle10g database in the UNIX environment. An application requires one of the user sessions to exist in the operating system local time zone. You decide to set the time zone for a session using the operating system environment variable. Which command will you issue？（）

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

单项选择题WhichofthefollowingoptionsistrueaboutshuttingdownanAutomaticStorageManagement（ASM）instance？（）

A. If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
B. If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
C. If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
D. If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

单项选择题YouhaveasingleAutomaticStorageManagement（ASM）instancerunningonthenodeonwhichyourOracleDatabase10gresides.WhichASMinstanceinitializationparametersmustbeincludedintheASMinstanceinitializationparameterfile？（）

A. INSTANCE_TYPE
B. DB_UNIQUE_NAME
C. ASM_DISKSTRING
D. ASM_POWER_LIMIT