nerdexam
Oracle

1Z0-061 · Question #96

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-061 question #96 exhibit 1
1Z0-061 question #96 exhibit 2

Options

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

How the community answered

(50 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    8% (4)
  • D
    84% (42)
  • E
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice