Oracle
1Z0-047 · Question #223
View the Exhibit and examine the structure of EMPLOYEES and JOB_HISTORY tables. The EMPLOYEES table maintains the most recent information regarding salary, department, and job for all the employees…
The correct answer is C. DELETE D. DELETE. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of EMPLOYEES and JOB_HISTORY tables. The EMPLOYEES table maintains the most recent information regarding salary, department, and job for all the employees. The JOB_HISTORY table maintains the record for all the job changes for the employees. You want to delete all the records from the JOB_HISTORY table that are repeated in the EMPLOYEES table. Which two SQL statements can you execute to accomplish the task? (Choose two.)
Options
- ADELETE
- BDELETE
- CDELETE
- DDELETE
How the community answered
(22 responses)- A9% (2)
- B18% (4)
- C73% (16)
Community Discussion
No community discussion yet for this question.