You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()
在Hibernate中,下列关于Transaction说法正确的有()
TPS(Transaction Per Second)
In order to perform Flashback Transaction Query operations, which of these steps are required?()
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE 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. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()
Which statement is true regarding the effect of this command on the transaction in Scott’s session()
View the following SQL statements: Transaction T1 INSERT INTO hr.regions VALUES (5,’Pole’);COMMIT; Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5; COMMIT; Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5; You want to back out transaction T2. Which option would you use?()
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation()
By using the transaction identifier provided by () for a particular row change, you can use theFlashback Transaction Query to see the operation performed by the transaction.
When does a transaction complete?()