Oracle Database Foundations Associate (1Z0-006)

Access More Questions

A user wants to add a new employee record to the 'employees' table, which has columns for 'employee_id', 'last_name', and 'hire_date'. Which of the following SQL statements is the correct syntax for this operation?

ADD INTO employees VALUES (101, 'Smith', '17-OCT-23'); INSERT INTO employees (employee_id, last_name, hire_date) VALUES (101, 'Smith', '17-OCT-23'); UPDATE employees SET employee_id=101, last_name='Smith', hire_date='17-OCT-23'; CREATE NEW ROW IN employees VALUES (101, 'Smith', '17-OCT-23');

Correct Answer:

INSERT INTO employees (employee_id, last_name, hire_date) VALUES (101, 'Smith', '17-OCT-23');

Access more questions from this quiz

Continue to Oracle Database Foundations Associate (1Z0-006) for more practice questions and the full quiz experience.

Access More Questions