多选题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’

相似考题

1.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

2.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

3. 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.

4. 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

更多“多选题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’”相关问题

  • 第1题：

    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 session
    • B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
    • C、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
    • D、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
    • E、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

    正确答案:C

  • 第2题：

    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 is
    • D、 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.

    正确答案:D

  • 第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；

    正确答案:C

  • 第4题：

    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.

    正确答案:C,D,E,F

  • 第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 zone
    • B、 use the ALTER SESSION command to change the time zone
    • C、 use the ALTER DATABASE command to change the time zone
    • D、 set the value for the operating system variable ORA_SDTZ on the client machine
    • E、 set the value for the operating system variable ORA_SDTZ on the database server machine

    正确答案:B,D

  • 第6题：

    多选题
    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


    正确答案： B,C,D
    解析： 暂无解析

  • 第7题：

    多选题
    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；statement

    B

    issuing the ALTER SESSION ENABLE RESUMABLE；statement

    C

    modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

    D

    issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement


    正确答案： C,D
    解析： 暂无解析

  • 第8题：

    多选题
    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.


    正确答案： A,F
    解析： 暂无解析

  • 第9题：

    多选题
    For which three events can web application event listeners be registered？ （）
    A

    when a session is created

    B

    after a servlet is destroyed

    C

    when a session has timed out

    D

    when a cookie has been created

    E

    when a servlet has forwarded a request

    F

    when a session attribute value is changed


    正确答案： C,D
    解析： 暂无解析

  • 第10题：

    多选题
    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; statement

    B

    issuing the ALTER SESSION ENABLE RESUMABLE; statement

    C

    modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

    D

    issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement


    正确答案： D,B
    解析： 暂无解析

  • 第11题：

    多选题
    Which three of these statements about PPPoE are true？（）
    A

    PPPoE can provide a host with access to a destination over Ethernet. You can have only one  PPPoE session per PVC

    B

    You must install PPPoE client software on all hosts that connect to the Ethernet segment. This means that the access provider must maintain a CPE

    C

    You cannot use PPPoE with Cisco Service Selection Gateway

    D

    PPPoE implementation is susceptible to broadcast storms and possible denial-of-service attacks

    E

    Per-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


    正确答案： A,D
    解析： 暂无解析

  • 第12题：

    单选题
    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；


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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

    正确答案:B,C,D

  • 第14题：

    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.

    正确答案:A

  • 第15题：

    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’

    正确答案:B,C,D

  • 第16题：

    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、ALL
    • B、PFILE
    • C、BOTH
    • D、NONE
    • E、SPFILE
    • F、MEMORY
    • G、INSTANCE
    • H、DATABASE

    正确答案:C,E,F

  • 第17题：

    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 file
    • B、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
    • C、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
    • D、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

    正确答案:B

  • 第18题：

    多选题
    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’


    正确答案： B,C,D
    解析： 暂无解析

  • 第19题：

    单选题
    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 variable

    B

     the value of the NLS_TERRITORY variable

    C

     the value of the NLS_CURRENCY variable

    D

    the character encoding scheme used by the client application


    正确答案： B
    解析： 暂无解析

  • 第20题：

    多选题
    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.


    正确答案： C,D
    解析： 暂无解析

  • 第21题：

    多选题
    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 zone

    B

    use the ALTER SESSION command to change the time zone

    C

    use the ALTER DATABASE command to change the time zone

    D

    set the value for the operating system variable ORA_SDTZ on the client machine

    E

    set the value for the operating system variable ORA_SDTZ on the database server machine


    正确答案： E,D
    解析： 暂无解析

  • 第22题：

    多选题
    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.)
    A

    issuing the ALTER SYSTEM ENABLE RESUMABLE; statement

    B

    issuing the ALTER SESSION ENABLE RESUMABLE; statement

    C

    modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

    D

    issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement


    正确答案： D,B
    解析： 暂无解析

  • 第23题：

    多选题
    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（）
    A

    LOCK TABLE emp IN SHARE MODE；

    B

    LOCK TABLE emp IN EXCLUSIVE MODE；

    C

    UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？

    D

    INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；

    E

    SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno


    正确答案： A,D
    解析： 暂无解析

  • 第24题：

    多选题
    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

    ALL

    B

    PFILE

    C

    BOTH

    D

    NONE

    E

    SPFILE

    F

    MEMORY

    G

    INSTANCE

    H

    DATABASE


    正确答案： C,B
    解析： 暂无解析

相关内容