You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session：   ALTER SESSION ENABLE RESUMABLE；   Which command could you issue to enable the resumable space allocation feature at the session level？（）  

You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this？（）

单选题查看答案

You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）

单选题查看答案

You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA table space is stored. The database is currently open and you need to recover the data file. You will restore the data file to DISK2.  What is the correct sequence RMAN commands to restore and recover the data file？（）

单选题查看答案

View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（） 

单选题查看答案

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

单选题查看答案

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

多选题查看答案

You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）

单选题查看答案

You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement：   FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2；   What will be the result of executing this statement？（）

单选题查看答案

During recovery， you need to know if log sequence 11 is in the online redo logs， and if so， you need to know the names of the online redo logs so you can apply them during recovery.  Which view or views would you use to determine this information？（） 

多选题查看答案