单项选择题
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?()
单项选择题 YouarespecifyingFrenchcase-insensitivesortsbyusingtheNSL_SORTparameterfortheusersessionoftheuser,Scott.WhichvaluewillyousetfortheNLS_SORTparameter?()
单项选择题 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?()