OCP 7 Oracle SecureFiles

Card Set Information

Author:
Tralala
ID:
213626
Filename:
OCP 7 Oracle SecureFiles
Updated:
2013-04-15 09:10:16
Tags:
OCP Oracle SecureFiles
Folders:

Description:
OCP 7 Oracle SecureFiles
Show Answers:

Home > Flashcards > Print Preview

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


  1. Which clause of the CREATE TABLE statement should you include for a LOB if you want to store the data as a SecureFile?
    The STORE AS SECUREFILE clause
  2. What is the recommended way to migrate traditional LOBs to SecureFiles?
    Using online redefinition
  3. When using online redefinition to migrate traditional LOBs to SecureFiles, are you required to take the table or partition offline?
    No
  4. For which type LOBs does the DBMS_SPACE.SPACE_USAGE procedure return space usage for LOB chunks?
    Only for SecureFile LOBs
  5. At which two levels can you use online redefinition to migrate traditional LOBs to SecureFiles?
    At the table level or partition level
  6. How large are the chunks of disk storage used with SecureFiles?
    They vary from the data block size to 64 MB.
  7. Which three settings can you configure for a specified LOB using the DBMS_LOB.SETOPTIONS procedure?
    Encryption, compression, and deduplication settings
  8. Which initialization parameter do you use to enable using SecureFiles?
    The DB_SECUREFILE initialization parameter
  9. What does the DBMS_SPACE.SPACE_USAGE procedure return for LOBs?
    Information about LOB space usage for both SecureFiles and BasicFiles
  10. When creating a SecureFile LOB using a CREATE TABLE statement, is encryption for the LOB enabled or disabled if you do not specify the ENCRYPT parameter?
    Disabled
  11. Are SecureFile LOBs cached in the buffer cache by default?
    No, you must specify the CACHE parameter.
  12. To create a SecureFile in a tablespace, what requirement must be met by the tablespace?
    The tablespace must use automatic segment space management.
  13. In which two ways can you migrate traditional LOBs to SecureFiles?
    Using partition exchange or online redefinition
  14. Which new Oracle 11g feature provides access to unstructured data, such as an LOB, but offers better performance than using the file system?
    Oracle SecureFiles
  15. What is the result of setting the DB_SECUREFILE initialization parameter to IGNORE?
    BasicFiles are created even if the STORE AS SECUREFILE clause is specified.
  16. What is the result of setting the DB_SECUREFILE initialization parameter to ALWAYS?
    All LOBs created in ASSM tablespaces are created as SecureFiles, and those created in non-ASSM tablespaces are created as BasicFiles.
  17. With default settings, what is the result if you create a table containing an LOB and do not specify the STORE AS SECUREFILE clause?
    A BasicFile is created.
  18. Which value for the DB_SECUREFILE initialization parameter indicates that all LOBs will be created as SecureFiles?
    FORCE
  19. Which LOB parameter should you include in your CREATE TABLE statement if you want to enable LOB compression?
    The COMPRESS parameter

What would you like to do?

Home > Flashcards > Print Preview