You work as a Database Administrator for Domain.com. The company uses MySQL as its
database. You have created a table named Employees. You want to insert a row in the table. The
structure of the table is as follows:
Emp_ID NUMBER PRIMARY KEY
Emp_Name VARCHAR2 (30)
Emp_Address VARCHAR2 (40)
Which of the following statements can you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
A.
INSERT INTO Employees
VALUES (100, ‘Adam’, ‘California’);
B.
INSERT INTO Employees (‘Adam’, ‘California’);
C.
INSERT INTO Employees (Emp_Name, Emp_Address)
VALUES (‘Adam’, ‘California’);
D.
INSERT INTO Employees (Emp_ID, Emp_Name, Emp_Address)
VALUES (100, ‘Adam’, ‘California’);