Free Oracle 1Z0-062 Exam Actual Questions

The questions for 1Z0-062 were last updated On Nov 19, 2024

Question No. 1

Identify two correct statements about multitenant architectures.

Show Answer Hide Answer
Correct Answer: B, E

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:

Not 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.

Not 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.

not 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.


Question No. 2

To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:

SQL > startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.

Identify the reason the instance failed to start.

Show Answer Hide Answer
Correct Answer: B

Example:

SQL> startup force

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings

ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET


Question No. 3

The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.

You execute the following command to create a table:

Which two statements are true? (Choose two.)

Show Answer Hide Answer
Correct Answer: B, E

Question No. 4

Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

Show Answer Hide Answer
Correct Answer: B, D

Question No. 5

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

Which method or feature should you use?

Show Answer Hide Answer
Correct Answer: A