Which two are true concerning a multitenant container database with three pluggable database?
A.
All administration tasks must be done to a specific pluggable database.
B.
The pluggable databases increase patching time.
C.
The pluggable databases reduce administration effort.
D.
The pluggable databases are patched together.
E.
Pluggable databases are only used for database consolidation.
Explanation:
The benefits of Oracle Multitenant are brought by implementing a pure deployment
choice. The following list calls out the most compelling examples.* High consolidation density. (E)
The many pluggable databases in a single multitenant 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. This is the same benefit that
schema-based consolidation brings.
* Rapid provisioning and cloning using SQL.
* New paradigms for rapid patching and upgrades. (D, not B)
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.
* (C, not A) Manage many databases as one.
By consolidating existing databases as pluggable databases, administrators can manage many
databases as one. For example, tasks like backup and disaster recovery are performed at the
multitenant container database level.
* Dynamic between pluggable database resource management. In Oracle Database 12c,
Resource Manager is extended with specific functionality to control the competition for resources
between the pluggable databases within a multitenant container database.
Note:
* 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 multitenant 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.
Reference: 12c Oracle Multitenant
choose two ?? Answer: C,E
C and E
C,D.
http://docs.oracle.com/database/121/CNCPT/cdbovrvw.htm#CNCPT89242
Benefits of the Multitenant Architecture for Manageability.
The multitenant architecture has benefits beyond database consolidation. These benefits derive from storing the data and data dictionary metadata specific to a PDB in the PDB itself rather than storing all dictionary metadata in one place. By storing its own dictionary metadata, a PDB becomes easier to manage as a distinct unit, even when only one PDB resides in a CDB.
CE
C,D
Benefits of the Multitenant Architecture:
– Benefits of the Multitenant Architecture for Database Consolidation
– Benefits of the Multitenant Architecture for Manageability
http://docs.oracle.com/database/121/CNCPT/cdbovrvw.htm#CNCPT89242
C and D
E is wrong ONLY .
If one benefit is right
D is true but patch applied in CDB. All PDBS applied together.
CD – OK
C – OK
For example, 100 servers may have one database each, with each database using 10% of hardware resources and 10% of an administrator’s time. A team of DBAs must manage the SGA, database files, accounts, security, and so on of each database separately, while system administrators must maintain 100 different computers.
D – OK
Fewer database patches and upgrades
It is easier to apply a patch to one database than to 100 databases, and to upgrade one database than to upgrade 100 databases.
http://docs.oracle.com/database/121/CNCPT/cdbovrvw.htm#CNCPT89240
E is wrong because, Its not only for Database consolidation!
and we should choose only two options, so its C and D.
CD
CD
C, D are the only correct answers.
C is correct.
But confused with D & E as both are correct .
D.
The pluggable databases are patched together.
E.
Pluggable databases are only used for database consolidation.
I think that E is not correct because Pluggable databases are NOT only used for database consolidation
correct are C, D ( chose two)
Consolidation is one of the benefit in 12c, not the Only Use
Answers : CD
https://docs.oracle.com/database/121/CNCPT/cdbovrvw.htm#CNCPT89242
Using the multitenant architecture for database consolidation has the following benefits:
Cost reduction ( it use for db consolidation but this is not the only benefit of PDB, it is obvious )
By consolidating hardware and sharing database memory and files, you reduce costs for hardware, storage, availability, and labor. For example, 100 PDBs on a single server share one database instance and one set of database files, thereby requiring less hardware and fewer personnel.
Easier and more rapid movement of data and code
By design, you can quickly plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the transportable tablespace technique.
Easier management and monitoring of the physical database ( Answer C )
The CDB administrator can attend to one physical database (one set of files and one set of database instances) rather than split attention among dozens or hundreds of non-CDBs. Backup strategies and disaster recovery are simplified.
Separation of data and code
Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs. For example, if user error loses critical data, a PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve the lost data without affecting other PDBs.
Secure separation of administrative duties
A user account is common, which means that it can connect to any container on which it has privileges, or local, which means that it is restricted to a specific PDB. A CDB administrator can use a common user account to manage the CDB. A PDB administrator uses a local account to manage an individual PDB. Because a privilege is contained within the container in which it is granted, a local user on one PDB does not have privileges on other PDBs within the same CDB.
Ease of performance tuning
It is easier to collect performance metrics for a single database than for multiple databases. It is easier to size one SGA than 100 SGAs.
Support for Oracle Database Resource Manager
In a multitenant environment, one concern is contention for system resources among the PDBs running on the same computer. Another concern is limiting resource usage for more consistent, predictable performance. To address such resource contention, usage, and monitoring issues, you can use Oracle Database Resource Manager (see “Database Resource Manager”).
Fewer database patches and upgrades ( Answer D )
It is easier to apply a patch to one database than to 100 databases, and to upgrade one database than to upgrade 100 databases.
CE