Oracle 1Z0-497 Exam Dumps

Automatic Storage Management (ASM)

Online Data and Application change

Online Table Redefinition

Real Application Clusters (RAC)

Multiple PDBs on a single server need multiple database instances and multiple sets of database files.

Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.

A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB.

It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.

No Program Global Area (PGA) is allocated for shared server processes

User Global Area is stored in System Global Area (SGA).

Shared SQL Area is allocated from Program Global Area (PGA).

Private SQL Area is allocated from Library Cache.

There is only one SYSTEM tablespace per CDB .

There is only one instance per PDB.

There is one SYSAUXtablespace per PDB.

There is only one UNDO tablespace per CDB.

RMAN

Cold Backup

Traditional Export / Import

Data Pump