Oracle
1Z0-050 · Question #61
Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?
The correct answer is A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB. See the full explanation below for the reasoning.
Question
Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?
Options
- AIt forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.
- BIt forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB.
- CIt does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is
- DIt ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is
How the community answered
(23 responses)- A78% (18)
- B4% (1)
- C13% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.