多选题You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?（）AIt will permit the use of uppercase passwords for database users who have been granted t

第1题：

第2题：

ou executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5 ignorecase=N  Which statement describes the purpose of the above password file（）

• A、It records usernames and passwords of users when granted the DBA role.
• B、It contains usernames and passwords of users for whom auditing is enabled.
• C、It is used by Oracle to authenticate users for remote database administration.
• D、It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.

第3题：

第4题：

You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

• A、 rman TARGET / NOCATALOG
• B、 rman TARGET sys/password
• C、 rman TARGET sys/password AS SYSDBA
• D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

第5题：

You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）

• A、 by using the STATUS command of the Listener control utility
• B、 by using the STATUS L1 command of the Listener control utility
• C、 by using the SHOW RULES command of the Listener control utility
• D、 by using the SET PASSWORD command of the Listener control utility
• E、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

第6题：

You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command：        ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   You erroneously deleted the password file while the database was running. You re-create the password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4   However， when you try to connect as the SYS user， you receive the following error：        ORA-01031： insufficient privileges   What should you do to resolve this error？（）

• A、 Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.
• B、 Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.
• C、 Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.
• D、 Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.

第7题：

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

第8题：

第9题：

You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

• A、Datafiles
• B、 Current control file
• C、 Server parameter file （spfile）
• D、 Password file

第10题：

You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）

• A、Start the instance and open the database, instance recovery automatically recovers control files 
• B、Create a file based on the contents of the trace file and save it to the control file locations and start the database 
• C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 
• D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 
• E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.