多选题Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）A’os’BlocalC-8：00’Ddbtimezone LiE’Australia’
多选题
Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）
A
’os’
B
local
C
-8：00’
D
dbtimezone Li
E
’Australia’
参考解析
解析：
暂无解析
相关考题：
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB、issuing the ALTER SESSION ENABLE RESUMABLE; statementC、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=nonzero value; statement
You issued the following statement： SQL ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1； Which parameter is NOT overridden by using the above statement？（） A、 the value of the NLS_LANGUAGE variableB、 the value of the NLS_TERRITORY variableC、 the value of the NLS_CURRENCY variableD、the character encoding scheme used by the client application
You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（） A、 issuing the ALTER SYSTEM ENABLE RESUMABLE；statementB、 issuing the ALTER SESSION ENABLE RESUMABLE；statementC、 modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、 issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement
Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the result of issuing the above statement？（）A、 The statement will be executed successfully， and a new time zone will be set for the database.B、 The statement will be executed successfully， but a new time zone will not be set for the database.C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）A、execute the command， ALTER SESSION KILL ..， to kill the blocking sessionB、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionD、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionE、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？ （）A、 osB、 localC、 -8：00D、 dbtimezone LiE、 Australia
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.
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.
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；
Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）A、 ’os’B、 localC、 -8：00’D、 dbtimezone LiE、 ’Australia’
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）A、You can conned as a common user by using the connect statement.B、You can connect as a local user by using the connect statement.C、You can connect by using easy connect.D、You can connect by using OS authentication.E、You can connect by using a Net Service name.F、You can connect as a local user by using the SET CONTAINER statement.
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
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
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？（）A’os’BlocalC-8：00’Ddbtimezone LiE’Australia’
多选题You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（）Aissuing the ALTER SYSTEM ENABLE RESUMABLE；statementBissuing the ALTER SESSION ENABLE RESUMABLE；statementCmodifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueDissuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement
单选题You issued the following statement： SQL ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1； Which parameter is NOT overridden by using the above statement？（）A the value of the NLS_LANGUAGE variableB the value of the NLS_TERRITORY variableC the value of the NLS_CURRENCY variableDthe character encoding scheme used by the client application
多选题An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）AYou can conned as a common user by using the connect statement.BYou can connect as a local user by using the connect statement.CYou can connect by using easy connect.DYou can connect by using OS authentication.EYou can connect by using a Net Service name.FYou can connect as a local user by using the SET CONTAINER statement.
多选题An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）AYou can conned as a common user by using the connect statement.BYou can connect as a local user by using the connect statement.CYou can connect by using easy connect.DYou can connect by using OS authentication.EYou can connect by using a Net Service name.FYou can connect as a local user by using the SET CONTAINER statement.
多选题For which three events can web application event listeners be registered？ （）Awhen a session is createdBafter a servlet is destroyedCwhen a session has timed outDwhen a cookie has been createdEwhen a servlet has forwarded a requestFwhen a session attribute value is changed
多选题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？ （）Ause the ALTER SYSTEM command to change the time zoneBuse the ALTER SESSION command to change the time zoneCuse the ALTER DATABASE command to change the time zoneDset the value for the operating system variable ORA_SDTZ on the client machineEset the value for the operating system variable ORA_SDTZ on the database server machine
多选题You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）Aissuing the ALTER SYSTEM ENABLE RESUMABLE; statementBissuing the ALTER SESSION ENABLE RESUMABLE; statementCmodifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueDissuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=nonzero value; statement
多选题You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? （）(Choose two.)Aissuing the ALTER SYSTEM ENABLE RESUMABLE; statementBissuing the ALTER SESSION ENABLE RESUMABLE; statementCmodifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueDissuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement
多选题Which three of these statements about PPPoE are true？（）APPPoE can provide a host with access to a destination over Ethernet. You can have only one PPPoE session per PVCBYou must install PPPoE client software on all hosts that connect to the Ethernet segment. This means that the access provider must maintain a CPECYou cannot use PPPoE with Cisco Service Selection GatewayDPPPoE implementation is susceptible to broadcast storms and possible denial-of-service attacksEPer-session accounting is possible， which allows the service provider to charge the subscriber based on session time for various services offered. The service provider can also require a minimum access charge
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
单选题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；
多选题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？（）AALLBPFILECBOTHDNONEESPFILEFMEMORYGINSTANCEHDATABASE