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
  5% (2)
• B
  17% (7)
• C
  71% (29)
• D
  7% (3)

Explanation

EMPLOYEE_ID is a primary key. Incorrect answer: A EMPLOYEE_ID cannot be null B EMPLOYEE_ID cannot be null D mismatch of field_name with datatype

No community discussion yet for this question.