The flashcards below were created by user
on FreezingBlue Flashcards.
In the light of SecureFiles, what are the old large object storage now know as?
What are the advantages of SecureFiles?
- Path Optimization
What new init parameter is for SecureFiles?
What are the possible values for DB_SECUREFILE parameter?
- IT'S PIFAN!!!
- PERMITTED (DEFAULT)
What does ALWAYS in as DB_SECUREFILE parameter do?
Attempt to create SecureFile LOBs but fall back to BasicFile LOBS if tablespace is not using ASSM
What does FORCE in as DB_SECUREFILE parameter do?
Force all LOBS to be DB_SECUREFILE. If tablespace is MSSM an error is generated
What does NEVER in as DB_SECUREFILE parameter do?
Disallow SecureFile LOBSs from being created. If a Securefile LOB is in DML, create as BasicFile unless specific SecureFile options are stated; then create error.
What does IGNORE in as DB_SECUREFILE parameter do?
Disallow SecureFile LOBs and ignore any errors that would otherwise be caused by forcing BasicFile LOBs with SecureFile options.
How do Oracle recommend turning BasicFile LOBS into SecureFile LOBS?
What are the advantages of Online Redefinition?
- Tables and Partitions do not have to be take offline.
- Operation can be done in parallel.
- Operation requires additional tablespace during execution.
What has to be done after a partitioned table is redefined?
Global indexes must be rebuilt.
How can one obtain the current settings of a SecureFile LOB?
Which procedure allows SecureFile LOB features to be set?
Which function returns TRUE/FLASE depending on whether a LOB is a SecureFile?
What are the possible LOB compressions available in SecureFiles
High and Medium
What is the default compression setting
What is the default duplication setting
How is encryption removed?
- ALTER TABLE encrypt_tab MODIFY ( clob_data CLOB DECRYPT);
How is encryption method changed?
- ALTER TABLE encrypt_tab REKEY USING 'AES192';
In what types(s) of tablespace are Oracle Secure Files allowed?
What can speed up online table redefinition?
Running it in parallel
On what segment types can Online Table Redefinition be performed
When creating, altering LOBs for which type of LOB is CACHING an option?
Both SecureFile and BasicFile
What are the CACHING options when creating LOBS? What is the default
- CACHE READS
- NOCACHE (default)
If CACHE READS is specified when creating a LOB, what is the result?
LOBs are only placed in the buffer cache during read operations
What happens is one users the CACHE with NOLOGGING or FILESYSTEM_LIKE_LOGGING?
An error is generated, CACHE must have logging
Which procedure is used to check to space usage on LOBS?
What is the minimum COMPATIBLE value to user SecureFiles?
To Redefine a table or partition, must it be online or offline?