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

第1题：

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

第2题：

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.

第3题：

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

第4题：

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.

第5题：

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

第6题：

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

第7题：

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

第8题：

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

第9题：

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.

第10题：

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；