1Z0-062 · Question #98
You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the…
The correct answer is B. It generates an error when creating the table because the wallet is closed. When you are using an encrypted tablespace if you try to create something in it, the first step that database execute is check if the wallet is open, and if is not open then raise the error: ORA- 28365: wallet is not open.
Question
You created an encrypted tablespace:
You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?
Options
- AIt creates the table successfully but does not encrypt any inserted data in the EMPNAME column
- BIt generates an error when creating the table because the wallet is closed.
- CIt creates the table successfully, and encrypts any inserted data in the EMPNAME column
- DIt generates error when creating the table, because the salt option cannot be used with encrypted
How the community answered
(32 responses)- A25% (8)
- B59% (19)
- C6% (2)
- D9% (3)
Explanation
When you are using an encrypted tablespace if you try to create something in it, the first step that database execute is check if the wallet is open, and if is not open then raise the error: ORA- 28365: wallet is not open.
Topics
Community Discussion
No community discussion yet for this question.