1z0-497 Exam Dumps - Oracle Database 12c Certified Implementation Specialist Questions and Answers

a, b, c, d, e, f

b, c, a, d, e, f

c, b, a, d, f, e

a, b, c, d

b, c, a, d

You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB;

SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;

You alter the salesprd source database to open in read-only mode, and start cloning the source database:

SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;

SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;

You alter the salesprd source database to open in read-only mode:

SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;

In the development CDB, you create a databaselink "PRD" that connects to the root of the source CDB, and start cloning the source PDB:

SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;

Connected as the salesprd local DBA, you create an XML using:

SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ;

Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into the development CDB using:

SQL> CREATE PLUGGABLE DATABASE salesdev USING' /tmp/salesprd.xml';

3, 4, and 5

1, 2, 5, and 6

1, 2, 3, and 4

2, 3, 5, and 6

2, 3, 4, 5, and 6

1, 2, 3, 4, 5, and 6

FULL

SCHEMAS

TRANSFORM

REMAP_SCHEMA

REMAP_TABLESPACE

renaming the control files

re-creating the control files

dropping a user in your database

dropping a tablespace in your database

configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

database backup and recovery using RMAN

performance tuning operations such as generation of AWR, ADDM, and ASH reports

storage configuration for archive logs and control files

storage configuration for data files and redo log groups

database status view and Data Pump export and import jobs

Process Monitor Process (PMON)

Flashback Data Archive process (FBDA)

Space Management Coordinator process (SMCO)

Recoverer process (RECO)

Listener Registration process (LREG)

Checkpoint Process

ADO policies can automatically compress data when it qualifies.

ADO policies can automatically move segments when necessary.

ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

You cannot compress at block level, but you can compress at segment level.

You can compress at row level only for QUERY LOW.

Automatic Storage Management (ASM)

OS file system

logical volume (LVM)

clustered file system

RAW

An SPFILE is a binary file that cannot be edited by using a text editor.

You can create an SPFILE from an existing text initialization parameter file or from memory.

You can use the SHOW PARAMETERS command to display the values of initialization parameters in an SPFILE.

The instance first searches for an SPFILE named spfileoRACLE_SID.ora and, if this is not found. It searches for spfile.ora.