When the INSERT command is being used to enter data into a non-numeric column,the data must be enclosed in ____.
A) parentheses
B) double quotation marks
C) single quotation marks
D) upper-case letters

Question

When the INSERT command is being used to enter data into a non-numeric column,the data must be enclosed in ____.​
A) ​parentheses
B) ​double quotation marks
C) ​single quotation marks
D) ​upper-case letters

Quizplus · Accepted Answer

When inserting data into a non-numeric column, the data must be enclosed in single quotation marks. This is because single quotation marks are used to delimit string literals in SQL.

When the INSERT Command Is Being Used to Enter Data