Oracle
1Z0-047 · Question #92
View the Exhibit and examine the structure of EMPLOYEES and JOB_IHISTORY tables. The EMPLOYEES table maintains the most recent information regarding salary, department, and job for all the…
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_IHISTORY 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.)
Exhibit
Options
- ADELETE
- BDELETE
- CDELETE
- DDELETE
How the community answered
(51 responses)- A8% (4)
- B14% (7)
- C78% (40)
Community Discussion
No community discussion yet for this question.
