单选题 You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
The backup status will be marked expired in RMAN recovery catalog.
The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.
多选题 Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）
Use only the first address.
Try one address，selected at random.
Try each address，in order，until one succeeds.
Try each address，randomly，until one succeeds.
You can perform open database backups.
You can perform closed database backups.
You cannot perform schema-level logical backups.
You can perform the backup of only the SYSTEM tablespace when the database is open.
单选题 You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）
The Oracle kernel will be placed in this location.
The Oracle software will be placed in this location.
The server parameter file （SPFILE） will be placed in this location.
The database files will be placed in this location， if not specified explicitly.
The location will be considered for the base of Oracle Managed Files （OMF）.
The location will be considered for the base of Optimal Flexible Architecture （OFA）.
多选题 You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective？（）
Quota 10MB on SupportCenter TBS1
Password never expire
Defaulttablespace SupportCenter TBS1
Quota unlimited on SupportCenter TBS1
单选题 Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database？（）
The extents in undo tablespace retain data until the next full database backup.
The extents containing committed data in the undo tablespace are never overwritten.
The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
单选题 You work as a database administrator for Certkiller .com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）
Enable instance failover
Configure shared server
Enable database failover
Enable connect-time failover
Enable Transparent Application Failover （TAF）
单选题 You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）
by using triggers
by using external tables
by using anonymous PL/SQL blocks
by auditing all DML operations on the table
单选题 You work as a database administrator for Certkiller .com. 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？（）
It would attempt to start the default listener
It would start the most recently created listener.
It would display an error with a message asking for the listener name to be specified.
It would show you a list of listeners and prompts for the listener name that you want to start.
多选题 You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
Execute the ALTER DATABASE ARCHIVELOG statement
Select ARCHIVELOG option in the database control and restart the database to apply the changes.
Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.