SOL-C01 Question #164: Real Exam Question with Answer & Explanation

Question

You have a table 'SALES DATA' with columns 'PRODUCT_ID' ONT), 'SALE_DATE' (DATE), and 'SALE AMOUNT' You want to load data into this table from various sources. You need to insert multiple rows in a single INSERT statement for performance reasons. However, one of the data sources occasionally provides 'SALE AMOUNT' as 'NULL'. What is the best way to handle the 'NULL' values in the 'INSERT' statement while ensuring that the rest of the data is loaded correctly?

Options

• AOmit the 'SALE AMOUNT column from the 'INSERT statement when the value is 'NULL'.
• BReplace the `NULL ` values with 0 in the 'INSERT statement.
• CUse the 'DEFAULT keyword for the SALE AMOUNT column in the 'INSERT statement when the
• DUse in the insert statement to convert empty string to NULL.
• EInsert `NIJLC directly into the 'SALE_AMOUNT column.

Explanation

Option E is the most straightforward and correct approach. If the 'SALE_AMOIJNT column is defined to allow 'NULL' values (which is common for numeric columns representing amounts), you can directly insert into the column. Option A will cause an error if all columns are not specified in INSERT statement. Option B changes the meaning of your data by changing the NULL to 0. Option C will only work if the 'SALE AMOUNT column has a default defined, and D is not needed as NULL can be inserted as NULL into the column.

No community discussion yet for this question.