Correct Answer: C

Correct Answer: A

RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE;

RMAN> RESTORE TABLESPACE sysaux;

RMAN> RECOVER TABLESPACE sysaux;

RMAN> ALTER TABLESPACE sysaux ONLINE;

*

Example:

While evaluating the 12c beta3 I was not able to do the recover while testing "all pdb files lost".

Cannot close the pdb as the system datafile was missing...

So only option to recover was:

Shutdown cdb (10)

startup mount; (1)

restore pluggable database

recover pluggable database

alter database open;

alter pluggable database name open;

Oracle support says: You should be able to close the pdb and restore/recover the system tablespace of

PDB.

*

Inconsistent backups are usually created by taking online database backups. You can also make an

inconsistent backup by backing up data files while a database is closed, either:

/ Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, all instances) / After shutting down the database using SHUTDOWN ABORT

Inconsistent backups are only useful if the database is in ARCHIVELOG mode and all archived redo logs created since the backup are available.

* Open the database with the RESETLOGS option after finishing recovery: SQL> ALTER DATABASE OPEN RESETLOGS;

Correct Answer: ABC

The large pool can provide large memory allocations for the following: / (B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases) /Message buffers used in the parallel execution of statements / (A) Buffers for Recovery Manager (RMAN) I/O slaves

Note:

*

large pool

Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O

server processes, and session memory for the shared server and Oracle XA.

*

Oracle XA

An external interface that allows global transactions to be coordinated by a transaction manager other than

Oracle Database.

*

UGA

User global area. Session memory that stores session variables, such as logon information, and can also

contain the OLAP pool.

*

Configuring the Large Pool

Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not

attempt to age objects out of the large pool. Consider configuring a large pool if the database instance

uses any of the following Oracle Database features:

*

Shared server

In a shared server architecture, the session memory for each client process is included in the shared pool.

*

Parallel query

Parallel query uses shared pool memory to cache parallel execution message buffers.

*

Recovery Manager

Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore

operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers

that are a few hundred kilobytes in size.

Correct Answer: BE

B: Using 12c Resource manager you will be able control CPU, Exadata I/O, sessions and parallel servers.

A new 12c CDB Resource Manager Plan will use so-called "Shares" (resource allocations) to specify how

CPU is distributed between PDBs. A CDB Resource Manager Plan also can use "utilization limits" to limit

the CPU usage for a PDB. With a default directive, you do not need to modify the resource plan for each

PDB plug and unplug.

E: New paradigms for rapid patching and upgrades.

The investment of time and effort to patch one multitenant container database results in patching all of its

many pluggable databases. To patch a single pluggable database, you simply unplug/plug to a multitenant

container database at a different Oracle Database software version.

Incorrect Answers:

A:

*

The Oracle RAC documentation describes special considerations for a CDB in an Oracle RAC environment.

*

Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application.

D: You can unplug a PDB from one CDB and plug it into a different CDB without altering your schemas or applications. A PDB can be plugged into only one CDB at a time.

F:

*

UNDO tablespace can NOT be local and stays on the CDB level.

*

Redo and undo go hand in hand, and so the CDB as a whole has a single undo tablespace per RAC instance.

Correct Answer: AD

A (not B, not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.

D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB:

Incorrect Answers:

E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

Correct Answer: BDG

B:

*

A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces. It can also contains other user created

tablespaces in it.

*

There is one default temporary tablespace for the entire CDB. However, you can create additional

temporary tablespaces in individual PDBs.

D:

*

There is a single redo log and a single control file for an entire CDB

*

A log switch is the point at which the database stops writing to one redo log file and begins writing to

another. Normally, a log switch occurs when the current redo log file is completely filled and writing must

continue to the next redo log file.

G: instance recovery

The automatic application of redo log records to uncommitted data blocks when an database instance is

restarted after a failure.

Incorrect Answers:

A:

*

There is one set of background processes shared by the root and all PDBs. ?

*

High consolidation density. The many pluggable databases in a single container database share its

memory and background processes, letting you operate many more pluggable databases on a particular

platform than you can single databases that use the old architecture.

C: There is a separate SYSAUX tablespace for the root and for each PDB.

F: There is a separate SYSTEM tablespace for the root and for each PDB.

Correct Answer: D

Note:

Providing a UNIX Group Name

If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of

the group which should own the base directory.

You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle

software. Members of this group must have write permissions to the base directory chosen.

Only users who belong to this group are able to install or deinstall software on this machine.

Correct Answer: ACD

http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBBIADA

Correct Answer: BD

O12c is integrated in database don't have his own agent like in O11G then you cannot start up or shut down a database.

Correct Answer: AC