You issued the following command to analyze the SCOTT.EMP ta

第1题：

The following configuration command was issued on router TK1:ip route 172.16.3.0 255.255.255.0 192.168.2.1.Which of the following statements are true regarding this command?（）

• A、The command is used to establish a static route.
• B、The default administrative distance is used.
• C、The command is used to configure the default route.
• D、The subnet mask for the source address is 255.255.255.0
• E、The command is used to establish a stub network

第2题：

You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）

• A、It would attempt to start the default listener
• B、It would start the most recently created listener.
• C、It would display an error with a message asking for the listener name to be specified.
• D、It would show you a list of listeners and prompts for the listener name that you want to start.

第3题：

第4题：

You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

• A、All data along with the table structure is deleted 
• B、The pending transaction in the session is committed 
• C、All indexes on the table will remain but they are invalidated 
• D、All views and synonyms will remain but they are invalidated 
• E、All data in the table are deleted but the table structure will remain

第5题：

Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）  

• A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
• B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
• C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
• D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

第6题：

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?（）

• A、The backup is deleted.
• B、The backup is marked unavailable.
• C、The backup overrides the backup retention policy.
• D、the backup becomes eligible for deletion according to the existing retention policy

第7题：

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

• A、 You must enable the block change tracking feature.
• B、 You must have enable the flashback feature.
• C、 You must use the OMF in your database.
• D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

第8题：

第9题：

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

第10题：

You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）

• A、 by using the DBMS_REPAIR package
• B、 by using the DB_BLOCK_CHECKING parameter
• C、 by using the DBVERIFY utility
• D、 will not be completely resolved until the hardware fault is corrected