Free Oracle 1z0-074 Exam Dumps Questions & Answers


Exam Code/Number:	1z0-074Join the discussion
Exam Name:	Upgrade Oracle DBA 11g or 12c to 12c R2
Certification:	Oracle
Free Question Number:	75
Publish Date:	Aug 13, 2026
# of views:	4430
Rating 100%

Page: 1 / 15
Total 75 questions

Question 1

Examine these commands executed in the cdb1 container database:

Which statement is true about the c##USER1 account?

A.It is locked for 90 minutes after four failed login attempts.
B.It is locked for two days after the password expires.
C.It is locked if the password is not changed within three weeks.
D.It is locked after for consecutive failed login attempts.
E.It is not affected by the profile because the user has the SYSDBA privilege.

Question 2

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A.sessions that are not blocking other sessions
B.UNDO quota for a consumer group
C.maximum number of DML operations performed by a consumer group
D.number of parallel queries issued by a consumer group
E.sessions that are blocking other sessions

Question 3

Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

A.subpartitions
B.index-organized tables
C.materialized views
D.any SYS owned objects
E.clustered tables
F.heap tables

Question 4

Which statement is true about the Automatic Diagnostic Repository (ADR)?

A.The retention period for the ADR is set based on the space limit specified.
B.When the ADR reaches the space limit, it deletes incident dumps and metadata before deleting old core dumps.
C.Space used by the ADR can be limited to a user-specified value.
D.Space used by the ADR is limited based only on the retention period.
E.Manual purging of all types of ADR files is allowed.

Question 5

The ORCL CDB has a PDB, ORCL_PDB.
Examine these parameters in ORCL:

Examine these parameters in ORCL_PDB:

You switch to ORCL_PDB and plan to execute these commands:

What will be the outcome?

A.Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.SGA_TARGET size is changed to 600 M.
B.SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD
C.SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to
200M in ORCL.
D.Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.
E.SGA_TARGET is set to 600M.The other values remain unchanged in both ORCL and ORCL_PDB.