READ Free Dumps For Oracle- 1z0-062
| Question ID 21745 | You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?
|
| Option A | Use Oracle Managed Files (OMF).
|
| Option B | Specify the SEED FILE_NAME_CONVERT clause.
|
| Option C | Specify the PDB_FILE_NAME_CONVERT initialization parameter.
|
| Option D | Specify the DB_FILE_NAMECONVERT initialization parameter.
|
| Option E | Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
|
| Correct Answer | A,B,C |
Explanation Explanation: You must specify the names and locations of the seed's files in one of the following ways: * (A) Oracle Managed Files * (B) The SEED FILE_NAME_CONVERT Clause * (C) The PDB_FILE_NAME_CONVERT Initialization Parameter
| Question ID 21746 | You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
- Character set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character Set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
|
| Option A | Transportable database
|
| Option B | Transportable tablespace
|
| Option C | Data Pump full export/import
|
| Option D | The DBMS_PDB package
|
| Option E | RMAN
|
| Correct Answer | B |
Explanation Explanation: * Overview, example: - Log into ncdb12c as sys - Get the database in a consistent state by shutting it down cleanly. - Open the database in read only mode - Run DBMS_PDB.DESCRIBE to create an XML file describing the database. - Shut down ncdb12c - Connect to target CDB (CDB2) - Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2) - Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2). - Access the PDB and run the noncdb_to_pdb.sql script. - Open the new PDB in read/write mode. * You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB. * Note that to plugin a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.