A. System Global Area (SGA), server processes, and background processes
B. database files, System Global Area (SGA), and background processes
C. System Global Area (SGA) and background processes
D. a listener process, server processes, and background processes
E. database files and parameter file (initialization parameter file or server parameter file)
A. when upgrading from Oracle Database 11g to Oracle Database 12c
B. when upgrading from Oracle Database 10g to Oracle Database 12c
C. when upgrading from Oracle Database 12c to the first patch set of Oracle Database 12c
D. when upgrading from any previous version of Oracle Database to Oracle Database 12c
A. from either a client or server, only if the database instance is up, but the command does not connect the session to the instance
B. from either a client or server, only if the database instance is up, and the command connects the session to the instance
C. only from the server, if the database instance is not up
D. from either a client or server, even if the database instance is not up
A. You cannot do this, because you can only clone PDBs into another CDB.
B. You can clone only one PDB (either PDB1 or PDB2) into the same CD
C. Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.
D. Cloning a PDB can use the source files copy method to the target PDB files.
A. You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.
B. You should stop all applications running from the software directory that is being patched.
C. You should install the latest O patch before applying the patch.
D. You should make sure that you have a good backup of the software, database, and configuration files.
E. You should check the patch conflict with installed patches before applying the patch.
A. Partitioning
B. Index
C. Database vault
D. Row-level security
E. Triggers
A. Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.
B. Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.
C. Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.
D. Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.
E. Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.
A. It starts the second listener without affecting current sessions.
B. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.
C. It gives an error because multiple listeners cannot run simultaneously.
D. It starts the second listener and terminates all current sessions.
A. ALTER DATABASE RECOVER
B. STARTUP
C. SHUTDOWN
D. DROP DATABASE
E. CREATE DATABASE
A. RMAN> VALIDATE CORRUPT BLOCKS
B. RMAN> VALIDATE BACKUP
C. RMAN> VALIDATE DATABASE
D. RMAN> VALIDATE CHECK LOGICAL
