Quiz for SELECT with Expressions

Q1: Which of the following queries adds 10 to the column `price`?

A. SELECT price + 10 FROM products; B. SELECT ADD(price, 10) FROM products; C. SELECT price FROM products + 10; D. SELECT price FROM products WHERE price = 10;

Q2: What does the expression SELECT 3 + 5 return?

A. 3 B. 5 C. 8 D. 35

Q3: Which SQL clause allows use of arithmetic expressions directly?

A. SELECT B. FROM C. WHERE D. GROUP BY

Q4: What will SELECT salary * 12 AS annual_salary do?

A. Add 12 to salary B. Divide salary by 12 C. Multiply salary by 12 and rename column D. Multiply 12 by salary without renaming

Q5: What is the result of SELECT 10/2?

A. 5 B. 2 C. 0 D. 10

Q6: What does SELECT UPPER('sql') return?

A. sql B. SQL C. Sql D. Error

Q7: What does SELECT NOW() return?

A. Current Date B. Current Time C. Current Date and Time D. Current User

Q8: Which of the following is valid in SELECT clause?

A. SELECT name + 5 B. SELECT name || 5 C. SELECT salary + bonus D. SELECT * + salary

Q9: What does SELECT LENGTH('MySQL') return?

A. 5 B. 4 C. 6 D. Error

Q10: Which function returns the number of characters in a string?

A. CHAR_COUNT() B. SIZE() C. LENGTH() D. COUNT()

Q11: What does SELECT 'Score: ' || 90 return in PostgreSQL?

A. Score: B. 90 C. Score: 90 D. Error

Q12: Which keyword is used to rename a derived column?

A. RENAME B. AS C. LIKE D. TO

Q13: What is the output of SELECT 2 * (3 + 4)?

A. 14 B. 10 C. 12 D. 16

Q14: What will SELECT salary + NULL return?

A. 0 B. NULL C. salary D. Error

Q15: What does SELECT ROUND(10.678, 2) return?

A. 10.67 B. 10.68 C. 11 D. 10.6

Q16: What will SELECT CONCAT('SQL', 'Query') return?

A. SQL Query B. QuerySQL C. SQLQuery D. Error

Q17: Which clause in SQL supports aggregate and expression together?

A. WHERE B. HAVING C. ORDER BY D. SELECT

Q18: What will SELECT TRIM(' SQL ') return?

A. SQL B. SQL C. SQL D. SQL

Q19: Which function converts string to lowercase in SQL?

A. LOWER() B. UPPER() C. DOWN() D. SMALL()

Q20: What does SELECT ABS(-10) return?

A. 10 B. -10 C. 0 D. Error

Q21: Which symbol is used for multiplication in SQL expressions?

A. + B. - C. * D. /