Examine the description of the EMPLOYEES table:
Which two statements will insert a row into the EMPLOYEES table? (Choose two.)
1z0-071 Exam QuestionsBrowse all questions from this exam
1z0-071 Exam - Question 90
Show AnswerHide Answer
Correct Answer: CEF
To insert a row into the EMPLOYEES table, the insertion statement must correctly match the column names and their constraints as described in the table. Option A is incorrect because it does not provide a value for DEPARTMENT_ID, which is not listed as nullable. Option B is incorrect because it attempts to insert an extra value. Option D is incorrect due to the syntax error in mentioning 'hiresate' instead of 'hiredate'. Option F is incorrect because the LAST_NAME column has a NOT NULL constraint, and inserting a blank string (' ') violates that constraint. Therefore, the correct statements are: Option C, which correctly lists the columns and provides appropriate values, and Option E, which uses a SELECT statement that properly matches the number of values with the columns and retrieves SYSDATE correctly.
Discussion
17 commentsBabi265
Dec 5, 2022i am finding 3 that are correct. CEF
Renad_16Options: CE
Dec 5, 2022I think it’s CE ?
jfc1Options: CE
Jan 20, 2023F is wrong because the column last_name has a not null constraint, in this case Oracle will not accept '' as value for the last_name column CE is the correct answer
Orxan_H
Apr 22, 2023in E missing "values", so i think correct answers C D
yanoolthecool
May 25, 2023Thought the same, was wrong, here; try this: Create table toz ( id number primary key, name varchar2(255) ); insert into toz (select 1,'toz'from dual);
CyberP
May 27, 2023at least there is brackets surround select in your example but e there are no brackets at all and no values it sounds wrong, but i am not sure.
TheOracleWasTaken
Aug 2, 2023You don't need the brackets it works
yanoolthecool
Jun 13, 2024gotta agree there
J4viOptions: CE
May 11, 2023C 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.
NelitaOptions: CE
Jun 1, 2023CEF are corret. I checked in data base.
pmeyerOptions: CE
Apr 28, 2023"F" is a wrong because not null.
yanoolthecool
May 25, 2023' ' is not a null, but its a bit confusing, since in some compilers ' ' is actually null, but appears to have a space between the 2 quotations when there actually isnt.
kuffOptions: CE
May 3, 2023CE is the answer
CyberP
May 27, 2023Why A is wrong?
CyberP
May 27, 2023Maybe AC are correct?
TheOracleWasTaken
Aug 2, 2023when you specify the values keyword you must insert a value for every column in the table. If it permits nulls then just insert null
shotcom
Sep 17, 2023https://www.techonthenet.com/oracle/insert.php according to that link You can omit a column from the Oracle INSERT statement if the column allows NULL values. so answer A is correct
zouveOptions: CE
Jun 22, 2023CE tested
zouve
Jun 24, 2023if there is a space iside ' ' on F is working
TheOracleWasTakenOptions: CF
Aug 2, 2023E works too
jm9999Options: CE
Sep 14, 2023C, E worked. F gave me ora-01400
lucemqyOptions: CF
Nov 14, 2023CF Should be the correct answer
lucemqyOptions: CD
Nov 14, 2023CD also works
lucemqyOptions: CE
Nov 16, 2023CE definitely works tested
yaya32Options: EF
Jan 16, 2024EF is correct for me as ' ' is not null...
usarovsherzod68Options: AC
Mar 22, 2024A, C for me. E is wrong because SELECT 101 is not correct.
ArslanAltafOptions: CF
Apr 17, 2024CF 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.