Which operator can be used in a multiple-row subquery to match a single value to a list of values?

• A.=
• B.NOT NULL
• C.EXISTS
• D.IN

Comment: *

Name: *

Email: *

Verification: *

Which type of join includes rows that do not have matching values in the joined table?

• A.OUTER JOIN
• B.SELF JOIN
• C.CROSS JOIN
• D.INNER JOIN

Comment: *

Name: *

Email: *

Verification: *

Which SQL clause is used to specify the source table in a query?

• A.SELECT
• B.FROM
• C.GROUP BY
• D.WHERE

Comment: *

Name: *

Email: *

Verification: *

Which SQL statement is used to create a table?

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

Comment: *

Name: *

Email: *

Verification: *

What does the following query return?
SELECT employee_id
FROM employees
WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000);

• A.Employees with salaries greater than 1000
• B.Employees working in location ID 1000
• C.Departments located in location ID 1000
• D.Employees with no department

Comment: *

Name: *

Email: *

Verification: *