Oracle 1Z0-007 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-007
Exam Name/Title: Introduction to Oracle9i: SQL
Certification Provider: Oracle
Corresponding Certification: 9i DBA

Exam Questions: 110
Updated On: Aug 20, 2026

Question #1

Examine the description of the STUDENTS table:

Which two aggregate functions are valid on the START_DATE column? (Choose two)

A. MAXIMUM (start_date)

B. AVG (start_date)

C. COUNT (start_date)

D. AVG (start_date, end_date)

E. MIN (start_date)

F. SUM (start_date)

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #2

Which two statements are true about constraints? (Choose two.)

A. The NOT NULL constraint ensures that null values are not permitted for the column.

B. The UNIQUE constraint does not permit a null value for the column.

C. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

D. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #3

Which are DML statements? (Choose all that apply)

A. UPDATE...

B. DELETE...

C. MERGE...

D. DROP...

E. CREAT..

F. COMMIT...

Discussion 0

Correct Answer: A,B,C Vote an answer

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

Question #4

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. Alice, Reena, and Timber

B. Alice only

C. Alice and Reena

D. Sue, Alice, Reena, and Timber

Discussion 0

Correct Answer: A Vote an answer

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

Question #5

Examine the structure of the EMPLOYEES table:

You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: Which INSERT statement meets the above requirements?

A. INSERT INTO (SELECT *
FROM employees
WHERE department_id IN (20,50)
WITH CHECK OPTION)
VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);

B. INSERT INTO (SELECT *
FROM employees
WHERE (department_id = 20 AND
department_id = 50)
WITH CHECK OPTION )
VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);

C. INSERT INTO employees
VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid',
2000, NULL, &did IN (20,50));

D. INSERT INTO employees
VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);

E. INSERT INTO (SELECT *
FROM employees
WHERE department_id IN (20,50))
VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);

Discussion 0

Correct Answer: A Vote an answer

Question #6

Examine the structure of the EMPLOYEES table:

What is the correct syntax for an inline view?

A. SELECT a.last_name, a.salary, a.department_id
FROM employees a
WHERE a.salary =
(SELECT max(salary)
FROM employees b
WHERE a.department_id = b.department_id);

B. SELECT a.last_name, a.salary, a.department_id
FROM employees a
WHERE (a.department_id, a.salary) IN
(SELECT department_id, a.salary) IN
(SELECT department_id max(salary)
FROM employees b
GROUP BY department_id
ORDER BY department_id);

C. maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;

D. SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))

E. SELECT a.last_name, a.salary, a.department_id,

Discussion 0

Correct Answer: E Vote an answer

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

Question #7

Which two statements accurately describe a role? (Choose two.)

A. Privileges are given to a role by using the CREATE ROLE statement.

B. A role can have a maximum of 100 privileges contained in it.

C. A role is a named group of related privileges that can be granted to the user.

D. A user can have access to several roles, and several users can be assigned the same role.

E. A user can have access to a maximum of 10 roles.

F. A role can be given to a maximum of 1000 users.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #8

Examine the description of the CUSTOMERS table:

The CUSTOMER_ID column is the primary key for the table.
Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?

A. SELECT city_address, COUNT(customer_id)
FROM customers
WHERE city_address IN ( 'Los Angeles', 'San Fransisco')
GROUP BY city_address, customer_id;

B. SELECT city_address, COUNT (*)
FROM customers
WHERE city address IN ( 'Los Angeles', 'San Fransisco')
GROUP BY city_address;

C. SELECT city_address, COUNT(*)
FROM customers
WHERE city_address IN ( 'Los Angeles', 'San Fransisco');

D. SELECT city_address, COUNT (customer_id)
FROM customers
GROUP BY city_address IN ( 'Los Angeles', 'San Fransisco');

Discussion 0

Correct Answer: B Vote an answer

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

Download Free Oracle 1Z0-007 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-007 exam.