Evaluate the following command：   SQL>ALTER SYSTEM SET db_se

第1题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

• A、Immediately following statement execution 
• B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
• C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
• D、After the ALTER TABLE MODIFY command is issued

第2题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

• A、The table is moved to the SYSAUX tablespace.
• B、The table is moved to the SYSTEM tablespace.
• C、The table is removed from the database permanently.
• D、The table is renamed and remains in the TBSFD tablespace.

第3题：

A system has a critical need for network services on a small network with a limited number of hosts. System overhead is not a concern. Which of the following should the system administrator do to help ensure connectivity in the event of a gateway failure？（）

• A、Use the ifconfig command to enable dead gate detection
• B、Use the no command to set active dead gateway detection
• C、Use the route command to set active dead gateway detection
• D、Add the line active_dgd=1 to the /etc/gated.conf command and refresh the gated daemon

第4题：

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

第5题：

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

第6题：

To allocate another role to a user, which command is most appropriate?（）

• A、ALTER USER 
• B、ALTER DATABASE 
• C、ALTER SYSTEM 
• D、GRANT

第7题：

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；

第8题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

• A、Image of the control file
• B、Location of the control file
• C、Contents of the control file in text format
• D、SQL command to re-create the database
• E、SQL command to re-create the control file
• F、Contents of the control file in binary format

第9题：

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

第10题：