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.
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.
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 2 years, 1 month agoRenad_16
Highly Voted 2 years, 1 month agoThameur01
Most Recent 1 week, 6 days agoArslanAltaf
9 months agousarovsherzod68
9 months, 4 weeks agoyaya32
12 months agolucemqy
1 year, 1 month agolucemqy
1 year, 2 months agolucemqy
1 year, 2 months agojm9999
1 year, 4 months agoTheOracleWasTaken
1 year, 5 months agozouve
1 year, 6 months agozouve
1 year, 6 months agoNelita
1 year, 7 months agoCyberP
1 year, 7 months agoCyberP
1 year, 7 months agoTheOracleWasTaken
1 year, 5 months agoshotcom
1 year, 3 months agoJ4vi
1 year, 8 months agokuff
1 year, 8 months agopmeyer
1 year, 8 months agoyanoolthecool
1 year, 7 months ago