nerdexam
Oracle

1Z0-050 · Question #23

You opened the encryption wallet and then issued the following command: SQL>CREATE TABLESPACE securespace DATAFILE '/home/user/oradata/secure01.dbf' SIZE 150M ENCRYPTION USING '3DES168' DEFAULT…

The correct answer is B. It generates an error because the wallet is closed. See the full explanation below for the reasoning.

Question

You opened the encryption wallet and then issued the following command:

SQL>CREATE TABLESPACE securespace DATAFILE '/home/user/oradata/secure01.dbf' SIZE 150M ENCRYPTION USING '3DES168' DEFAULT STORAGE(ENCRYPT); Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column. What is the outcome?

Options

  • AIt creates the table and encrypts the data in it.
  • BIt generates an error because the wallet is closed.
  • CIt creates the table but does not encrypt the data in it.
  • DIt generates an error because the NO SALT option cannot be used with the ENCRYPT option.

How the community answered

(36 responses)
  • A
    14% (5)
  • B
    75% (27)
  • C
    6% (2)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-050 Practice