You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）

You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）

单选题查看答案

You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）

多选题查看答案

You are managing an ASM instance. You previously issued the following statements：   ALTER DISKGROUP dg1 DROP DISK disk2；  ALTER DISKGROUP dg1 DROP DISK disk3；  ALTER DISKGROUP dg1 DROP DISK disk5；   You want to cancel the disk drops that are pending for the DG1 disk group.  Which statement should you issue？（）  

单选题查看答案

Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object？（）

单选题查看答案

You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：   DROP FLASHBACK ARCHIVE fla1；   What is the effect of this command？（）

单选题查看答案

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

单选题查看答案

You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }

单选题查看答案

You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）

单选题查看答案

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

单选题查看答案

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

单选题查看答案