Oracle Database 11g: SQL Fundamentals I - OCA
(1Z0-051)
/ ISBN: 9781616911881
This course includes
Lessons
TestPrep
Mentoring (Add-on)
Oracle Database 11g: SQL Fundamentals I - OCA
The Oracle 11g Administrator Certified Associate (OCA) certification is a streamlined, entry-level certification for the database-administration track and is required to advance toward the more senior certification tiers.
Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role.
Lessons
-
7+ Lessons
-
554+ Exercises
-
377+ Quizzes
-
115+ Flashcards
-
115+ Glossary of terms
Test Preps
-
15+ Pre Assessment Questions
-
51+ Post Assessment Questions
- Overview
- SQL Fundamentals
- Writing Simple Queries
- Accepting Values at Runtime
- Summary
- Exam Essentials
- Review Questions
- Overview
- Single-Row Function Fundamentals
- Using Single-Row Character Functions
- Using Single-Row Numeric Functions
- Using Single-Row Date Functions
- Using Single-Row Conversion Functions
- Using Other Single-Row Functions
- Summary
- Exam Essentials
- Review Questions
- Overview
- Group-Function Fundamentals
- Utilizing Aggregate Functions
- Summary
- Exam Essentials
- Review Questions
- Overview
- Writing Multiple-Table Queries
- Using Set Operators
- Subqueries
- Summary
- Exam Essentials
- Review Questions
- Overview
- Using DML Statements
- Understanding Transaction Control
- Summary
- Exam Essentials
- Review Questions
- Overview
- Database Objects Overview
- Built-in Datatypes
- Creating Tables
- Modifying Tables
- Managing Constraints
- Summary
- Exam Essentials
- Review Questions
- Overview
- Creating and Modifying Views
- Creating and Managing Sequences
- Creating and Managing Synonyms
- Creating and Managing Indexes
- Summary
- Exam Essentials
- Review Questions
| What is the exam registration fee? | USD 125 |
|---|---|
| Where do I take the exam? | The 1Z0-051 exam is administered by Pearson VUE at testing centers worldwide. Click here to find a testing center near you. |
| What is the format of the exam? | The exam consists of scenario-based multiple choice questions. |
| What are the pre-requisites of the exam? | While there are no official prerequisites to take the OCA DBA 11g certification, both Oracle and uCertify strongly recommend that the candidates should have a good understanding SQL. |
| How many questions are asked in the exam? | The exam contains 64 questions. |
| What is the duration of the exam? | 120 minutes |
| What is the passing score? | 60% Click here for more information. |
| What is the exam's retake policy? | Retake Policy for Oracle 1Z0-051 exam is:
|
| What is the validity of the certification? | An Oracle's OCA DBA 11g certification has no expiration. The certification holder is certified for life unless Oracle changes their policy. Clickhere for more information. |
| Where can I find more information about this exam? | To know more about the 1Z0-051, click here. |
| Which certification covers this exam? | |
| What are the career opportunities after passing this exam? |
|
×