Free Oracle 1Z1-171 Exam Dumps Questions & Answers

What does the following SQL statement do?
SELECT e.employee_id, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

• A.  Retrieves all employees and their departments
• B.  Retrieves only employees without departments
• C.  Retrieves employees and departments with matching department_id
• D.  Retrieves only departments with no employees

Which SET operator returns rows from the first query that are not present in the second query?

• A.  INTERSECT
• B.  MINUS
• C.  UNION ALL
• D.  UNION

Which SQL statement is used to create a table?

• A.  INSERT
• B.  ADD TABLE
• C.  CREATE TABLE
• D.  ALTER TABLE

What is the result of the following query?
SELECT employee_id
FROM employees
WHERE EXISTS (SELECT 1 FROM departments WHERE department_id = 10);

• A.  Employees with salaries greater than 10
• B.  All employee IDs
• C.  Employee IDs from department 10
• D.  Employee IDs from departments with no employees

Which of the following can be achieved using a correlated subquery?

• A.  Inserting data into a table
• B.  Joining two tables without a common column
• C.  Comparing each employee's salary to the average salary of their department
• D.  Retrieving duplicate records from a single table