Oracle Upgrade to Oracle Database 12c - 1Z0-060 Exam Questions [2026]

QUESTION NO: 1
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

A. SQL Performance Analyzer B. SQL Access Advisor C. SQL Tuning Advisor D. Database replay E. Automatic Workload Repository compare reports

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

A. A DBAcancheck specific tables with the DMU B. The DMU can report columns that are not represented in the converted characterset. C. The release of the database to be converted can be any release since 9.2.0.8. D. The DMU can report columns that are too long in the converted characterset. E. The database to be migrated must be opened read-only.

Correct Answer: A,B,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
Your database uses Automatic Memory Management, and has the large pool configured.
You issue the following command:
SQL> ALTER SYSTEM SET SHARED_SERVERS = 5;
Which statement is true about the shared server configuration?

A. It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured. B. It is enabled and all the DBA and non-DBA sessions function in shared server mode. C. It is enabled and the UGA is located in the large pool for connections that use the shared server configuration. D. It is enabled only if at least five dispatchers are configured.

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?

A. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows. B. It may advise the use of online table redefinition for tables in dictionary managed tablespace. C. It will detect and advise about chained rows. D. It may advise the use of segment shrink for free list managed tables. E. It may advise the use of online table redefinition for tables in locally managed tablespaces

Correct Answer: B,C,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.

A. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter B. Missing or stale histogram statistics C. Undersized shared pool D. High clustering factor for the indexes E. Oversized buffer cache

Correct Answer: A,B,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file?

A. It contains usernames and passwords of database users who are members of the OSDBA operating system group. B. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role. C. It contains username and passwords of database users who are members of the OSOPER operating system group. D. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role. E. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

Correct Answer: D,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 7
In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

A. It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT module is used.
PAYABLE B. It always captures the use of the CREATE VIEW and CREATE TABLE privileges. C. It captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when the module is used.
ACCOUNT PAYABLE D. It always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN roles.

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 8
Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?

A. alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode character set B. alphanumeric columns that need conversion to a different binary representation before converging to the chosen Unicode character set C. numeric columns that will have invalid binary representation after converting to the chosen Unicode character set D. date columns that will have invalid binary representation after converting to the chosen Unicode character set E. alphanumeric columns that need no conversion F. numeric columns that will exceed the column size limit after converting to the chosen Unicode character set

Correct Answer: A,C,D

QUESTION NO: 9
Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database.

A. Create a SYSMAN user with the SYSDBA role as an administrator for EM express. B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure port number 5500 for the HTTP server. C. Install the Oracle HTTP Server. D. Configure the DISPATCHERS initialization parameter such that at least one dispatcher is configured for the XMLDB service with the TCP protocol.

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 10
Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically. B. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE. C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET. D. It succeeds only if memory is available from the autotuned components if SGA.

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 11
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

A. Improved Serial Execution performance B. Reduced virtual memory utilization C. Reduced physical I/O D. Reduced logical I/O E. Improved parallel Execution performance F. Reduced CPU utilization

Correct Answer: B,E,F

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 12
Which two statements are true about Oracle Direct Network File System (NFS)?

A. Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the Direct NFS client. B. Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/. C. Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O commands over any remaining paths. D. The Oracle database files available on the NFS server that are served by the Direct NFS Client cannot be accessed through the operating system kernel NFS. E. It utilizes the operating system file system cache.

Correct Answer: A,C

QUESTION NO: 13
The tnsnames.ora file has an entry for the service alias ORCL as follows:

The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?

A. The listener is running on a different port. B. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file. C. The listener is not running on the database node. D. The orcl.oracle.com database service is not registered with the listener. E. The TNS_ADMIN environment variable is set to the wrong value.

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 14
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

A. You can connect by using a Net Service name. B. You can connect by using OS authentication. C. You can connect as a local user by using the SET CONTAINER statement. D. You can conned as a common user by using the connect statement. E. You can connect as a local user by using the connect statement. F. You can connect by using easy connect.

Correct Answer: A,B,D,F

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 15
Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c?
(Choose two.)

A. You cannot start up or shut down a database instance by using EM express. B. You can perform basic administrative tasks for pluggable databases by using the EM express interface. C. Multiple databases on the same node (or host) may each be individually managed by using EM Express. D. You can create and configure pluggable databases by using EM express. E. By default, EM express is available for a database after database creation.

Correct Answer: A,C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).