PrepAway - Latest Free Exam Questions & Answers

which of the following statements will NOT successfully add data to table CURRENT_EMPLOYEES?

Given the following table:
CURRENT_EMPLOYEES
————————————–
EMPID INTEGER NOT NULL
NAME CHAR(20)

SALARY DECIMAL(10,2)
PAST_EMPLOYEES
————————————–
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements will NOT successfully add
data to table CURRENT_EMPLOYEES?

PrepAway - Latest Free Exam Questions & Answers

A.
INSERT INTOcurrent_employees (empid) VALUES (10)

B.
INSERT INTOcurrent_employees VALUES (10, ‘JAGGER’, 85000.00)

C.
INSERT INTOcurrent_employees SELECT empid, name, salary FROM past_employees
WHERE empid = 20

D.
INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM
past_employees WHERE empid = 20)

2 Comments on “which of the following statements will NOT successfully add data to table CURRENT_EMPLOYEES?


Leave a Reply