多选题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.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?() A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?() A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）A. It retrieves the latest version of the table from the recycle binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)A、All the related indexes and views are automatically droppedB、The flashback drop feature can recover only the table structureC、Only the related indexes are dropped whereas views are invalidatedD、The flashback drop feature can recover both the table structure and its data
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
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）A、point-in-time recoveryB、execute the ROLLBACK command with transaction numberC、flashback the database to before the transaction was committedD、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
In which case would you use the Flashback Database feature to perform a recovery？（）A、to recover a dropped tablespaceB、to recover data from a truncated tableC、to recover a data file that has been shrunkD、to recover a database to the state that existed before the RESETLOGS operation
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； A、to undo the changes made to the EMP table since the specified timeB、to restore the EMP table that was wrongly dropped from the databaseC、to view the transactions that have modified the EMP table since the specified timeD、to view the changes made to the EMP table for one or more rows since the specified timeE、to recover the EMP table to a point in time in the past by restoring the most recent backup
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.
The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）A、 All the related indexes and views are automatically droppedB、 The flashback drop feature can recover only the table structureC、 Only the related indexes are dropped whereas views are invalidatedD、 The flashback drop feature can recover both the table structure and its data
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
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
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table
多选题The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)AAll the related indexes and views are automatically droppedBThe flashback drop feature can recover only the table structureCOnly the related indexes are dropped whereas views are invalidatedDThe flashback drop feature can recover both the table structure and its data
单选题At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A DBA_PENDING_TRANSACTIONSB DBA_AUDIT_STATEMENTC V$FLASHBACK_DATABASE_STATSD FLASHBACK_TRANSACTION_QUERY
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）;Ato undo the changes made to the EMP table since the specified timeBto restore the EMP table that was wrongly dropped from the databaseCto view the transactions that have modified the EMP table since the specified timeDto view the changes made to the EMP table for one or more rows since the specified timeEto recover the EMP table to a point in time in the past by restoring the most recent backup
单选题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
多选题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？（）AUNTIL SEQUENCEBUNTIL SCNCUNTIL CHANGEDUNTIL CANCEL
单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）Apoint-in-time recoveryBexecute the ROLLBACK command with transaction numberCflashback the database to before the transaction was committedDdetermine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
单选题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
单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions？（）A point-in-time recoveryB execute the ROLLBACK command with transaction numberC flashback the database to before the transaction was committedD determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
单选题In which case would you use the Flashback Database feature to perform a recovery？（）Ato recover a dropped tablespaceBto recover data from a truncated tableCto recover a data file that has been shrunkDto recover a database to the state that existed before the RESETLOGS operation
单选题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
多选题The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）AAll the related indexes and views are automatically droppedBThe flashback drop feature can recover only the table structureCOnly the related indexes are dropped whereas views are invalidatedDThe flashback drop feature can recover both the table structure and its data
多选题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.