（单选题）
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（）
AThe online redo log files and archived redo log files are required to accomplish the recovery.
BThe uncommitted transaction will be committed at the next startup of the database instance.
CThe uncommitted transaction is rolled back automatically at the next opening of the database.
DThe DBA has to perform the recovery on the database to recover the uncommitted transaction.
正确答案
答案解析
略
相似试题
（单选题）
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？（）
