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 #9

Examine these statements:
CREATE ROLE registrar;
GRANT UPDATE ON student_grades TO registrar;
GRANT registrar to user1, user2, user3;
What does this set of SQL statements do?

A. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

B. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.

C. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.

D. The set of statements contains an error and does not work.

E. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

F. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

Discussion 0

Correct Answer: E Vote an answer

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

Question #10

Which two statements about sequences are true? (Choose two)

A. You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.

B. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.

C. If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.

D. You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

E. You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.

F. You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.

Discussion 0

Correct Answer: B,F Vote an answer

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

Question #11

Examine the data in the EMPLOYEES table.

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.
Evaluate this DELETE statement:
DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90;
Why does the DELETE statement fail when you execute it?

A. There is no row with dept_id 90 in the EMPLOYEES table.

B. You cannot specify column names in the DELETE clause of the DELETE statement.

C. You cannot delete the JOB_ID column because it is a NOT NULL column.

D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

Discussion 0

Correct Answer: B Vote an answer

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

Question #12

Evaluate the SQL statement
DROP TABLE DEPT:
Which four statements are true of the SQL statement? (Choose four)

A. All data in the table is deleted, but the structure of the table is retained.

B. All synonyms based on the DEPT table are deleted.

C. All views based on the DEPT table are deleted.

D. All pending transactions are committed.

E. You cannot roll back this statement.

F. All indexes based on the DEPT table are dropped.

G. All data in the table is deleted, and the table structure is also deleted.

Discussion 0

Correct Answer: D,E,F,G Vote an answer

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

Question #13

What is necessary for your query on an existing view to execute successfully?

A. You need SELECT privileges only on the underlying tables.

B. You need SELECT privileges on the view.

C. The underlying tables must be in the same schema.

D. The underlying tables must have data.

Discussion 0

Correct Answer: B Vote an answer

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

Question #14

The CUSTOMERS table has these columns:

A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

A. WHERE lower(country_address) = '%france%'

B. WHERE lower(country_address) LIKE %france%

C. WHERE lower(country_address) IS 'france'

D. WHERE lower(country_address) = 'france'

E. WHERE lower(country_address) = "france"

Discussion 0

Correct Answer: D Vote an answer

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

Question #15

Which three are true? (Choose three.)

A. A MERGE statement can be used to update existing rows in a table.

B. A MERGE statement replaces the data of one table with that of another.

C. A MERGE statement can be used to insert new rows into a table.

D. A MERGE statement is used to merge the data of one table with data from another.

Discussion 0

Correct Answer: A,C,D Vote an answer

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

Question #16

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

A. A subquery should retrieve only one row.

B. A subquery CANNOT be used in an SQL query statement that uses group functions.

C. Subqueries CANNOT be nested by more than two levels.

D. A subquery can be used only in SQL query statements.

E. When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

F. A subquery can retrieve zero or more rows.

Discussion 0

Correct Answer: E,F 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.