READ Free Dumps For Oracle- 1z0-062
| Question ID 21733 | 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.
|
| Option A | The PGA_AGGREGATE_TARGET parameter is set to zero.
|
| Option B | The STATISTICS_LEVEL parameter is set to BASIC.
|
| Option C | Both the SGA_TARGET and MEMORY_TARGET parameters are set.
|
| Option D | The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
|
| Correct Answer | B |
Explanation Explanation: 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 ID 21734 | What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?
|
| Option A | Effectively implements role separation
|
| Option B | Enables you to take advantage of Oracle Managed Files.
|
| Option C | Automatically registers the database with Oracle Restart.
|
| Option D | Helps you to easily upgrade the database from a prior release.
|
| Option E | Enables the Installation of Grid Infrastructure files on block or raw devices.
|
| Correct Answer | A,C |
Explanation Explanation: C: To use Oracle ASM or Oracle Restart, you must first install Oracle Grid Infrastructure for a standalone server before you install and create the database. Otherwise, you must manually register the database with Oracle Restart. Desupport of Block and Raw Devices With the release of Oracle Database 11g release 2 (11.2) and Oracle RAC 11g release 2 (11.2), using Database Configuration Assistant or the installer to store Oracle Clusterware or Oracle Database files directly on block or raw devices is not supported. If you intend to upgrade an existing Oracle RAC database, or an Oracle RAC database with Oracle ASM instances, then you can use an existing raw or block device partition, and perform a rolling upgrade of your existing installation. Performing a new installation using block or raw devices is not allowed. Reference: Oracle Grid Infrastructure for a Standalone Server, Oracle Database, Installation Guide, 12c