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
Options
- AINSERT INTO employees
- BINSERT INTO employees
- CINSERT INTO (SELECT *
- DINSERT INTO (SELECT *
- EINSERT INTO (SELECT *
How the community answered
(50 responses)- A2% (1)
- B2% (1)
- C8% (4)
- D84% (42)
- E4% (2)
Community Discussion
No community discussion yet for this question.

