Quiz for Conversion Functions

Q1: Which function is used to convert data types in SQL?

A. FORMAT() B. CONVERT() C. CAST() D. BOTH B and C

Q2: Which SQL function converts a string to a number?

A. TO_CHAR() B. TO_NUMBER() C. CAST() D. CONVERT()

Q3: Which function would you use to convert a number to a string in SQL?

A. TO_DATE() B. TO_STRING() C. TO_CHAR() D. CAST()

Q4: What does the CAST() function do in SQL?

A. Converts a value to a different data type B. Sorts data C. Deletes nulls D. Truncates strings

Q5: What is the result of CAST(123.45 AS INT)?

A. 123 B. 123.45 C. 124 D. Error

Q6: Which function can convert a date to a string in SQL?

A. TO_CHAR() B. CAST() C. TO_DATE() D. CONVERT()

Q7: Which SQL function converts a value from one data type to another?

A. CONCAT() B. CAST() C. NVL() D. SUBSTR()

Q8: What is the difference between CAST() and CONVERT() in SQL?

A. They are identical B. CAST is standard SQL; CONVERT is vendor-specific C. CONVERT is faster D. CAST is deprecated

Q9: What happens when you use TO_DATE() on a string like '2024-01-01'?

A. It raises error B. It converts string to date C. It truncates it D. It returns null

Q10: What does this expression return: CAST('2024-01-01' AS DATE)?

A. A string B. A date C. An error D. A number

Q11: Which conversion function is used in MySQL to change data types?

A. CAST() B. CHANGE() C. CONVERT() D. FORMAT()

Q12: Which function would convert a string '123.45' into a numeric type in Oracle SQL?

A. TO_NUMBER() B. CAST() C. CONVERT() D. TO_CHAR()

Q13: How does CONVERT differ from CAST in SQL Server?

A. CAST is not supported B. CONVERT supports style formatting C. CONVERT is deprecated D. There is no difference

Q14: What does this return: CAST('123' AS FLOAT)?

A. 123.0 B. 123 C. 1.23 D. Error

Q15: Which of the following functions can convert a datetime to a string format?

A. TO_DATE() B. TO_CHAR() C. TO_NUMBER() D. CAST()

Q16: Which of these functions allows you to format output during conversion?

A. CAST() B. CONVERT() C. TO_CHAR() D. SUBSTR()

Q17: What happens when you try CAST('abc' AS INT)?

A. Returns 0 B. Raises error C. Returns null D. Returns ASCII

Q18: In SQL, what does TO_DATE('01-JAN-2024', 'DD-MON-YYYY') return?

A. A string B. A number C. A date D. Null

Q19: Which SQL function is best for converting between character and numeric types?

A. TO_NUMBER() and TO_CHAR() B. NVL() C. TRIM() D. INSTR()

Q20: Which function helps in date formatting while converting?

A. CAST() B. CONVERT() C. TO_CHAR() D. ROUND()

Q21: Which is the correct way to change a number to varchar in SQL?

A. CAST(num AS VARCHAR) B. TO_INT(num) C. FORMAT(num) D. TRIM(num)