Oracle

12c 1Z0-060 Upgrade to Oracle Database 12c 1Z0-060

Use original educational practice content, randomized simulator sessions, score history and explanation review for 12c 1Z0-060.

Start Practice Test View Premium Plans

Practice questions are provided in English to match the language commonly used in IT certification exams.

QZ9 is an independent training platform. All practice questions are original and created for educational purposes only. We do not provide unauthorized vendor exam content. Microsoft, AWS, Cisco, CompTIA, PMI and other trademarks belong to their respective owners.

VendorOracle

Code12c 1Z0-060

Duration120 minutes

Questions63 refs

Exam facts

Objective-based preparation without unauthorized content

Certification metadata is preserved from the legacy QZ9 catalog. Questions remain English-only.

Start Practice Test

1Find your exam

2Start the simulator

3Review results

QZ9Independent training platform

Free question preview

Exam simulator

Practice questions are provided in English to match the language commonly used in IT certification exams.

Question 1

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?

Question 2

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

Question 3

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA. DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupteD. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

Question 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?

Question 5

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?