You issue the following command to create the PRINT_MEDIA table. CREATE TABLE print_media (product_id NUMBER(3), ad_sourcetext CLOB, ad_photo BLOB); Evaluate the following INSERT statements:

INSERT INTO print_media VALUES (1, empty_clob(),empty_blob()); INSERT INTO print_media VALUES (2,'This is a One Line Story',null); INSERT INTO print_media VALUES (3,'This is another One Line Story',empty_blob()); INSERT INTO print_media VALUES (4,empty_clob(),to_blob('This is new Story')); Which of the above INSERT statements are valid?

Question

You issue the following command to create the PRINT_MEDIA table. CREATE TABLE print_media (product_id NUMBER(3), ad_sourcetext CLOB, ad_photo BLOB); Evaluate the following INSERT statements:

INSERT INTO print_media VALUES (1, empty_clob(),empty_blob()); INSERT INTO print_media VALUES (2,'This is a One Line Story',null); INSERT INTO print_media VALUES (3,'This is another One Line Story',empty_blob()); INSERT INTO print_media VALUES (4,empty_clob(),to_blob('This is new Story')); Which of the above INSERT statements are valid?

Accepted Answer

E. Only the first, second and third statements are valid.

Answer

A. Only the first statement is valid.

Answer

B. All the statements are valid.

Answer

C. Only the first and fourth statements are valid.

Answer

D. Only the first and second statements are valid.

You issue the following command to create the PRINT_MEDIA table. CREATE TABLE print_media (product_id NUMBER(3), ad_sourcetext CLOB, ad_photo BLOB); Evaluate the following INSERT statements: INSERT…

Question

Options

How the community answered

Explanation

Topics

Community Discussion