You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table:
SQL> FLASHBACK TABLE ORDERS TO SCN 771513;
What is the prerequisite to perform Flashback Table?()
A. You must configure OMF in your database.
B. You must enable block change tracking feature in your database.
C. You must enable ROW MOVEMENT feature on the ORDERS table.
D. You must use the Flashback Version Query before using the Flashback Table feature.
您可能感兴趣的试卷
你可能感兴趣的试题
A. Flashback Drop
B. Flashback Database
C. Flashback Table
D. Flashback Version Query
You issued the following command:
SQL> DROP TABLE MYTABLE;
SQL> SHOW RECYCLEBIN The following output is returned:
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
------------- ------------------------------ --------------- --------------------
MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE
2005-01-13:20:11:31 You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()
A. DROP TABLE MYTABLE PURGE;
B. PURGE RECYCLEBIN;
C. PURGE TABLE MYTABLE;
D. PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;
A. RESETLOGS
B. TO TIMESTAMP
C. TO BEFORE DROP
D. RENAME TO
E. TO SCN
You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace. The following dependent objects have been defined on the dropped table:
Due to limited space, some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement: SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP;
What will be the implication of executing this statement?()
A. Only the WAREHOUSE_DETAILS table is recovered, and none of the dependent objects are recovered.
B. The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints, primary key constraint, and the referential integrity constraints.
C. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.
D. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.
A. by using Oracle Enterprise Manager
B. by issuing the FLASHBACK TABLE statement at the RMAN prompt
C. by issuing the FLASHBACK TABLE statement at the SQL prompt
D. by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
A. You must use automatic undo management in the database.
B. You must configure OMF in your database.
C. You must configure ASM for storing the datafiles.
D. You must multiplex the online redo log file.
At 5:30 PM, a database administrator, William, is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4:30 P.M, the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion:
SELECT operation, undo_sql, logon_user
FROM FLASHBACK_TRANSACTION_QUERY WHERE xid=
HEXTORAW(’0100043E23456’);
where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement, which task did William perform to identify the transaction ID of the transaction that deleted the row?()
A. William used the Flashback Version Query feature.
B. William issued the CROSSCHECK command at the RMAN prompt.
C. William viewed the alert log file.
D. William used the Flashback Table feature.
A. Only the Flashback Table
B. Both the Flashback Transaction Query and the Flashback Version Query
C. Only the Flashback Drop
D. Only the Flashback Version
A. when you want to restore an important table that is dropped from the Recycle Bin
B. when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
C.when you want to restore a dropped user’s schema
D. when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
最新试题
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery?()
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?()
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
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 are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
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?()
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?()
You lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()