Exam 1z0-071 topic 1 question 90 discussion

i am finding 3 that are correct. CEF

I think it’s CE ?

✅ C. sql Copy Edit INSERT INTO employees (employee_id, salary, first_name, hiredate, last_name) VALUES (101, 12100, 'John', SYSDATE, 'Smith'); This works: all required columns (EMPLOYEE_ID, LAST_NAME) are provided. The column order doesn’t have to match the table, as long as it's declared. DEPARTMENT_ID is nullable, so it's fine to omit. ✅ E. sql Copy Edit INSERT INTO employees SELECT 101, 'John', 'Smith', 12000, (SELECT SYSDATE FROM dual), 10 FROM dual;

C: Explicitly matches columns with their values. E: Uses a SELECT query to populate all columns correctly. F: Provides all values in the correct order.

CF is correct. in F, if have space between ' ' for last Name, it will be accepted. if there is no space, then not null constraint will apply.

A, C for me. E is wrong because SELECT 101 is not correct.

EF is correct for me as ' ' is not null...

CE definitely works tested

CD also works

CF Should be the correct answer

C, E worked. F gave me ora-01400

E works too

CE tested

CEF are corret. I checked in data base.

Why A is wrong?

C E are correct. F would be ok whith an space between ' '. If you copy and paste the exact alternative from here, it works, but I imagine that the exam doesn't have that space and that's why the're only two correct options.

CE is the answer