Oracle Introduction to Oracle9i: SQL - 1Z0-007 Exam Questions [2026]

QUESTION NO: 1
Examine the data from the ORDERS and CUSTOMERS table.

Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?

A. SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Martin')); B. SELECT ord_id, cust_id, ord_total
FROM orders, customers
WHERE cust_name='Mating'
AND ord_date IN ('18-JUL-2000','21-JUL-2000'); C. SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust_name = 'Martin'); D. SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
The CUSTOMERS table has these columns:

The CUSTOMER_ID column is the primary key for the table.
You need to determine how dispersed your customer base is.
Which expression finds the number of different countries represented in the CUSTOMERS table?

A. COUNT(UPPER(country_address)) B. COUNT(DIFF(UPPER(country_address))) C. COUNT DISTINCT UPPER(country_address) D. COUNT(UNIQUE(UPPER(country_address))) E. COUNT(DISTINCT (UPPER(country_address)))

Correct Answer: E

QUESTION NO: 3
The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER (12)
SEMESTER_END DATE
GPA NUMBER (4,3)
The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?

A. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end ASC, gpa ASC; B. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC; C. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC; D. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC; E. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
Which view should a user query to display the columns associated with the constraints on a table owned by the user?

A. USER_COLUMNS B. USER_CONS_COLUMNS C. USER_CONSTRAINTS D. ALL_CONSTRAINTS E. USER_OBJECTS

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
Examine the description of the EMPLOYEES table:

Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?

A. SELECT dept_id, MIN(salary), MAX(salary)
FROM employees
HAVING MIN(salary) < 5000 AND MAX(salary) > 15000; B. SELECT dept_id, MIN(salary), MAX(salary)
FROM employees
GROUP BY dept_id
HAVING MIN(salary) < 5000 AND MAX(salary) > 15000; C. SELECT dept_id, MIN(salary), MAX(salary)
FROM employees
WHERE MIN(salary) < 5000 AND MAX(salary) > 15000
GROUP BY dept_id; D. SELECT dept_id, MIN(salary(, MAX(salary)
FROM employees
WHERE MIN(salary) < 5000 AND MAX(salary) > 15000; E. SELECT dept_id, MIN(salary), MAX(salary)
FROM employees
GROUP BY dept_id, salary
HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
SELECT *
From orders;
You use this statement to retrieve data from a data table for __________. (Choose all that apply)

A. Deleting B. Truncating C. Viewing D. Updating E. Inserting

Correct Answer: C,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 7
The DBA issues this SQL command:
CREATE USER scott
IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

A. No privileges. B. All the privileges of a default user. C. Only the CONNECT privilege. D. Only the SELECT privilege.

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).