Question 1 of 30
A company has a database with two tables: `employees` and `departments`. The `employees` table contains columns for `employee_id`, `name`, `department_id`, and `job_title`. The `departments` table includes `department_id` and `department_name`. You need to write a SQL query to retrieve the names of employees who work in the \'Sales\' department and hold the job title \'Sales Representative\'. Which SQL query would accomplish this task?
SELECT e.name
SELECT e.name
SELECT e.name
SELECT e.name

Preparing for Oracle Database 23ai Administration Associate? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free