Oracle
1Z0-061 · Question #138
Examine the structure of the EMPLOYEES table: Which INSERT statement is valid?
The correct answer is D. INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES ( 1000. It is the only statement that has a valid date; all other will result in an error. Answer A is incorrect, syntax error, invalid date format
Manipulating Data
Question
Examine the structure of the EMPLOYEES table:
Which INSERT statement is valid?
Exhibit
Options
- AINSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES ( 1000,
- BINSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES ( 1000,
- CINSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES ( 1000,
- DINSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES ( 1000,
How the community answered
(31 responses)- A6% (2)
- B10% (3)
- C3% (1)
- D81% (25)
Explanation
It is the only statement that has a valid date; all other will result in an error. Answer A is incorrect, syntax error, invalid date format
Topics
#INSERT statement#column list#DML syntax#case sensitivity
Community Discussion
No community discussion yet for this question.