ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.  Which statement is true in this situation（）

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（）

单选题查看答案

ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）

单选题查看答案

ou are using the flash recovery area （fast recovery area in 11g Release 2） to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is （jetting filled up very fast and it is running out of space.  Your database flash recovery area is low on specie and you have no more room on disk. Proactively， which two options could you use to make more space available in the flash recovery（）

多选题查看答案

ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package.  Which statement is true regarding the ACL created？（）

单选题查看答案

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

多选题查看答案

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）

多选题查看答案

You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）

单选题查看答案

You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

多选题查看答案

While setting up the database for your production environment， you want to create a user with following requirements.  1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation.  2.The user should be able to use 10MB of space in the tablespace TBS1.  3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）

多选题查看答案