Certification overview
The
Oracle Certified Associate (OCA) Database 12c certification is
uniquely designed for applicants having advanced knowledge as well as
innovative skills in database administration. The Database 12c by
Oracle emphasis on complete set of required skills that may be
required by DBA in today's world's competitive marketplace. The
Database 12c exam by Oracle validates your capabilities by making use
of scenario-based problems that challenges and assesses candidate's
abilities to perform and think.
Who
can do this certification?
The
Oracle Certified Associate (OCA) Database 12c certification is
targeted to audience who have done advanced training and years of
practice in database administration. Audience must have practice in
recovery, cloud computing strategies, deployment and development of
backup. The Database 12c certification by Adobe assesses the utmost
important skills that a database administrator may need for
maintenance and management of database. This certification targets
warehouse administrator, database administrators, technical
administrators, support engineers, and database designers.
The
Database 12c certification by Adobe is the most challenging and elite
certification which certifies the highly skilled and trained database
professionals. The Database 12c certification broadens your skills
and knowledge by revealing you a wide range of important database
functions, tasks and features. The Database 12c certification teaches
you various activities via labs and enables you to manage critical
tasks.
Associated
Exam
For
obtainingDatabase 12c certification, you need to pass SQL exam first.
SQL exam may be of three types. You will be provided with 120 minutes
and 75 questions to clear the SQL exam with minimum passing score
being 65%. After passing SQL exam, you need to pass the Database 12c
Installation and Administration exam. You will be provided with 150
minutes and 95 questions to clear the SQL exam with minimum passing
score being 67%.For exam preparation, Oracle also provides training
courses.
Tobecome
Database 12c expert, candidates must advance in years of practice in
database administration. Candidates must have exercise in recovery,
cloud computing strategies, deployment and development of backup. The
Database 12c certification by Adobe assesses the utmost important
skills that a database administrator may need for maintenance and
management of database. The Database 12c certificates targets
warehouse administrator, database administrators, technical
administrators, support engineers, and database designers.
Examination
Overview
The
Database 12c topics are:
-
Introduction:
It includes course schedule, course objectives and understanding
Oracle cloud.
-
Oracle
Software Installation Basics: It includes installation options,
environment variables, planning installation and understanding
operating system users and groups.
-
Exploring
the Oracle Database Architecture: It includes process structures,
Oracle database configurations, and process architecture and process
sequences.
-
Installing
Oracle Database Software: It includes installation types, creation
of operating system users and groups, and system requirements needed
for database.
-
Creating
an Oracle Database by Using DBCA: It includes database types, using
DBCA, setting NLS_LANG parameters, and choosing suitable character
set.
-
Managing
the Database Instance: It includes data dictionary and viewing trace
and log files.
-
Oracle
Database Management Tools: It includes cloud manager controls,
understanding cloud framework and SQL developer.
-
Administering
User security: It includes profiles, privileges, roles and creating
users.
-
Configuring
the Oracle Network Environment: It includes connecting to server and
using control utilities.
-
Managing
Performance SQL Tuning: It includes SQL advisors and plan directives
Managing Database Storage Structures: It includes managing
tablespaces and exploring storage structure.
-
Managing
undo data: It includes managing undo and storing information related
to undo.
-
Managing
Performance: It includes managing memory and instance tuning.
-
Managing
space: It includes allocating extents and row migration and
chaining.
-
Managing
data concurrency: It includes lock conflicts and DML locks.
-
Implementing
Oracle Database Auditing: It includes database security and
configuring Audit trail.
-
Backup
and Recovery Concepts: It includes flashback technology and using
MTTR Advisor.
-
Backup
and Recovery Configuration: It includes archiver process and
multiplexing control files.
-
Performing
Database Backups: It includes configuring settings related to backup
and backup terminology Performing Database Recovery: It includes
loss of control file and loss of redo file.
-
Moving
Data: It includes external tables and SQL Loader.
-
Performing
Database Maintenance: It includes statistic levels and Advisory
Framework.
Validity
of the Certification
The
Database 12c certification is valid for lifetime. You can use this
certification as long as you want. This certificate will never
expire.
Steps
involved in the certification
For
Database 12c certification, follow these steps:
-
Gain
knowledge of objective of exam.
-
Gain
knowledge of subjects covered in exam.
-
Register
and Pass the SQL exam.
-
Register
for Database 12c Administration exam.
-
Pass
the Database 12c Administration exam.
Expert
Review
The
Database 12c certification gave me an opportunity to work on higher
levels and proved my expertise in database administration.
Devraj
Singh, DBA, Logica.
Punjab,
India
