单选题Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）A Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B All DDL commands are logged in the alert

第1题：

After adding a new Ethernet card to a system and rebooting， the system administrator notices the card was not configured. How can the system administrator determine if there were errors during the configuration process for the card？（）

• A、Examine the bootlog with the command： alog -o -f /var/adm/ras/bootlog
• B、Display the device attributes and errors with the command： lsdev -C -l ent0
• C、Examine the AIX errlog for configuration method errors with the command： errpt -a -C ent0
• D、Examine the ODM for configuration errors with the command： odmget -q "method_errors" ent0

第2题：

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

第3题：

第4题：

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.

第5题：

Examine the following RMAN command：   RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG；   Which prerequisite must be met before accomplishing the backup？（）

• A、 Provide a password for the encryption
• B、 Set up an Oracle wallet for the encryption
• C、 No setup is required as it is a default encryption method
• D、 Both Oracle wallet and password must be set up for the encryption

第6题：

While applying a service update on a system using SMIT, the system administrates SMIT Command Status screen shows "Command: failed". Which of the following procedures should be performed to investigate the failure?（）

• A、Exit the SMIT session and re-apply the update.
• B、Select the SMIT option to Clean UP After an Interrupted Installation.
• C、Examine the installation summary report to determine the cause of the failure.
• D、Examine the console log to view the error messages generated by the failure.

第7题：

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

第8题：

第9题：

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

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

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