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.
您可能感兴趣的试卷
你可能感兴趣的试题
A. Backup of offline tablespaces.
B. Backup of read-only tablespaces.
C. Backup of system-critical tablespaces.
D. Backup of online， locally managed tablespaces.
E. Backup of read/write dictionary-managed tablespaces.
A. Heap table
B. Object table
C. External table
D. Clustered table
E. Global temporary table
F. Index-organized table （IOT）
A. This instance is being used to manage the operating system files.
B. This instance is being used to manage the files of other databases.
C. This instance is being used to manage the instances of other databases.
D. This instance is being used to manage the background processes of other instances.
A. Recovery catalog
B. Oracle Enterprise Manager Repository
C. Automatic Workload Repository （AWR）
D. Oracle 10g Enterprise Manager Grid Control
E. Automatic Database Diagnostic Monitor （ADDM）
A. functions
B. package
C. procedure
D. database trigger
E. anonymous PL/SQL block
Exhibit： View the Exhibit.You have more than one table in the recycle bin having the same original name， DEPT2. You do not have any table with the nameDEPT2 in your schema. You executed the following command：PURGE TABLE dept2； Which statement is correct in this scenario？（）
A. All the tables having the same original name as DEPT2 will be purged from the recycle bin.
B. The table with dropscn = 1928151 （oldest dropscn） will be purged from the recycle bin.
C. The table with dropscn = 1937123 （most recent dropscn） will be purged from the recycle bin.
D. None of the tables will be purged because there are multiple entries with the same original name in the recycle bin.
While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：
a） high availability of data
b） faster primary key access to the table data
c） compact storage for the table
Which type of tables would you use to achieve these objectives？（）
A. heap tables
B. object tables
C. partitioned tables
D. index-organized tables （IOTs）
A. The time when the last flashback operation in your database was performed.
B. The time when the first flashback operation in your database was performed.
C. A list of flashback operations performed in your database using SCN and time.
D. The approximate time and the lowest system change number （SCN） to which you can flash back your database.
A. Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
B. Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
C. Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
D. Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
A. Restore the lost data file from the backup， and then flash back the database.
B. Restore the data file pertaining to index tablespace， and then recover the tablespace.
C. Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
D. Restore all the data files， and then perform an incomplete recovery using the backup control file.
E. Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
最新试题
Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3：Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database？（）
For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）
The loss of the control file forced you to recreate the control file. After recreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a fivedigit number starting with 0. What could be the possible reason？（）
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery？（）
View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）
You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）
You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to recreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to recreate the indexes？（）