OCP CBT 기출문제 예상문제 490번

다음 문제를 풀어보세요.

You are tasked with creating a new PDB, `SECURE_PDB`, within `CDB01`. This PDB must use Transparent Data Encryption (TDE) for all its tablespaces. The `CDB01` already has a software keystore configured and open. Examine the following SQL commands: ```sql CREATE PLUGGABLE DATABASE secure_pdb ADMIN USER pdb_admin IDENTIFIED BY oracle; ALTER PLUGGABLE DATABASE secure_pdb OPEN; ``` Which additional step is required after creating `SECURE_PDB` to enable TDE for its tablespaces?

The CDB01 keystore is open. You want SECURE_PDB to have its own TDE master key.

Execute ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY <password> CONTAINER=CURRENT; followed by ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE IDENTIFIED BY <password> CONTAINER=CURRENT;

Execute ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE IDENTIFIED BY <password> CONTAINER=CURRENT; followed by ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY <password> WITH BACKUP CONTAINER=CURRENT;

Execute ADMINISTER KEY MANAGEMENT CREATE KEYSTORE '/path/to/secure_pdb_keystore' IDENTIFIED BY <password> CONTAINER=CURRENT; followed by ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY <password> CONTAINER=CURRENT;

Execute ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY <password> CONTAINER=ALL; followed by ALTER SYSTEM SET TDE_CONFIGURATION='KEYSTORE_CONFIGURATION=FILE_SYSTEM_KEYSTORE' SCOPE=BOTH;