Oracle Database SQL Certified Associate Exam
Timed Exam Mode - Simulated Conditions
The Oracle Database SQL (1Z0-071) exam validates proficiency in SQL concepts including data retrieval, manipulation, and definition using Oracle Database. Passing earns the Oracle Database SQL Certified Associate credential.
A user wants to retrieve records for all employees who are either in the 'Sales' department or have a salary greater than 50000. However, the query should only include employees hired after '2022-01-01'. Which WHERE clause correctly implements this logic?
-
A
WHERE (Department = 'Sales' OR Salary > 50000) AND HireDate > '2022-01-01'
-
B
WHERE Department = 'Sales' OR Salary > 50000 AND HireDate > '2022-01-01'
-
C
WHERE Department = 'Sales' AND Salary > 50000 OR HireDate > '2022-01-01'
-
D
WHERE (Department = 'Sales' AND HireDate > '2022-01-01') OR Salary > 50000
Start Full Exam - 78 Questions