nerdexam
Oracle

1Z0-007 · Question #95

Examine the structure of the EMPLOYEES table: You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the…

The correct answer is D. INSERT INTO (SELECT *. See the full explanation below for the reasoning.

Question

Examine the structure of the EMPLOYEES table:

You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below:

Which INSERT statement meets the above requirements?

Exhibits

1Z0-007 question #95 exhibit 1
1Z0-007 question #95 exhibit 2

Options

  • AINSERT INTO employees
  • BINSERT INTO employees
  • CINSERT INTO (SELECT *
  • DINSERT INTO (SELECT *
  • EINSERT INTO (SELECT *

How the community answered

(32 responses)
  • A
    19% (6)
  • B
    3% (1)
  • C
    6% (2)
  • D
    69% (22)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice