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?
A.
It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because
the wallet must be opened to encrypt columns with SALT.
B.
It generates an error when creating the table because the wallet is closed.
C.
It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the
wallet needs to be open only for tablespace creation.
D.
It generates error when creating the table, because the salt option cannot be used with encrypted
tablespaces.
B.
https://docs.oracle.com/database/121/ASOAG/asotrans_mgr.htm#ASOAG10321
The following data operations will fail if the keystore is not accessible:
SELECT data from an encrypted column
INSERT data into on an encrypted column
CREATE a table with encrypted columns
CREATE an encrypted tablespace