Oracle 1z1-074 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-074
Exam Name/Title: Upgrade Oracle DBA 11g or 12c to 12c R2
Certification Provider: Oracle
Corresponding Certification: Oracle Database 12c R2

Exam Questions: 75
Updated On: Jul 05, 2026

Question #1

Examine these statements:

Which statement is true?

A. Statements 2 and 3 will validate the conversion

B. All the statements will validate the conversion

C. Only statement 1 will validate the conversion

D. Statement 1 will return an error

E. Only statement 3 will validate the conversion

Discussion 0

Correct Answer: B Vote an answer

Question #2

Which statement is true about transportable tablespaces?

A. The source tablespace can be encrypted

B. The cannot be dictionary-managed tablespaces

C. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.

D. They can be administrative tablespaces such as SYSTEM or SYSAUX

Discussion 0

Correct Answer: C Vote an answer

Question #3

Identify a situation where performance profiles can be used for application containers.

A. to enforce a limit on I/O throughput per second

B. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out

C. to enforce a limit on the number of I/OS issued per second

D. to specify the total number of parallel execution servers available

E. to specify the maximum percentage of the parallel execution server pool that a particular application container can use

Discussion 0

Correct Answer: D Vote an answer

Question #4

You receive complaints about poor performance in an Oracle 12c database while long running queries execute.
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution.
How would you achieve this?

A. by running the Automatic Workload Repository (AWR) report for that time period

B. by enabling tracing for sessions that run these queries

C. by viewing Active Reports for that time period

D. by running the Active Session History (ASH) report for that time period

E. by enabling SQL trace for each query

Discussion 0

Correct Answer: B Vote an answer

Question #5

Examine this parameter:

Examine these commands:

Which three are true after executing these commands? (Choose three.)

A. Only repeatable statements executed by SYS and SH are considered for baselines.

B. Only statements executed by SYS are captured and included in a baseline.

C. Statements executed by both SH and SYS may be captured and included in a baseline.

D. Only statements executed by SH containing the "TEST_ONLY" string are excluded from capture.

E. All statements executed by SH are captured and included in a baseline.

F. Statements executed by any user containing the "TEST_ONLY" string are excluded from capture.

Discussion 0

Correct Answer: A,E,F Vote an answer

Question #6

From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)

A. loss of all copies of the control file

B. loss of a noncritical data file

C. loss of a critical data file such as SYSTEM, SYSAUX or UNDO

D. loss of SPFILE

E. loss of ARCHIVELOGS

F. loss of a redo log member

Discussion 0

Correct Answer: A,C Vote an answer

Question #7

In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?

A. when a user queries a BEQUEATH CURRENT_USER view that references an invoker's right procedure

B. when a user runs a procedure created with invoker's right

C. when a user performs a GRANT or REVOKE operation

D. when a user creates a new user

E. when a user runs a procedure created with definer's right

Discussion 0

Correct Answer: A,B Vote an answer

Question #8

In your database, DEFERRED_SEGMENT_CREATION is set to TRUE.
You successfully execute this command:

Which statement is true about the space allocated to the SALES_2016 table?

A. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.

B. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.

C. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.

D. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.

E. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.

Discussion 0

Correct Answer: D Vote an answer

Download Free Oracle 1z1-074 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-074 exam.