Home » MCQs » SQL MCQs » SQL Concatenate, Savepoint, TIME MCQs

Which of the following is TRUE about SQL Concatenate?

2. Which of the following is TRUE about SQL Concatenate?

1. It is also possible to combine more than two strings into one string.
2. Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
3. When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
4. All of the above

Answer: D) All of the above

Explanation:

In case of SQL Concatenate:

1. It is also possible to combine more than two strings into one string.
2. Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
3. When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.