Home » MCQs » MariaDB MCQs

What will QUOTE() function return if we pass NULL in it?

25. What will QUOTE() function return if we pass NULL in it?

1. "NULL"
2. 'NULL'
3. NULL
4. null

Answer: C) NULL

Explanation:

The statement QUOTE("NULL") will return NULL. See the example below

Syntax:

SELECT QUOTE(NULL); 
+-------------+
| QUOTE(NULL) |
+-------------+
| NULL        |
+-------------+