Free Oracle 1Z1-060 Exam Dumps Questions & Answers


Exam Code/Number:	1Z1-060Join the discussion
Exam Name:	Upgrade to Oracle Database 12c
Certification:	Oracle
Free Question Number:	205
Publish Date:	Sep 30, 2026
# of views:	3165
Rating 100%

Page: 1 / 41
Total 205 questions

Question 1

Which three statements are true concerning the multitenant architecture?

A.A PDB can have a private temp tablespace.
B.Different PDBs can have different default block sizes.
C.PDBs share a common system tablespace.
D.PDBs can share the sysaux tablespace.
E.Log switches occur only at the multitenant container database (CDB) level.
F.Instance recovery is always performed at the CDB level.
G.Each pluggable database (PDB) has its own set of background processes.

Question 2

You issue the following command to alter the country column in the departments table:

Which statement is true?

A.It produces an error because column definitions cannot be altered to add default values.
B.It produces an error because the data type for the column is not specified.
C.It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'.
D.It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table.

Question 3

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?

A.Adaptive Cursor Sharing
B.Literals in aSQL statement
C.Bind Variable Peeking
D.SQL Plan Baselines
E.Bind variable used in a SQL statement

Question 4

Which two statements are true about Oracle Direct Network File System (NFS)?

A.Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O commands over any remaining paths.
B.It utilizes the operating system file system cache.
C.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.
D.Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the Direct NFS client.
E.Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.

Question 5

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?

A.RMAN CONVERT command
B.Conventional Export and Import
C.DBMS_FILE_TRANSFER with transportable tablespace
D.The BACKUP AS COPY DATABASE . . . command of RMAN
E.Data Pump Export and import