Test: Quiz: Self Joins and Hierarchical Queries
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1
1. Hierarchical queries MUST use the LEVEL pseudo column. True or False? Mark for Review
(1) Points
True
False (*)
2. Which select statement will return the last name and hire data of an employee and his/ her manager for employees that started in the company before their managers? Mark for Review
(1) Points
SELECT w.last_name, w.hire_date, m.last_name, m.hire_date
FROM employees w , employees m
WHERE w.manager_id = m.employee_id AND w.hire_date < m.hire_date (*)
SELECT w.last_name, w.hire_date, m.last_name, m.hire_date FROM employees w , employees m WHERE w.manager_id != m.employee_id AND w.hire_date < m.hire_date SELECT w.last_name, w.hire_date, m.last_name, m.hire_date FROM employees w , employees w WHERE w.manager_id = w.employee_id AND w.hire_date < w.hire_date SELECT w.last_name, w.hire_date, m.last_name, m.hire_date FROM employees w , employees m WHERE w.manager_id = m.employee_id AND w.hire_date > m.hire_date
3. Which of the following database design concepts is implemented with a self join? Mark for Review
(1) Points
Non-Transferability
Recursive Relationship (*)
Supertype
Arc
4. Hierarchical queries can walk both Top-Down and Bottom-Up. True or False? Mark for Review
(1) Points
True (*)
False
5. Which of the following database design concepts do you need in your tables to write Hierarchical queries? Mark for Review
(1) Points
Non-Transferability
Recursive Relationship (*)
Supertype
Arc
6. Which SELECT statement implements a self join? Mark for Review
(1) Points
SELECT e.employee_id, m.manager_id
FROM employees e NATURAL JOIN employees m;
SELECT e.employee_id, m.manager_id
FROM employees e, employees m
WHERE m.employee_id = e.manager_id;(*)
SELECT e.employee_id, m.manager_id
FROM employees e, manager m
WHERE e.employee_id = m.manager_id;
SELECT e.employee_id, m.manager_id
FROM employees e, departments m
WHERE e.employee_id = m.manager_id;
