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？（）A、 LGWRB、 DBWRC、 MMOND、 RVWR
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？（）
- A、 LGWR
- B、 DBWR
- C、 MMON
- D、 RVWR
相关考题：
You are troubleshooting an issue which is causing full-sized packets entering the MPLS cloud be dropped. You have discovered that one of the switches in the MPLS core is not a Cisco switch, but otherwise the MPLS MTU size is set to 1508 bytes on the routers. Based on this information, which of these may be the reason the packets are being dropped?（）A、The switch on you MPLS core that was not produced by Cisco does not support oversized packetsB、No switches support oversized packetsC、By definition, the maximum MTU is 1500 bytesD、As MPLS VPN labeling increases the size of the packet by 8 bytes, the IP MTU should have been changed to 1508
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？（）A、 The Flashback Archive FLA1 is dropped only if it is empty.B、 The tablespace having Flashback Archive is dropped.C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.D、 The Flashback Data Archive and historical data are dropped.
In which scenario will you perform a cancel-based recovery？（）A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database
In which scenario do you use the Flashback Database feature？（）A、 when a table is dropped and you restore it from the Recycle BinB、 when a user’s schema is dropped and you recover the user’s schemaC、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
In which scenario will you use the Flashback Transaction Query feature？（）A、 when you want to restore an important table that is dropped from the Recycle BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
In which scenario will you perform a user-managed incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period
Which two statements are correct regarding the Oracle Flashback Drop feature？ （）A、 Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.B、 You can flash back a dropped table provided row movement has been enabled on the table.C、 If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.D、 When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.E、 When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.F、 If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）A、 To recover a dropped table.B、 To recover a dropped schema.C、 To recover data from a truncated table.D、 To view changes made by all the transactions during a given period of time.E、 To view changes made by a single transaction during a given period of time.
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（）A、The command produces an error.B、The profile is dropped and current user sessions use the DEFAULT profile immediately.C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
In which scenario will you use the Flashback Version Query feature？（）A、 when you want to restore a table that has been dropped from the Recycle BinB、 when you want to identify the transaction ID of the transaction that deleted some important records from a tableC、 when you want to recover the schema of a dropped userD、when you want to restore a dropped tablespace
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
In which scenario will you perform an incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、 when all the control files are deletedC、 when a member of a multiplexed redo log group is droppedD、 when you are required to recover a table to its previous state
单选题In which scenario do you use the Flashback Database feature？（）A when a table is dropped and you restore it from the Recycle BinB when a user’s schema is dropped and you recover the user’s schemaC when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
单选题In which scenario will you use the Flashback Version Query feature？（）A when you want to restore a table that has been dropped from the Recycle BinB when you want to identify the transaction ID of the transaction that deleted some important records from a tableC when you want to recover the schema of a dropped userDwhen you want to restore a dropped tablespace
单选题In which scenario will you perform a cancel-based recovery？（）A when a tablespace is dropped and you have only RMAN-based backup of the databaseB when a table is dropped and stored in the Recycle BinC when you are required to recover an existing table to its previous stateD when a tablespace is dropped and you have only a user-managed full backup of the database
单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）A Flashback DropB Flashback TableC Flashback DatabaseD Flashback Version QueryE Flashback Transaction Query
单选题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？（） RMANRUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }A NOMOUNTB MOUNTC OPEND RESTRICTED
多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by all the transactions during a given period of time.ETo view changes made by a single transaction during a given period of time.
单选题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?（）APerform Export before TSPITR and Import after TSPITRBMove objects to another schema that has the same tablespace assignedCPerform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)DPerform Incomplete Recovery before TSPITR with the System Change Number (SCN)
多选题Which two statements are correct regarding the Oracle Flashback Drop feature？ （）ARecycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.BYou can flash back a dropped table provided row movement has been enabled on the table.CIf you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.DWhen you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.EWhen a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.FIf you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.
单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）AFlashback DropBFlashback TableCFlashback DatabaseDFlashback Version QueryEFlashback Transaction Query
单选题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？（）A The Flashback Archive FLA1 is dropped only if it is empty.B The tablespace having Flashback Archive is dropped.C The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.D The Flashback Data Archive and historical data are dropped.
单选题In which scenario will you perform a user-managed incomplete recovery？（）A when a table is dropped and stored in the Recycle BinBwhen a table is dropped and purged from the Recycle BinC when you are required to recover an existing table to its previous stateD when you are required to view all the versions of a row of an existing table between a specific time period
单选题You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）A by using the Flashback Table featureB by using the Flashback Database featureC by performing incomplete recovery using RMAN utilityD by performing incomplete recovery using user-managed recovery
单选题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？（）A Perform Export before TSPITR and Import after TSPITRB Move objects to another schema that has the same tablespace assignedC Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）D Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）
单选题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（）AThe command produces an error.BThe profile is dropped and current user sessions use the DEFAULT profile immediately.CThe profile is dropped and only the subsequent user sessions use the DEFAULT profile.DThe profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
单选题In which scenario will you use the Flashback Transaction Query feature？（）A when you want to restore an important table that is dropped from the Recycle BinB when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionCwhen you want to restore a dropped user’s schemaD when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period