OCP CBT Question 532
Please solve the following question.
You need to retrieve a list of all `job_id` values from the `employees` table, including duplicates if they exist, and then combine this with a list of all `job_id` values from a hypothetical `job_history` table (assuming it has a `job_id` column), also including duplicates. Which set operator should you use?
EMPLOYEES Table Sample Data (relevant columns)
JOB_ID
----------
IT_PROG
SA_REP
IT_PROG
AD_VP
SA_REP
PU_CLERK
JOB_HISTORY Table Sample Data (hypothetical, relevant columns)
JOB_ID
----------
IT_PROG
AD_ASST
SA_MAN