New versions of the Oracle Introduction to Oracle9i: SQL bank are released periodically after careful review, so the 110 practice questions you download in 2026 reflect the current exam rather than an old snapshot.
Oracle 1Z0-007 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Introduction to Oracle9i: SQL |
| Exam Number: | 1Z0-007 |
| Exam Duration: | 120 minutes |
| Exam Format: | Multiple Choice, Multiple Select |
| Certificate Validity Period: | Retired; perpetual validity if achieved before discontinuation |
| Related Certifications: | Oracle9i DBA OCA Oracle9i DBA OCP |
| Real Exam Qty: | 57 |
| Exam Price: | Approx. $195–$225 USD (historical, varies by region) |
| Available Languages: | Japanese, Spanish, English |
| Passing Score: | 70% (40 out of 57) |
| Recommended Training: | Oracle9i SQL Study Guide Oracle University - Introduction to Oracle9i: SQL |
| Exam Registration: | Pearson VUE (historical) Oracle University (legacy) |
| Sample Questions: | ![]() |
| Exam Way: | In-person at Pearson VUE / Oracle Testing Centers (retired, no longer available) |
| Pre Condition: | None required; recommended basic relational database knowledge |
| Official Syllabus URL: | https://education.oracle.com/ |
Oracle 1Z0-007 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Single-Row Functions | 18% | - Conditional expressions (NVL, DECODE) - Conversion functions (TO_CHAR, TO_NUMBER, TO_DATE) - Character, number, and date functions |
| Topic 2: Displaying Data from Multiple Tables | 15% | - Equijoins and non-equijoins - Outer joins and self-joins - ANSI/ISO SQL99 joins |
| Topic 3: Subqueries | 10% | - Using IN, ANY, ALL operators - Single-row and multi-row subqueries |
| Topic 4: Writing Basic SQL SELECT Statements | 15% | - Capabilities of SQL SELECT statements - SQL vs iSQL*Plus commands - Executing basic SELECT statements |
| Topic 5: Manipulating Data | 8% | - Transaction control (COMMIT, ROLLBACK, SAVEPOINT) - INSERT, UPDATE, DELETE statements |
| Topic 6: Restricting and Sorting Data | 12% | - Limiting rows with WHERE clause - Sorting results with ORDER BY - Using substitution variables |
| Topic 7: Aggregating Data Using Group Functions | 13% | - Using COUNT, SUM, AVG, MAX, MIN - Filtering groups with HAVING - GROUP BY clause |
| Topic 8: Creating and Managing Tables | 9% | - Data types and constraints - Managing indexes, sequences, synonyms, views - CREATE, ALTER, DROP, RENAME tables |
Before You Start: Oracle Introduction to Oracle9i: SQL Answers
1Z0-007 is passed with 70% (40 out of 57), and the official exam fee is Approx. $195–$225 USD (historical, varies by region). Fixing these numbers early helps you set a measurable practice target.
Oracle University (legacy): register for 1Z0-007
Pearson VUE (historical): register for 1Z0-007
The 1Z0-007 exam contains 57 questions to complete in 120 minutes minutes. Rehearsing under the same limit on the PassCollection engine turns pacing into a trained habit.
Oracle University - Introduction to Oracle9i: SQL: Visit official page
Oracle9i SQL Study Guide: Visit official page
Choose the version of Oracle Introduction to Oracle9i: SQL you want, one, two, or all three, add it to the cart, and complete payment through the secure Credit Card checkout. The download link then arrives by email within about a minute, so your study starts without wasted time.
The package includes 110 practice questions for the 1Z0-007 exam. The count is set through analysis of a large volume of data, so the set matches the scope of the real test without padding.
- Single-Row Functions (18%)
- Manipulating Data (8%)
- Subqueries (10%)
Divide your time according to each topic's weight.
Payment runs through the Credit Card system, a globally used online payment network. We never share your personal information with third parties without your permission, and we never send spam, so your details stay where they belong.
None required; recommended basic relational database knowledge
Oracle Introduction to Oracle9i: SQL Sample Questions:
You own a table called EMPLOYEES with this table structure:
EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE
What happens when you execute this DELETE statement?
DELETE employees;
- A. You get an error because the statement is not syntactically correct.
- B. The data and structure of the EMPLOYEES table are deleted.
- C. You get an error because of a primary key violation.
- D. The data in the EMPLOYEES table is deleted but not the structure.
Correct Answer: D 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
The user Sue issues this SQL statement:
GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION;
The user Alice issues this SQL statement:
GRANT SELECT ON sue.EMP TO reena WITH GRANT OPTION;
The user Reena issues this SQL statement:
GRANT SELECT ON sue.EMP TO timber;
The user Sue issues this SQL statement:
REVOKE select on sue.EMP FROM alice;
For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?
- A. Sue, Alice, Reena, and Timber
- B. Alice and Reena
- C. Alice only
- D. Alice, Reena, and Timber
Correct Answer: D 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2)
FROM dual;
Which values are displayed?
- A. 46 and 45
- B. 50 and 45.93
- C. 46 and 45.93
- D. 45 and 45.93
- E. 50 and 45.9
- F. 45.95 and 45.93
Correct Answer: B 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
You need to calculate the total of all salaries in the accounting department. Which group function should you use?
- A. LARGEST
- B. MAX
- C. SUM
- D. TOTAL
- E. MIN
- F. COUNT
Correct Answer: C 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
Which statement accomplishes this task?
- A. SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) b WHERE a.dept_id = b.dept_id AND a.sal < b.maxsal;
- B. SELECT a.emp_name, a.sal, b.dept_id, MAX(sal) FROM employees a, departments b WHERE a.dept_id = b.dept_id AND a.sal < MAX(sal) GROUP BY b.dept_id;
- C. SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a WHERE a.sal < (SELECT MAX(sal) maxsal FROM employees b GROUP BY dept_id);
- D. SELECT emp_name, sal, dept_id, maxsal FROM employees, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) WHERE a.sal < maxsal;
Correct Answer: A 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
Viewing page 1 out of 22 pages.
Viewing questions 1-5 out of 110 questions.






