Case-Based Critical Thinking QuestionsCase 5-1Skylar is trying to build a table to display her inventory of the items she sells in her online software shop. She wants to display the cover, name, vendor, quantity in stock, and price for each item. Skylar would like to have borders just on the top and bottom; which style would do that?

Which of the following statements is an example of a SELF JOIN?

A) SELECT department_id, department_name,location_id, city FROM departments NATURAL JOIN locations; B) SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id FROM employees e JOIN departments d ON (e.department_id = d.department_id); C) SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id FROM employees e JOIN departments d ON (e.department_id = d.department_id) AND e.manager_id = 149 ; D) SELECT worker.last_name emp, manager.last_name mgr FROM employees worker JOIN employees manager ON (worker.manager_id = manager.employee_id);

Bookmarks allow you to create hyperlinks to specific places in a document

Indicate whether the statement is true or false