Free Oracle 1Z0-055 Exam Dumps Questions & Answers

Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

• A.  set SHARED_POOL_SIZE to zero
• B.  set SGA_TARGET to a non-zero value
• C.  set STATISTICS_LEVEL to TYPICAL or ALL
• D.  set STATISTICS_LEVEL to BASIC
• E.  set DB_CACHE_SIZE to a non-zero value

In which two aspects does hot patching differ from conventional patching? (Choose two.)

• A.  It does not require down time to apply or remove unlike conventional patching.
• B.  It can be installed and uninstalled via OPatch unlike conventional patching.
• C.  It is not persistent across instance startup and shutdown unlike conventional patching.
• D.  It consumes more memory compared with conventional patching.
• E.  It takes more time to install or uninstall compared with conventional patching.

View the Exhibit to examine the details for an incident.
Which statement is true regarding the status of the incident?

• A.  The incident has been newly created and is in the process of collecting diagnostic information.
• B.  The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.
• C.  The DBA is working on the incident and prefers that the incident be kept in the ADR.
• D.  The incident is now in the Done state and the ADR can select the incident to be purged.

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

• A.  index-related recommendations
• B.  SQL profile recommendations
• C.  statistics recommendations
• D.  restructuring of SQL recommendations

Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

• A.  The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
• B.  The database must be running in ARCHIVELOG mode.
• C.  Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
• D.  No special setup is required, and the feature is enabled by default.
• E.  The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.