Free Oracle 1z1-034 Exam Dumps Questions & Answers


Exam Code/Number:	1z1-034Join the discussion
Exam Name:	Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Certification:	Oracle
Free Question Number:	148
Publish Date:	Aug 04, 2026
# of views:	2615
Rating 100%

Page: 1 / 30
Total 148 questions

Question 1

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

A.Nested plans control only the degree of parallelism and I/O requests
B.Nested plans only control resources used by recursive SQL
C.The plans can be nested up to four levels.
D.Each nested plan gets a proportion of the CPU resources assigned to its parent group.
E.Only one nested subplan is allowed per parent plan

Question 2

Which data dictionary view would you query to find the name of the default permanent tablespace of the database?

A.DBA_STORED_SETTINGS
B.DBA_DIRECTORIES
C.DICTIONARY
D.DBA_TABLESPACE_GROUPS
E.DATABASE_PROPERTIES
F.DBA_TABLESPACES

Question 3

You executed the following command In Recovery Manager {RMAN):
RMAN>REPORTNEEDBACKUPdays 3;
What is the output of this command?

A.a list of files that require a backup within three days
B.a list of files for which a backup has already been performed in the last three days and which is required tobe backed up again based on the high number of transactions performed on them
C.a list of files requiring more than 3 days of archive logs to apply
D.a list of files that RMAN recommends be backed up only once in every three days, based on low volatility

Question 4

View the Exhibit to observe the error.

You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance.
What can you do to reduce the chance of this error in the future?

A.Enable automatic memory management
B.Increase the value of SGA_MAX_SIZE
C.Set the PRE_PAGE_SGA parameter to true
D.Lock the System Global Area (SGA) in memory

Question 5

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.
One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?

A.You should switch the database to the NOARCHIVELOG mode
B.You should make a backup of the database
C.You should shut down the database instance and perform a complete database recovery
D.You should perform a log switch