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
Options
- AINSERT INTO employees
- BINSERT INTO employees
- CINSERT INTO (SELECT *
- DINSERT INTO (SELECT *
- EINSERT INTO (SELECT *
How the community answered
(32 responses)- A19% (6)
- B3% (1)
- C6% (2)
- D69% (22)
- E3% (1)
Community Discussion
No community discussion yet for this question.

