Oracle 1Z0-001 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Introduction to Oracle: SQL and PL/SQL |
| Exam Number: | 1Z0-001 |
| Exam Duration: | 90-120 |
| Passing Score: | 70% |
| Available Languages: | Japanese, English |
| Exam Format: | Multiple Choice, Multiple Answer, Single Answer |
| Real Exam Qty: | 57-171 |
| Certificate Validity Period: | Lifetime (retired exam) |
| Related Certifications: | Oracle 9i Internet Application Developer Certified Professional |
| Exam Price: | $125-$165 USD |
| Recommended Training: | Oracle University - Introduction to Oracle9i: SQL |
| Exam Registration: | Oracle Discontinued Exams |
| Sample Questions: | Oracle 1Z0-001 Sample Questions |
| Exam Way: | Proctored at authorized test centers (Prometric / Pearson VUE) before retirement; no longer available |
| Pre Condition: | Basic understanding of relational databases and Oracle concepts; no formal prerequisites |
| Official Syllabus URL: | https://www.oracle.com/education/certification/discontinued-exams/ |
Oracle 1Z0-001 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Data Manipulation and Definition Language | 15% | - INSERT, UPDATE, DELETE statements - CREATE, ALTER, DROP tables and constraints |
| Retrieving Data Using SQL SELECT | 15% | - SELECT statement syntax - Restricting and sorting data |
| Using Single-Row and Group Functions | 15% | - Aggregate functions and grouping - Character, number, and date functions |
| Displaying Data from Multiple Tables | 15% | - Equijoins and non-equijoins - Outer joins and self joins |
| Relational Database Concepts | 10% | - Entity-Relationship modeling - Relational model and database objects |
| Introduction to PL/SQL | 10% | - Variables, control structures, cursors, exceptions - PL/SQL block structure |
| Subqueries and Set Operators | 10% | - Single-row and multi-row subqueries - UNION, UNION ALL, INTERSECT, MINUS |
| Database Objects and Security | 10% | - Views, indexes, sequences, synonyms - Privileges, roles, and user management |
We're so confident of our products that we provide no hassle product exchange.


By Roderick

