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

Exam Code/Number: 1z0-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: May 26, 2026

Question #1

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

A. They can be created for a PDB when connected to either the PDB or to the root

B. They require backups to be restored when used in a PDB flashback operation

C. They can be created only for a PDB in the mount state

D. They are created as guaranteed restore points

E. They can be created only if shared undo is enabled

F. They require a clone instance to be created when used in a PDB flashback operation

Discussion 0

Correct Answer: C,E Vote an answer

Question #2

You plan to execute this command:

Which statement is true and why?

A. It returns an error because only a single column key can be used for a list-partitioned table.

B. It returns an error because the AUTOMATIC option must be specified.

C. It creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys.

D. It creates partitions P1 and P2 where COUNTRY is a single column partition key and CHANNEL is a subpartition key.

E. It returns an error because only one set of multiple values can be specified for each partition.

Discussion 0

Correct Answer: C Vote an answer

Question #3

A CDB, CDB1, has a LOCATIONS application container.
NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS.
Both application PDBs are synchronized with the application installed in the LOCATIONS root...
In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root.
You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2.
How can you do this?

A. by using private database links created in CDB1 and CDB2

B. by creating a proxy PDB in CDB1 root, referencing LOC_R

C. by creating a proxy PDB in CDB2 root, referencing LOC_R

D. by creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R

E. by using public database links created in CDB1 and CDB2

Discussion 0

Correct Answer: C Vote an answer

Question #4

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It generates execution plans for each SQL statement in an STS.

B. It always executes triggers that are fired recursively in FULLDML mode.

C. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).

D. It recommends the creation of indexes for regressed SQL statements.

E. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #5

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.
When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

A. CUST_RECORDS table in Murdok's schema

B. CUST_RECORDS table in the schema of Bixby and Rlayton

C. CUST_RECORDS table in Bixby's schema

D. CUST_RECORDS table in Rlayton's schema

E. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

Discussion 0

Correct Answer: D Vote an answer

Question #6

Identify two operations for which the bkup_api utility can be used. (Choose two.)

A. to define the cycle period for backups

B. to define which database configuration files are backed up

C. to define the frequency of automatic backups

D. to define the retention period for backups

E. to define which system files are backed up

Discussion 0

Correct Answer: A,D Vote an answer

Question #7

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

A. materialized views

B. any SYS owned objects

C. index-organized tables

D. clustered tables

E. subpartitions

F. heap tables

Discussion 0

Correct Answer: A,E,F Vote an answer

Question #8

While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command is executed to back up the files in a compatible format:

What will be the outcome?

A. It successfully completes.

B. The backup fails because the UNPLUG operation for cross-endian platforms is not supported.

C. It creates a backupset of the source database in the /home/oracle/backup directory

D. It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

E. It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.

Discussion 0

Correct Answer: C Vote an answer

Download Free Oracle 1z0-074 Demo

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