Database MCQS - QUESTION DETAILS
What is the purpose of the SQL COALESCE() function?
A. Combine multiple columns
B. Replace NULL values with a specified value
C. Calculate the average value
D. Concatenate multiple rows

'COALESCE()' is used to replace NULL values with a specified value in MySQL.

Similar Questions

In SQL Server, what is the purpose of the IDENTITY property?





In Oracle, what is the purpose of the MERGE statement?





In MySQL, which function is used to concatenate two or more strings?





Which SQL Server function is used to concatenate two or more strings?





In Oracle, what is the purpose of the GROUP BY clause?





In SQL Server, what is the purpose of the CHECK constraint?





In MySQL, which type of index allows only unique values and nulls are considered distinct?





Which SQL statement is used to remove a table from a database?





What is the purpose of the SQL Server ROLLBACK statement?





What is the purpose of the SQL Server ORDER BY clause?