Free C2090-730 Web TestEngine Demo

Q44 Single choice

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?

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)

C2090-730 Web TestEngine demo