How to Prepare for 1Z0-062 Exam on Oracle Database 12c - Administration Certification?

Oracle Database 12c - Administration (1Z0-062) preparation guide helps you to get focused on the exam. This guide also helps you to be on the 1Z0-062 exam track to get certified with a good score in the final exam.

1Z0-062 Oracle Database 12c - Administration Exam Summary

Exam Name	Oracle Database 12c - Administration
Exam Code	1Z0-062
Exam Product Version	Oracle Database 12.1
Exam Price	USD $245 (Price may vary by country or by localized currency)
Duration	120 minutes
Number of Questions	67
Passing Score	64%
Format	Multiple Choice Questions (MCQ)
Recommended Training	Oracle Database 12c: Administration Workshop Oracle Database Administration Learning Subscription Unlimited Product Learning Subscription
Schedule Exam	Pearson VUE
Sample Questions	Oracle Database 12c Administrator Certified Associate (OCA)
Recommended Practice	1Z0-062 Online Practice Exam

Exam Syllabus: 1Z0-062 Oracle Database 12c - Administration

 

Subjects	Sub Topics
Exploring the Oracle Database Architecture	- List the architectural components of Oracle Database - Explain the memory structures - Describe the background processes
Oracle Database Management Tools	- Use database management tools
Oracle Database Instance	- Understand initialization parameter files - Start up and shut down an Oracle database instance - View the alert log and access dynamic performance views
Configuring the Oracle Network Environment	- Configure Oracle Net Services - Use tools for configuring and managing the Oracle network - Configure client-side network - Configure communication between databases
Administering User Security	- Create and manage database user accounts - Grant and revoke privileges - Create and manage roles - Create and manage profiles
Managing Database Storage Structures	- Describe the storage of table row data in blocks - Create and manage tablespaces
Create and manage tablespaces	- Explain how Oracle database server automatically manages space - Save space by using compression - Use the Segment Advisor - Reclaim wasted space from tables and indexes by using the segment shrink functionality
Managing Undo Data	- Explain DML and undo data generation - Monitor and administer undo data - Describe the difference between undo data and redo data - Configure undo retention
Managing Data Concurrency	- Describe the locking mechanism and how Oracle manages data concurrency - Monitor and resolve locking conflicts
Implementing Oracle Database Auditing	- Enable standard database auditing and unified auditing
Backup and Recovery Concepts	- Identify the importance of checkpoints, redo log files, and archive log files
Backup and Recovery Configuration	- Configure the fast recovery area - Configure ARCHIVELOG mode
Performing Database Backups	- Create consistent database backups - Back up your database without shutting it down - Create incremental backups - Automate database backups - Manage backups
Performing Database Recovery	- Determine the need for performing recovery - Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file
Moving Data	- Describe ways to move data - Use SQL*Loader to load data from a non-Oracle database - Use external tables to move data via platform-independent files - Explain the general architecture of Oracle Data Pump - Use Data Pump Export and Import to move data between Oracle databases
Performing Database Maintenance	- Use server-generated alerts
Managing Performance: SQL Tuning	- Use the SQL Tuning advisor
Automating Tasks by Using Oracle Scheduler	- Use Oracle Scheduler to simplify management tasks - Use job chains to perform a series of related tasks - Use Scheduler jobs on remote systems - Use advanced Scheduler features to prioritize jobs
Creating an Oracle Database Using DBCA	- Generate database creation scripts by using DBCA - Manage database design templates by using DBCA
Upgrading Oracle Database Software	- Describe data migration methods - Describe the upgrade process
Introduction to DBAAS	- Recognize the difference between a DBaaS Instance and a Database Instance - Navigate with My Services Dashboard - User authentication and roles - Generate a Secure Shell (SSH) Public/Private Key Pair

Oracle 1Z0-062 Certification Sample Questions and Answers

To make you familiar with Oracle Database 12c - Administration (1Z0-062) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for Oracle OCA 1Z0-062 Certification to test your understanding of the Oracle 1Z0-062 process with the real Oracle certification exam environment.

1Z0-062 Oracle Database 12c - Administration Sample Questions

01. Is it possible for the unified audit trail to lose audit records?

a) The unified audit trail is always protected in all circumstances.

b) Records cannot be lost, but they can be deleted or modified with DML commands.

c) The audit trail is protected against DML, but DDL (such as TRUNCATE) can lose records.

d) It is possible for records to be lost in the event of an instance failure.

 

02. Which statement is true about the Log Writer process?

a) It writes when it receives a signal from the checkpoint process (CKPT).

b) It writes concurrently to all members of multiplexed redo log groups.

c) It writes after the Database Writer process writes dirty buffers to disk.

d) It writes when a user commits a transaction.

 

03. Which three factors influence the optimizer's choice of an execution plan?

a) the optimizer_mode initialization parameter

b) operating system (OS) statistics

c) cardinality estimates

d) object statistics in the data dictionary

e) fixed baselines

 

04. You want to start up the database using a binary initialization file. What is another name for this file?

a) Configfile

b) Pfile

c) Spfile

d) init_pfile.ora

 

05. A consumer group object can be assigned to which of the following?

a) A plan

b) A subplan

c) A consumer group

d) None of the above

 

06. By default, how long will database statistics be retained in the AWR?

a) 8 days

b) 30 days

c) 7 hours

d) Indefinitely

 

07. You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: Applications will connect to the database via a middle tier.

The number of concurrent user connections will be high. The database will have mixed workload, with the execution of complex BI queries scheduled at night.

Which DBCA option must you choose to create the database?

a) a default database configuration

b) a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

c) a Data Warehouse database template, with the dedicated server mode option and AMM enabled

d) a General Purpose database template with default memory allocation

 

08. Which two tasks can be performed on an external table?

a) partitioning the table

b) creating an invisible index

c) updating the table by using an update statement

d) creating a public synonym

e) creating a view

 

09. What is the smallest unit of storage in an ASM disk group?

a) Database block

b) OS block

c) Allocation unit

d) Smallest disk in the disk group

 

10. How can a table space be made larger?

a) Convert it from a SMALLFILE tablespace to a BIGFILE tablespace.

b) If it is a SMALLFILE tablespace, add files.

c) If it is a BIGFILE tablespace, add more files.

d) Resize the existing file(s).

 

Solution:

QUESTION: 01 Answer: d	QUESTION: 02 Answer: d	QUESTION: 03 Answer: a, c, d	QUESTION: 04 Answer: c	QUESTION: 05 Answer: a, b
QUESTION: 06 Answer: a	QUESTION: 07 Answer: b	QUESTION: 08 Answer: d, e	QUESTION: 09 Answer: c	QUESTION: 10 Answer: b, d

How to Register for 1Z0-062 Oracle Database 12c - Administration Exam?

• Purchase exam voucher from Oracle University
• Register for an exam at PearsonVue.