You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose?()
A、 Use ROLLBACK command with SCN 663571.
B、 Perform Flashback Transaction Query with SCN 663571.
C、 Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
D、 Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
相关问题推荐
-
Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?()
A、 The user must have been granted the DBA role.
B、 The user must have been granted the switch privilege as a part of a role.
C、 The user must have been granted the Resource Manager administrator privilege.
D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
-
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?()
AYou must ensure that the SALES database is mounted or open.
BYou must restore a backup control file to perform a block media recovery.
CYou must take the tools01.dbf data file offline before you start a block media recovery.
DYou must put the database in NOARCHIVELOG mode to perform a block media recovery.
EYou can perform only a complete media recovery of individual blocks; point-in-time recovery of individual data blocks is not supported.
-
You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?()
A、 One block change tracking file is created for each data file. By default, the file is created in DB_CREATE_FILE_DEST.
B、 One block change tracking file is created for each data file. By default, the file is created in BACKGROUND_DUMP_DEST.
C、 One block change tracking file is created for the database. By default, the file is created in DB_CREATE_FILE_DEST.
D、 One block change tracking file is created for the database. By default, the file is created in BACKGROUND_DUMP_DEST.
-
下列程序的运行结果为 #include<iostream.h> template<class TT> class FF {TT a1,a2,a3; public: FF(TT b1,TT b2,TT b3){a1=b1;a2=b2;a3=b3;} TT Sum(){return a1+a2+a3;}}; void main() { FF<int>x(int(1.1),2,3),y(int(4.2),5,6); cout<<x.Sum()<<‘‘<
A.6.1 15.2
B.6 15
C.6 15.2
D.6.1 15
-
In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()
A、 when all the online redo log groups are multiplexed and one of the members of a group is missing
B、 when all the online redo log groups are not multiplexed and one log group is missing
C、 when all the control files are missing
D、 when some important tables are deleted from the database and purged from the Recycle Bin