Oracle Oracle Database 12c Certified Implementation Specialist 1z0-497 New Questions

Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

It provides new support for DML to global temporary tables and the use of sequences in the standby database.

It repairs block corruptions detected in the primary or standby database.

It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.

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

Real-Time ADDM uses AWR snapshots of the last 10 minutes.

Real-Time ADDM uses ASH recent activity from SGA data.

Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

Regular ADDM uses AWR snapshots that are not yet purged.

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';