Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 90

Examine the description of the EMPLOYEES table:

Which two statements will insert a row into the EMPLOYEES table? (Choose two.)

INSERT INTO employees VALUES (101, 'John', 'Smith', 12000, SYSDATE);

INSERT INTO employees VALUES (101, 'John', 'Smith', 10, 12000, SYSDATE);

INSERT INTO employees (employee_id, salary, first_name, hiredate, last_name) VALUES (101, 12100, 'John', SYSDATE, 'Smith');

INSERT INTO employees (employee_id, first_name, last_name, salary, hiresate)

VALUES ( (SELECT 101, 'John', 'Smith'. 12000, SYSDATE FROM dual) );

INSERT INTO employees SELECT 101, 'John', 'Smith', 12000, (SELECT SYSDATE FROM dual), 10 FROM dual;

INSERT INTO employees VALUES (101, 'John', ' ', 12000, SYSDATE, 10);

Correct Answer: C, E

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

Babi265

i am finding 3 that are correct. CEF

Renad_16Options: CE

I think it’s CE ?

jfc1Options: CE

F 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

in E missing "values", so i think correct answers C D

yanoolthecool

Thought 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

at 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

You don't need the brackets it works

yanoolthecool

gotta agree there

NelitaOptions: CE

CEF are corret. I checked in data base.

J4viOptions: CE

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.

ArslanAltafOptions: CF

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.

usarovsherzod68Options: AC

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

yaya32Options: EF

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

lucemqyOptions: CE

CE definitely works tested

lucemqyOptions: CD

CD also works

lucemqyOptions: CF

CF Should be the correct answer

jm9999Options: CE

C, E worked. F gave me ora-01400

TheOracleWasTakenOptions: CF

E works too

zouveOptions: CE

CE tested

zouve

if there is a space iside ' ' on F is working

CyberP

Why A is wrong?

CyberP

Maybe AC are correct?

TheOracleWasTaken

when 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

https://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

kuffOptions: CE

CE is the answer

pmeyerOptions: CE

"F" is a wrong because not null.

yanoolthecool

' ' 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.