多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）AosBlocalC-8：00Ddbtimezone LiEAustralia

题目

多选题

Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）

local

-8：00

dbtimezone Li

Australia

更多“多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）AosBlocalC-8：00Ddbtimezone LiEAustralia”相关问题

第1题

You have created a password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3 Which of the following is true about this password file？（）A、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.B、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.C、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file isD、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.

点击查看答案
第2题

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.

点击查看答案
第3题

You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session： ALTER SESSION ENABLE RESUMABLE； Which command could you issue to enable the resumable space allocation feature at the session level？（） A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；

点击查看答案
第4题

You decided to increase the value for the SHARED_SERVERS parameter by using the following command： SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？； Which three values can be specified for the SCOPE clause？（）A、ALLB、PFILEC、BOTHD、NONEE、SPFILEF、MEMORYG、INSTANCEH、DATABASE

点击查看答案
第5题

The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？（）A、 use the ALTER SYSTEM command to change the time zoneB、 use the ALTER SESSION command to change the time zoneC、 use the ALTER DATABASE command to change the time zoneD、 set the value for the operating system variable ORA_SDTZ on the client machineE、 set the value for the operating system variable ORA_SDTZ on the database server machine

点击查看答案
第6题

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 environmentD、 The database local time zone will be set for the database using the operating system environment variable.

点击查看答案
第7题

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）A、 by setting the SQL_TRACE parameter to FALSE in the parameter fileB、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionC、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionD、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

点击查看答案

多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？ （）AosBlocalC-8：00Ddbtimezone LiEAustralia

题目

更多“多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？ （）AosBlocalC-8：00Ddbtimezone LiEAustralia”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）AosBlocalC-8：00Ddbtimezone LiEAustralia

更多“多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）AosBlocalC-8：00Ddbtimezone LiEAustralia”相关问题