Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? (Choose three.)

Question

Options

• AINSERT INTO employees VALUES ( NULL, 'John', 'Smith');
• BINSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
• CINSERT INTO employees VALUES ( 1000, 'John', NULL);
• DINSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
• EINSERT INTO employees (employee_id) VALUES (1000);
• FINSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');

• A
  4% (2)
• B
  11% (6)
• C
  83% (45)
• D
  2% (1)

Explanation

EMPLOYEE_ID is a primary key.

No community discussion yet for this question.