Oracle Database 11g: Administration II
Question No: 401 – (Topic 12)
Which two statements regarding the Flashback Table feature are correct? (Choose two.)
Flashback Table can be performed on system tables.
Flashback Table operation does not shrink the segments.
Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
Flashback Table operation acquires exclusive data manipulation language (DML) locks.
Answer: B,D Explanation: Semantics
During an Oracle Flashback Table operation, Oracle Database acquires exclusive DML locks on all the tables specified in the Flashback list. These locks prevent any operations on the tables while they are revertingto their earlier state.
Restrictions on Flashing Back Tables
This statement is subject to the following restrictions:
->Flashback Table operations are not valid for the following type objects: tables that are part of a cluster, materialized views, Advanced Queuing (AQ) tables, static data dictionary tables, system tables, remote tables, object tables, nested tables, or individual table partitions or subpartitions.
->The following DDL operations change the structure of a table, so that you cannot subsequently use the TO SCN or TO TIMESTAMP clause to flash the table back to a time preceding the operation: upgrading, moving, or truncating a table; adding a constraint to a table, adding a table to a cluster; modifying or dropping a column; changing a column encryption key; adding, dropping, merging, splitting, coalescing, or truncating a partition or subpartition (with the exception of adding a range partition).
Question No: 402 – (Topic 12)
You have just performed a FLASHBACK TABLE operation using the following command: flashback table employees to scn 123456;
The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation?
All the triggers are disabled.
All the triggers are enabled by default.
Enabled triggers remain enabled and disabled triggers remain disabled.
Triggers are deleted when a Flashback Table operation is performed.
Question No: 403 – (Topic 12)
Which three actions are required to configure the Flashback Database? (Choose three.)
set Flash Recovery Area
enable Flashback logging
create FLASHBACK tablespace
start the database in the ARCHIVELOG mode
start the database in the NOARCHIVELOG mode
Question No: 404 – (Topic 12)
When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.)
Create a default archive
Question No: 405 – (Topic 12)
You are working as a DBA on the decision support system.
There is a business requirement to track and store all transactions for at least three years for a few tables in the database.
Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?
Enable Flashback Data Archive for the tables.
Specify undo retention guarantee for the database.
Enable supplemental logging for the database.
Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
Create Flashback Data Archive on the tablespace on which the tables are stored.
Question No: 406 – (Topic 12)
You are working in an online transaction processing (OLTP) environment. You use 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. 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?
Restore the backup control file and open the database with RESETLOGS option.
Perform point-in-time recovery because flashback cannot be performed again on this table
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
Question No: 407 – (Topic 12)
You plan to execute the following command to perform a Flashback Database operation in your database:
SQLgt; FLASHBACK DATABASE TO TIMESTAMP (SYSDATE – 5/24);
Which two statements are true about this? (Choose two)
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
Question No: 408 – (Topic 12)
You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this:
Set the retention target:
SQLgt; ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
Enable Flashback Database:
SQLgt; ALTER DATABASE FLASHBACK ON;
Mount the database:
SQLgt; STARTUP MOUNT EXCLUSIVE
Shutdown the instance:
SQLgt; SHUTDOWN IMMEDIATE
Open the database:
SQLgt; ALTER DATABASE OPEN;
Choose the correct sequence.
A. 4, 1, 3, 2, 5
B. 4, 3, 1, 2, 5
C. 2, 4, 3, 5, 1
D. 4, 2, 5, 3, 1
Question No: 409 – (Topic 12)
Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
Database must be running in archivelog mode.
Automatic undo management must be enabled.
Undo retention guarantee must be enabled.
The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
Question No: 410 – (Topic 12)
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.
You issued the following command to drop the Flashback Archive FLA1:
DROP FLASHBACK ARCHIVE fla1;
What is the effect of this command?
The Flashback Archive FLA1 is dropped only if it is empty.
The tablespace having Flashback Archive is dropped.
The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
The Flashback Data Archive and historical data are dropped.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|