Managing Objects  «Prev  Next»

Lesson 1

Managing Oracle Database Objects

This course is the third of five courses in the Oracle Database Administration Certification Series.

Course Goals

This course focuses on the database structures within an Oracle database. After completing this course, you will be able to
  1. Create tables, indexes, and constraints
  2. Assign appropriate storage specifications for tables, indexes, and constraints
  3. Assign security privileges to all objects within an Oracle database
  4. Use security roles to control access to database objects
  5. Create and manage stored code within an Oracle database

Oracle Certification

This course will prepare you for one of the following Oracle certification exams: The alternative that is offered by the Oracle Company is the 1Z0-071 - Oracle Database SQL exam. There are little bit differences amid these two certification exams.

Question: What’s the immediate substitute for 1Z0-061 and 1Z0-051?
Exam 1Z0-071 can be substituted for all three certification tracks. This exam was previously referred to as Oracle Database 12c SQL , leading to some confusion among those still pursuing an 11g certification path. However, with the retirement of 051, this exam is now simply called the Oracle Database SQL exam. This is the general associate-level Oracle Database SQL exam.

How many certifications to become an Oracle DBA

Question: How many certifications have to be passed in order to become certified as an Oracle database administrator?
You need to pass two exams to become certified as an Oracle Database Administrator (DBA):
  1. Oracle Database Administration I - 1Z0-082
  2. Oracle Database Administration II - 1Z0-083
Once you pass both exams, you will earn the Oracle Database Administration 2019 Certified Professional certification.
This certification is valid for three years. To maintain your certification, you must pass a recertification exam or complete a certain number of continuing education credits (CECs) during that time.

The current Oracle exams to become certified as an Oracle Database Administrator (DBA) are:
  1. Oracle Database Administration I - 1Z0-082
  2. Oracle Database Administration II - 1Z0-083
You must pass both exams to earn the Oracle Database Administration 2019 Certified Professional certification. The 1Z0-082 exam covers the following topics:
  1. SQL programming skills
  2. Database and network administration
  3. Database security
  4. Performance monitoring and troubleshooting
The 1Z0-083 exam covers the following topics:
  1. Installation, upgrades, and patching
  2. Multitenant architecture
  3. Backup and recovery
  4. Advanced SQL performance monitoring and troubleshooting
To prepare for the exams, Oracle recommends that you have at least two years of experience in administering Oracle databases. You can also take Oracle-approved training courses or use self-study materials.
Here are some tips for preparing for the Oracle DBA exams:
  1. Become familiar with the exam objectives. Make sure you understand all of the topics that will be covered on the exams.
  2. Get hands-on experience with Oracle databases. The more experience you have, the better prepared you will be for the exams.
  3. Use a variety of study materials. There are many different resources available to help you prepare for the exams, including books, online courses, and practice exams.
  4. Form a study group. Studying with other people can help you stay motivated and learn from each other.

Exam Number: The following exams are deprecated.
  1. Oracle Database 12c: SQL Fundamentals 1Z0-061 or
  2. Oracle Database 11g: SQL Fundamentals I 1Z0-051 or
  3. Oracle Database SQL Expert 1Z0-047

Exam Product Version: Oracle Database 11g, 12c