Given the following table: Which of the following INSERT statements will be successful?

Question

Exhibit

Options

• AINSERT INTO EMPSAMP (empno, name, salary, deptno, level, hiretype, hiredate)
• BINSERT INTO EMPSAMP (Mary Smith', 35000.00, 11, Associate', `existing','05-06-2016');
• CINSERT INTO EMPSAMP VALUES(2,'Mary Smith', 35000.00, 11, Associate', existing','05-06-
• DINSERT INTO EMPSAMP (name, salary, deptno, level) VALUES(`Mary Smith', 35000.00, 11,

• A
  72% (49)
• B
  9% (6)
• C
  4% (3)
• D
  15% (10)

No community discussion yet for this question.