[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

PL/SQL :: Basic Concepts - Discussion

Home > PL/SQL > Basic Concepts > MCQs Questions Discussion

58 / 41

Choose the correct option.

Evaluate this SQL statement:
SELECT employee_id, e.department_id, department_name, salary
FROM employees e, departments d
WHERE e.department_id = d.department_id;

Which SQL statement is equivalent to the above SQL statement?

ASELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);

BSELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;

CSELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department_id = d.department_id;

DSELECT employee_id, department_id, department_name, salary FROM employees JOIN departments USING (e.department_id, department_i;

Answer: Option (Login/Signup)

Show Explanation

Asked In :: Virtusa

Post Your Answer Here:     

No Discussion on this question yet!