Exam Code: 1z0-060 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Upgrade to Oracle Database 12c
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1z0-060 Exam.

2021 Jun 1z0-060 Study Guide Questions:

Q91. Identify two situations in which the alert log file is updated. 

A. Running a query on a table returns ORA-600: Internal Error.

B. Inserting a value into a table returns ORA-01722: invalid number.

C. Creating a table returns ORA-00955: name us already in used by an existing objects.

D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated. 

E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

Answer: AE

Q92. On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:

$> sqlldr hr/hr@pdb table=employees

Which two statements are true regarding the command?

A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

B. It fails because no SQL *Loader data file location is specified. 

C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

D. It fails because no SQL *Loader control file location is specified. 

Answer: AC 

Q93. You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.

What are two effects of not using the "ENABLE PLUGGABLE database" clause?

A. The database is created as a non-CDB and can never contain a PDB. 

B. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).

C. The database is created as a non-CDB and can never be plugged into a CDB. 

D. The database is created as a non-CDB but can be plugged into an existing CDB. 

E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

Answer: AD


Refresh amazon 1z0-060:

Q94. Identify three benefits of Unified Auditing.

A. Decreased use of storage to store audit trail rows in the database.

B. It improves overall auditing performance.

C. It guarantees zero-loss auditing.

D. The audit trail cannot be easily modified because it is read-only.

E. It automatically audits Recovery Manager (RMAN) events.

Answer: BDE

Q95. To enable the Database Smart Flash Cache, you configure the following parameters:

DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ 


What is the result when you start up the database instance?

A. It results in an error because these parameter settings are invalid. 

B. One 64G flash cache file will be used. 

C. Two 64G flash cache files will be used. 

D. Two 32G flash cache files will be used. 

Answer: A

Q96. Which three statements are true about SQL plan directives?

A. They are tied to a specific statement or SQL ID. 

B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

C. They are used to gather only missing statistics.

D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

E. They instruct the optimizer to create only column group statistics.

F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Answer: BDF


Download 1z0-060 pdf:

Q97. You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12C. 

Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A. The valid time columns employee_time_start and employee_time_end are automatically created. 

B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C. The valid time columns are not populated by the Oracle Server automatically.

D. The valid time columns are visible by default when the table is described. 

E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABE

Q98. Which two statements are true about the Oracle Direct Network File system (DNFS)?

A. It utilizes the OS file system cache.

B. A traditional NFS mount is not required when using Direct NFS.

C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.

D. Direct NFS is available only in UNIX platforms.

E. Direct NFS can load-balance I/O traffic across multiple network adapters.

Answer: CE

Q99. Your multitenant container database (CDB) contains a pluggable database, HR_PDB.  The default permanent tablespace in HR_PDB is USERDATA.  The container database (CDB) is open and you connect RMAN.

You want to issue the following RMAN command: 

RMAN > BACKUP TABLESPACE hr_pdb:userdata;

Which task should you perform before issuing the command?

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.

Answer: A

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

A. Bind Variable Peeking

B. SQL Plan Baselines

C. Adaptive Cursor Sharing

D. Bind variable used in a SQL statement

E. Literals in a SQL statement

Answer: ACE