Which of the following queries will run correctly? A. SELEC…

Which of the following queries will run correctly? A. SELECT s.name, g.grade FROM s, GRADE g WHERE s.student_id = g.student_id; B. SELECT s.name, g.grade FROM STUDENT s, g WHERE s.student_id = g.student_id; C. SELECT s.name, g.grade FROM s, g WHERE s.student_id = g.student_id; D. SELECT s.name, g.grade FROM STUDENT s, GRADE g WHERE s.student_id = g.student_id;

Which of the following SQL queries can run for a very long t…

Which of the following SQL queries can run for a very long time? A. SELECT e.name, d.name FROM employees e JOIN departments d ON 1 < 1; B. SELECT e.name, d.name FROM employees e JOIN departments d ON 1 > 1; C. SELECT e.name, d.name FROM employees e JOIN departments d ON 1 = 1; D. SELECT e.name, d.name FROM employees e JOIN departments d ON 1 < 0;