Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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
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.
' ' 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.
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
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);
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Babi265
Highly Voted 1 year, 4 months agoRenad_16
Highly Voted 1 year, 4 months agoArslanAltaf
Most Recent 1 week, 6 days agousarovsherzod68
1 month, 1 week agoyaya32
3 months, 2 weeks agolucemqy
5 months, 2 weeks agolucemqy
5 months, 2 weeks agolucemqy
5 months, 2 weeks agojm9999
7 months, 2 weeks agoTheOracleWasTaken
9 months agozouve
10 months, 1 week agozouve
10 months, 1 week agoNelita
11 months agoCyberP
11 months, 1 week agoCyberP
11 months, 1 week agoTheOracleWasTaken
9 months agoshotcom
7 months, 2 weeks agoJ4vi
11 months, 3 weeks agokuff
12 months agopmeyer
1 year agoyanoolthecool
11 months, 1 week agojfc1
1 year, 3 months agoOrxan_H
1 year agoyanoolthecool
11 months, 1 week agoCyberP
11 months, 1 week agoTheOracleWasTaken
9 months ago