Certification exams change, and study material that was current last year can quietly go stale. ActualCollection updates its 340 Oracle Database 12c: SQL Fundamentals practice questions continuously, and your purchase includes 365 days of free updates through 2026 and beyond.

Oracle 1z1-061 Exam Overview:

Certification Vendor:	Oracle
Exam Name:	Oracle Database 12c: SQL Fundamentals
Exam Number:	1Z0-061
Certificate Validity Period:	Lifetime (Oracle certification does not expire for this exam track)
Exam Duration:	120 minutes
Related Certifications:	Oracle Database SQL Certified Associate (1Z0-071)
Real Exam Qty:	60-75
Exam Price:	USD 245
Passing Score:	65%
Available Languages:	English
Exam Format:	Multiple Choice Questions
Recommended Training:	Oracle Database SQL Fundamentals Training
Exam Registration:	Oracle Certification Registration Pearson VUE Oracle Exams
Sample Questions:
Exam Way:	Proctored exam (online via Pearson VUE or authorized test centers)
Pre Condition:	No formal prerequisite required, but basic understanding of database concepts is recommended.
Official Syllabus URL:	https://education.oracle.com

Oracle 1z1-061 Exam Syllabus Topics:

Oracle 1z1-061 Exam: Frequently Asked Questions

Oracle Database 12c: SQL Fundamentals Sample Questions:

Question 1

In which two cases would you use an outer join? (Choose two.)

A. The tables being joined have both matched and unmatched data.
B. The columns being joined have NULL values.
C. The tables being joined have NOT NULL columns.
D. The tables being joined have only matched data.
E. Only when the tables have a primary key/foreign key relationship.
F. The tables being joined have only unmatched data.

Question 2

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
NAME VARCHAR2(60)
Which MERGE statement is valid?

A. MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees VALUES (e.employee_id, e.first_name ||', '||e.last_name);
B. MERGE INTO new_employees c USING employees e ON (c.employee_id
e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES(e.employee_id, e.first_name ||', '||e.last_name);
C. MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);
D. MERGE INTO new_employees c USING employees e ON (c.employee_id
e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);

Question 3

EMPLOYEES and DEPARTMENTS data:
EMPLOYEES

DEPARTMENTS

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID.
On the DEPARTMENTS table DEPARTMENT_ID is the primary key.
Evaluate this UPDATE statement.
UPDATE employees
SET mgr_id
. (SELECT mgr_id
. FROM. employees
. WHERE dept_id
. (SELECT department_id
. FROM departments
. WHERE department_name = 'Administration')),
. Salary = (SELECT salary
. . FROM employees
. . WHERE emp_name = 'Smith')
WHERE job_id = 'IT_ADMIN';
What happens when the statement is executed?

A. The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.
B. The statement fails because there is more than one row matching the employee name Smith.
C. The statement fails because there is no 'Administration' department in the DEPARTMENTS table.
D. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.
E. The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.
F. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.

Question 4

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

A. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
B. It fails because no SQL *Loader data file location is specified.
C. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
D. It fails because no SQL *Loader control file location is specified.

Question 5

You want to create a sales table with the following column specifications and data types:
SALESID: Number
STOREID: Number
ITEMID: Number
QTY: Number, should be set to 1 when no value is specified
SLSDATE: Date, should be set to current date when no value is specified PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table?

A. Option B
B. Option C
C. Option D
D. Option A

Solutions: