OCP 14 Using Flashback and Logminer

The flashcards below were created by user Tralala on FreezingBlue Flashcards.

  1. In which two ways can you specify the default flashback archive?
  2. Which four backout options can you specify with the DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure?
  3. 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.
  4. What happens when you issue a FLASHBACK TABLE statement that causes constraints to be violated?
    The Flashback operation is aborted.
  5. In which mode must your database be running to configure the database to use the flash backup and recovery feature?
    The ARCHIVELOG mode
  6. 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
  7. 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
  8. Which background process is used by Flashback Data Archive to track and store historical table data?
    The FBDA process
  9. Must supplemental logging be enabled or disabled to use Flashback Transaction?
  10. 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
  11. 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.
  12. 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
  13. 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.
  14. Which four types of database objects can Flashback Versions Query NOT be used to query?
    Fixed tables, external tables, temporary tables, and views
  15. In Oracle 11g, is automatic undo management enabled or disabled by default?
  16. What must be true for tablespaces used by a flashback data archive?
    They must use automatic segment space management.
  17. 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.
  18. Which feature is an extension to Flashback Transaction Query that allows you to back out specific transactions?
    Flashback Transaction
  19. Which privilege must a user be granted to perform transaction backout using Flashback Transaction?
    EXECUTE privileges on the DBMS_FLASHBACK package
  20. Which statement will you use to recover a particular table in your database to a specific point in time?
    The FLASHBACK TABLE statement
  21. Which three DDL statements are not allowed on a table for which Flashback Data Archive has been enabled?
    • Modifying a column
    • Partitioning the table
    • Converting LONG to LOB
  22. 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.
  23. 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
Card Set:
OCP 14 Using Flashback and Logminer
2014-05-21 13:56:48
OCP 14 Using Flashback Logminer

OCP 14 Using Flashback and Logminer
Show Answers: