Crowdly
Add to Chrome
Databases and Big Data Technologies
Looking for Databases and Big Data Technologies test answers and solutions? Browse our comprehensive collection of verified answers for Databases and Big Data Technologies at kmooc.uni-obuda.hu.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
SELECT department_name, city, country_name FROM departments
RIGHT JOIN locations USING (location_id)
RIGHT JOIN countries USING (country_id);
Which join algorithm is used?
SELECT * FROM regions
FULL JOIN countries USING (region_id)
ORDER BY region_id;
Which join algorithm is used?
SELECT * FROM regions
INNER JOIN countries USING (region_id)
ORDER BY region_id;
Which join algorithm is used?
SELECT e.employee_id, e.last_name, e.first_name, e.department_id, d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id
ORDER BY department_id;
Which join algorithm is used?
SELECT e.last_name, d.department_name, l.country_id, l.state_province
FROM employees e, locations l, departments d
WHERE e.department_id = d.department_id;
SELECT department_name, city, country_name FROM departments
LEFT JOIN locations USING (location_id)
LEFT JOIN countries USING (country_id);
What is the join order here?
SELECT * FROM locations LEFT JOIN countries USING (country_id);
Which is the outer row source?