nerdexam
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

1Z0-047 question #92 exhibit

Options

  • ADELETE
  • BDELETE
  • CDELETE
  • DDELETE

How the community answered

(51 responses)
  • A
    8% (4)
  • B
    14% (7)
  • C
    78% (40)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice