OCP 14 Using Flashback and Logminer
Home > Flashcards > Print Preview
The flashcards below were created by user
on FreezingBlue Flashcards
. What would you like to do?
In which two ways can you specify the default flashback archive?
ALTER FLASHBACK ARCHIVE...SET DEFAULT CREATE FLASHBACK ARCHIVE...DEFAULT
Which four backout options can you specify with the DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure?
CASCADE, NOCASCADE, NOCASCADE_FORCE, and NONCONFLICT_ONLY
What is the result if you specify an ALTER TABLE...FLASHBACK ARCHIVE statement without specifying a flashback archive name?
If a default flashback archive exists, it will be used. Otherwise, the command generates an error.
What happens when you issue a FLASHBACK TABLE statement that causes constraints to be violated?
The Flashback operation is aborted.
In which mode must your database be running to configure the database to use the flash backup and recovery feature?
The ARCHIVELOG mode
Which changes are backed out if you specify the NOCASCADE_FORCE option when calling the DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure?
Only changes made to rows by the specified transactions, and not any changes made by dependent transactions
Which option of the DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure should you specify to reverse changes made by specific transactions and all their dependent transactions?
The CASCADE option
Which background process is used by Flashback Data Archive to track and store historical table data?
The FBDA process
Must supplemental logging be enabled or disabled to use Flashback Transaction?
What is dropped when you issue the DROP FLASHBACK ARCHIVE statement?
The flashback data archive and the data in the archive, but not the tablespaces
What is the result if you enable Flashback Data Archive for a table without specifying a flashback data archive name and no default flashback archive has been created?
The ALTER TABLE statement generates an error.
Which new feature of Oracle 11g should you use if you want to track all long-term transactional changes to a specific table even past the undo retention period?
Flashback Data Archive
What does a NULL value for the STATUS column of the DBA_FLASHBACK_ARCHIVE view indicate?
The flashback archive is not the default flashback archive.
Which four types of database objects can Flashback Versions Query NOT be used to query?
Fixed tables, external tables, temporary tables, and views
In Oracle 11g, is automatic undo management enabled or disabled by default?
What must be true for tablespaces used by a flashback data archive?
They must use automatic segment space management.
What is the result of specifying the MODIFY RETENTION clause of the ALTER FLASHBACK ARCHIVE statement?
The retention period for the archive is modified, and if applicable, all historical data that is no longer within the retention period is purged from the flashback archive.
Which feature is an extension to Flashback Transaction Query that allows you to back out specific transactions?
Which privilege must a user be granted to perform transaction backout using Flashback Transaction?
EXECUTE privileges on the DBMS_FLASHBACK package
Which statement will you use to recover a particular table in your database to a specific point in time?
The FLASHBACK TABLE statement
Which three DDL statements are not allowed on a table for which Flashback Data Archive has been enabled?
- DROP TABLE
- RENAME TABLE
- TRUNCATE TABLE
- Modifying a column
- Partitioning the table
- Converting LONG to LOB
Which two prerequisites must be met to use Flashback Data Archive?
- Database must use automatic undo management.
- Tablespaces used by flashback data archives must use automatic segment space management.
Which changes are backed out if you specify the NONCONFLICT_ONLY option when calling the DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure?
Only changes for the specified transaction in which row conflicts do not exist
What would you like to do?
Home > Flashcards > Print Preview