Oracle Database 11g: New Features for 9i OCPs - 1Z0-055 Exam Questions [2026]

QUESTION NO: 1
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. No special setup is required, and the feature is enabled by default. B. The database must be running in ARCHIVELOG mode. C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter. D. 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. E. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.

Correct Answer: D

QUESTION NO: 2
Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

A. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt, or inconsistent. B. Health Monitor checks are always initiated manually when there is some critical error. C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically. D. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.

Correct Answer: A,D

QUESTION NO: 3
Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

A. Supplemental log must be enabled. B. Undo retention guarantee for the database must be configured. C. Supplemental log must be enabled for the primary key. D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

Correct Answer: A,C,D

QUESTION NO: 4
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?

A. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation. B. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation. C. The EMPLOYEES table will be changed to read-only mode during the shrink operation. D. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

Correct Answer: B

QUESTION NO: 5
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

A. You can add SQL test cases to the incident package. B. You cannot create an incremental incident package when the physical files are purged from the ADR. C. You can add or remove the trace files to the package. D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

Correct Answer: A,C,D

QUESTION NO: 6
Which three actions are required to configure the Flashback Database? (Choose three.)

A. create FLASHBACK tablespace B. start the database in the NOARCHIVELOG mode C. enable Flashback logging D. set Flash Recovery Area E. start the database in the ARCHIVELOG mode

Correct Answer: C,D,E

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

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

Correct Answer: C

QUESTION NO: 8
Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

A. The plans can be manually loaded to the SQL plan baseline. B. The plans in the SQL plan baseline are verified and accepted plans. C. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online. D. The plans generated for every SQL statement are stored in the SQL plan baseline by default. E. The plan baselines are stored temporarily in the memory as long as the database instance is running.

Correct Answer: A,B,C

QUESTION NO: 9
In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.
You issued the following command:
SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt)
FROM sales
GROUP BY sale_category;
Where would the result of this query be stored?

A. PGA B. shared pool C. database buffer cache D. large pool

Correct Answer: B

QUESTION NO: 10
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. statistics recommendations B. restructuring of SQL recommendations C. index-related recommendations D. SQL profile recommendations

Correct Answer: D

QUESTION NO: 11
Which two statements are true regarding hot patching? (Choose two.)

A. It does not require database instance shutdown. B. It can detect conflicts between two online patches. C. It is available for installing all patches on all platforms. D. It works only in a single database instance environment. E. It requires relinking of the Oracle binary.

Correct Answer: A,B

QUESTION NO: 12
Evaluate the following command and its output:
SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

A. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated. B. FREE_SPACE indicates only the space that is currently unallocated. C. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse. D. ALLOCATED_SPACE indicates only the space currently allocated and in use. E. FREE_SPACE indicates only the space that is currently allocated and available for reuse.

Correct Answer: A,C

QUESTION NO: 13
What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?

A. It improves resync operations. B. It improves performance by reading from a copy of an extent closest to the node. C. This feature enables much faster file opens. D. It improves performance as fewer extent pointers are needed in the shared pool.

Correct Answer: B

QUESTION NO: 14
View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?

A. increasing the value of SGA_MAX_SIZE B. setting the PRE_PAGE_SGA parameter to TRUE C. automatic memory management D. locking the SGA in memory

Correct Answer: C

QUESTION NO: 15
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

A. An Oracle base should have only one Oracle home created in it. B. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup. C. Flash recovery area and data file location should be on separate disks. D. ORACLE_BASE should be set explicitly.

Correct Answer: B,C,D