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?()
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact?()
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()
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 of the following best describes the age of the data in an OLTP system?()
You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
A customer plans to implement a new OLTP and data base application. The records are smalland access is random, with a lot of write activity. Which RAID level is the best solution for thisapplication?()
Which of the following is the main feature of an OLTP application?()
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?()
In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance?()