Question 1
What type of join does the following query perform?
SELECT *
FROM employees e, departments d
WHERE e.department_id = d.department_id;
SELECT *
FROM employees e, departments d
WHERE e.department_id = d.department_id;
Question 2
What will the following SQL statement output?
SELECT first_name || ' ' || last_name AS full_name FROM employees;
SELECT first_name || ' ' || last_name AS full_name FROM employees;
Question 3
Which type of subquery returns exactly one value?
Question 4
What is required for the queries combined by a SET operator to work correctly?
Question 5
Which data dictionary view provides information about all the columns in tables accessible to the current user?