Free Oracle 1Z0-055 Exam Dumps Questions & Answers


Exam Code/Number:	1Z0-055Join the discussion
Exam Name:	Oracle Database 11g: New Features for 9i OCPs
Certification:	Oracle
Free Question Number:	297
Publish Date:	Aug 11, 2026
# of views:	2347
Rating 100%

Page: 1 / 60
Total 297 questions

Question 1

You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)

A.The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
B.The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.
C.The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
D.The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

Question 2

Identify the three predefined server-generated alerts. (Choose three.)

A.Drop User
B.Tablespace Space Usage
C.Recovery Area Low On Free Space
D.Resumable Session Suspended
E.SYSTEM Tablespace Size Increment

Question 3

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?

A.Partition the table
B.Drop the table.
C.Rename a column in the table.
D.Add a column to the table.
E.Truncate the table.

Question 4

Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

A.It translates tasks into jobs for execution by the scheduler.
B.It creates jobs without considering the priorities associated with them.
C.It is spawned by the MMON background process at the start of the maintenance window.
D.It determines the list of jobs that must be created for each maintenance window.
E.It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

Question 5

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

A.point-in-time recovery
B.determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
C.execute the ROLLBACK command with transaction number
D.flashback the database to before the transaction was committed