OCP 문제은행

Examine the SQL command sequence. What is the expected outcome of executing these commands?

You need to create a new pluggable database, HR_TEST_PDB, by cloning an existing pluggable database, HR_PROD_PDB, which is currently open in READ WRITE mode. You want to ensure the new PDB uses its own dedicated file system location. Examine the following commands: ```sql CREATE PLUGGABLE DATABASE hr_test_pdb FROM hr_prod_pdb FILE_NAME_CONVERT=('hr_prod_pdb','hr_test_pdb'); ALTER PLUGGABLE DATABASE hr_test_pdb OPEN; ``` Which statement is true regarding this operation?

You have a non-CDB database named `LEGACYDB` running on Oracle Database 19c. You want to migrate it into a new PDB within an existing CDB, `CDB01`. You have already performed the necessary `DBMS_PDB.CHECK_PLUG_COMPATIBILITY` checks and ensured compatibility. Which sequence of steps is correct to create a new PDB from `LEGACYDB`?

You have an existing PDB named `SALES_PDB` in `CDB01`. You need to move `SALES_PDB` to a different CDB, `CDB02`. Which two actions are required before `SALES_PDB` can be plugged into `CDB02`?

You are creating a new PDB, `FINANCE_PDB`, within a CDB configured for `SHARED UNDO`. You want `FINANCE_PDB` to use its own dedicated undo tablespace. Examine the following SQL command: ```sql CREATE PLUGGABLE DATABASE finance_pdb ADMIN USER pdb_admin IDENTIFIED BY oracle DEFAULT TABLESPACE users; ``` What is the most likely outcome regarding the undo configuration for `FINANCE_PDB`?

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?

You want to completely remove a pluggable database named `OLD_PDB` from `CDB01`, including all its associated data files. Examine the following SQL command: ```sql DROP PLUGGABLE DATABASE old_pdb; ``` What is the most accurate description of the outcome of this command?

You have a large PDB, `DATA_PROD`, and need to create a new PDB, `DATA_TEST`, as a point-in-time copy for testing purposes, minimizing storage consumption and creation time. `CDB01` is configured to use ACFS (Oracle Automatic Storage Management Cluster File System) and `DATA_PROD` is open in READ WRITE mode. Which command should you use to achieve this goal efficiently?

You are administering `CDB01` and notice that a parameter, `OPTIMIZER_MODE`, is set at the CDB root level. Which statement is true regarding how `OPTIMIZER_MODE` behaves for a newly created PDB within `CDB01`?

You are attempting to create a new PDB, `REPORT_PDB`, within `CDB01`. You want to specify a temporary tablespace for the new PDB. Examine the following command: ```sql CREATE PLUGGABLE DATABASE report_pdb ADMIN USER rep_admin IDENTIFIED BY oracle DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp_rep; ``` Which statement is true if `temp_rep` is an existing temporary tablespace defined at the CDB root level?