Oracle OCP 9i to 11g Miscellaneous New Features

Card Set Information

Author:
Anonymous
ID:
207440
Filename:
Oracle OCP 9i to 11g Miscellaneous New Features
Updated:
2013-03-15 07:05:32
Tags:
Oracle OCP 9i 11g Miscellaneous New Features
Folders:

Description:
Oracle OCP 9i to 11g Miscellaneous New Features
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Anonymous on FreezingBlue Flashcards. What would you like to do?


  1. Oracle OCP 9i to 11g Miscellaneous New Features
  2. What feature allows a table to be redefined while online?
    Enhanced online table redefinition
  3. Is a table locked during Enhanced online table redefinition?
    Yes, but only for a very short time, depending on the table complexity.
  4. Can a table be redefined if it has logs or MVs?
    Yes, since 11g
  5. What happens to dependent PL/SQL packages during online table redefinition?
    • They are not affected, recompilation is NOT required.
    • This is true for all table-dependent objects except triggers
  6. What feature allows for the creation of policies that define specific conditions that trigger an audit record?
    Fine Grained Auditing
  7. What is required to create a fine-grained auditing policy?
    Execute priviege on DBMS_FGA package
  8. What can Fine Grained Auditing audit?
    • Among Others...
    • Table access during a specific time
    • Access from a specific IP
    • Selecting or Updating of a specific column
  9. What advantages does Fine GRained Auditing have over standard auditing?
    • Performs a Boolean check, record only created is a condition is met
    • Can capture the SQL that triggered the audit (with bind variables)
    • Can audit columns with sensitive data
    • Can create event handler to send an email alert
  10. What is required to capture SQL in fine agrained audit?
    DBMS_FGA.ADD_POLICY to DB+EXTENDED or XML+EXTENDED
  11. What Initialzation parameter are required to enable fine grained auditing?
    None
  12. What relation does Fine Auditing Policy have with Audit_Trail?
    None
  13. What formats can the audit_trail be specified specified for fine-grained auditing?
    • XML
    • XML+EXTENDED
    • DB
    • DB+EXTENDED
  14. Where are DB and DB+EXTENDED audit records written?
    SYS.FGA_LOG$
  15. Where are XML and XML+EXTENDED audit records written?
    OS Level in XML format
  16. How do you modify a fine grained audit policy after it's created?
    You can't, need to drop and recreate it.
  17. In which table are Fine Grained Auditing Records stored?
    SYS.FGA_LOG$
  18. Which view shows information about audit policies currently in effect?
    DBA_FGA_AUDIT_TRAIL
  19. Which view combines both the standard and fine-grained audits?
    DBA_COMMON_AUDIT_TRAIL
  20. Which view contains fine-grained audit records written in XML format?
    V$XML_AUDIT_TRAIL
  21. What is an invisible index?
    One which the optimizer will ignore
  22. How does one make invisible indexes visible to the optimizer?
    Use the OPTIMIZER_USE_INVISIBLE_INDEXES Parameter

What would you like to do?

Home > Flashcards > Print Preview