Questions
9 of 30
1Explain how collation affects comparison operators in string functions.
2Can functions be used in the WHERE clause? What are the performance implications?
3What are logical operators in MySQL, and how do AND, OR, and NOT work?
4What is the difference between IFNULL() and COALESCE() functions?
5How do aggregate functions like AVG(), SUM(), and MAX() behave when NULLs are present?
6What is the difference between the = and <=> operators?
7Explain the difference between NOW(), CURDATE(), and SYSDATE().
8What is the difference between ROUND(), TRUNCATE(), and FORMAT() functions?
9What are user-defined functions (UDFs), and how do they differ from stored procedures?
10What is the use of the CONCAT() function? How is it different from using ||?
11What are window functions in MySQL 8.0, and how do they differ from aggregate functions?
12What are the differences between DATE_ADD() and ADDDATE() functions?
13Explain the use of REGEXP and LIKE operators. What’s the difference between them?
14Give examples of commonly used string functions in MySQL.
15What are arithmetic operators in MySQL? Give examples.
16What does the DISTINCT keyword do when used with aggregate functions like COUNT()?
17How does MySQL internally optimize and cache results of deterministic functions?
18What are deterministic and non-deterministic functions? How does this affect replication and indexes?
19How does MySQL handle type conversion when using operators on different data types?
20Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() window functions.
21What are comparison operators in MySQL, and how are they used with NULL values?
22What is the difference between single-row functions and aggregate functions?
23Explain how CASE and IF() functions can be used for conditional logic.
24How does MySQL evaluate operator precedence when multiple operators are used in a single expression?
25How would you combine multiple functions and operators to clean, transform, and aggregate data efficiently in one query?
26What are functions and operators in MySQL, and how are they different?
27What are the performance trade-offs of using scalar functions inside JOIN or GROUP BY clauses?
28How can you use STR_TO_DATE() and DATE_FORMAT() for converting and displaying date values?
29How can you use JSON_EXTRACT() and JSON_CONTAINS() to work with JSON data in MySQL?
30What is the difference between LENGTH() and CHAR_LENGTH() functions?
