Question: Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this order), which of the following commands stores a NULL value in Col3

Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this order), which of the following commands stores a NULL value in Col3 of the HOMEWORK10 table?
a. INSERT INTO homework10 VALUES (‘A’,  ‘B’,  ‘C’);
b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’,  ‘B’);
c. INSERT INTO homework10 VALUES (NULL, ‘A’,  ‘B’);
d. UPDATE homework10 SET col1 = col3;

Step by Step Solution

3.23 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

b INSERT IN... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12123dbd_716136.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12123dbd_716136.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!