CREATE TABLE TESTER (id int not null, I_name varchar(30) not null, f_name varcha

Question

CREATE TABLE TESTER (id int not null, I_name varchar(30) not null, f_name varchar(30) not null) CREATE TABLE TEST (test_id int not null, tester_id int not null, test_name varchar(30) not null, test_date datetime null) Which of the following queries will return all testers, even if they have not taken a test yet, and their corresponding test name? SELECT l_name, f_name, test_name LEFT JOIN test ON TESTER.tester_id = TEST.tester_id SELECT l_name, f_name, test_name FROM tester, test ON tester.id = test.tester_id SELECT l_name, f_name, test_name FROM tester, test WHERE test.tester_id =* tester.id SELECT l_name, f_name, test_name FROM tester RIGHT JOIN test WHERE tester.id = test.tester_id

Explanation / Answer

Answer: Option: A. SELECT I_name, f_name, test_name LEFT JOIN test ON TESTER.tester_id = TEST.tester_id.

                 

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.