MySQL CAST Function Quiz: Test Your Knowledge

Progress

True / False

In MySQL, the CAST function can be used to convert a string to an integer.

True False

The CAST function in MySQL can convert a string to an integer, provided the string represents a valid integer value.

True / False

MySQL's CAST function can convert a value to a BOOLEAN data type.

True False

MySQL does not have a BOOLEAN data type. Instead, it uses TINYINT(1) for boolean values. Therefore, CAST cannot be used to convert values to BOOLEAN

True / False

In MySQL, the CAST function can be used to convert a date to a string.

True False

The CAST function can be used to convert a DATE or DATETIME value to a string using the appropriate format.

True / False

MySQL allows the CAST function to be used within an ORDER BY clause.

True False

The CAST function can be used in an ORDER BY clause to ensure that the values are sorted as the specified data type.

True / False

MySQL's CAST function can convert a NULL value to any data type without errors.

True False

When CAST is used on a NULL value, it returns NULL without any errors, regardless of the target data type.

True / False

MySQL's CAST function can convert a binary string (BINARY data type) to a non-binary string (CHAR data type).

True False

The CAST function can be used to convert binary strings to non-binary strings using the appropriate data type in the conversion.

True / False

In MySQL, the CAST function cannot be used to convert JSON data to other data types.

True False

MySQL allows the CAST function to convert JSON data to other types such as CHAR or TEXT, making it easier to handle JSON data in different contexts.

True / False

MySQL’s CAST function can be used to convert a floating-point number to an unsigned integer.

True False

MySQL’s CAST function does not support direct conversion to unsigned integers. You can convert a floating-point number to a signed integer, but unsigned integers require additional handling.

True / False

Using MySQL's CAST function to convert a string that contains non-numeric characters to an integer will return 0.

True False

When converting a string that contains non-numeric characters to an integer using CAST, MySQL will return 0 if the string cannot be parsed as a valid integer.

Q10

True / False

MySQL's CAST function can be used to convert data types in both SQL queries and stored procedures.

True False

The CAST function in MySQL is versatile and can be used within SQL queries and stored procedures to convert data types as needed. This functionality is important for handling data type conversions consistently across different parts of a database system.

Q11

Single Choice

Which of the following is the correct way to cast a VARCHAR value to an INT in MySQL?

CAST('123' TO INT) CAST('123' AS INTEGER) CAST('123' INTO INT)CAST('123' LIKE INT)

The correct syntax for casting a value in MySQL is CAST(value AS datatype). In this case, '123' is cast to an INTEGER

Q12

Single Choice

What will the following SQL code return: SELECT CAST('2024-08-12' AS DATE);?

2024-08-12 12-08-2024 2024/08/12NULL

The CAST function converts the string '2024-08-12' to a DATE type, which is stored in the format YYYY-MM-DD.

Q13

Single Choice

How can you cast a DECIMAL value to a CHAR value in MySQL?

CAST(12.34 TO CHAR) CAST(12.34 AS CHAR) CAST(12.34 INTO CHAR)CAST(12.34 LIKE CHAR)

To convert a DECIMAL value to a CHAR value, the correct syntax is CAST(value AS datatype). In this case, 12.34 is cast to a CHAR type.

Q14

Single Choice

What does the following MySQL query return: SELECT CAST('123.45' AS SIGNED);?

123 123.45 NULLERROR

The CAST function converts '123.45' to a SIGNED integer by truncating the decimal part, resulting in 123.

Q15

Single Choice

Consider the following query: SELECT CAST(NULL AS CHAR);. What will it return?

'NULL' NULL ERROR''

Casting NULL to any data type will still return NULL because NULL represents the absence of any value.

Q16

Single Choice

In MySQL, what will be the result of the following query: SELECT CAST('abc' AS UNSIGNED);?

0 Abc NULLERROR

When a non-numeric string is cast to an UNSIGNED integer, MySQL returns 0.

Q17

Single Choice

Given the query SELECT CAST('2024-08-12 14:30:00' AS TIME);, what will be the output?

2024-08-12 14:30:00 14:30:00 2024-08-12NULL

The CAST function converts the datetime string to a TIME type, extracting only the time portion.

Q18

Single Choice

If you run the following MySQL query: SELECT CAST('123abc' AS UNSIGNED);, what will be the result?

123 123abc NULL0

MySQL converts the leading numeric part of the string '123abc' to UNSIGNED, resulting in 123.

Q19

Single Choice

What will the query SELECT CAST(CONCAT('12', '.', '34') AS DECIMAL(4,2)); return in MySQL?

12.34 1234 12:000

The CONCAT function creates the string '12.34', which is then cast to a DECIMAL(4,2) resulting in 12.34.

Q20

Single Choice

In a MySQL database, how would the CAST function behave in the following query: SELECT CAST('123.4567' AS DECIMAL(5,2));?

123.46 123.45 0NULL

The CAST function rounds the value to fit the specified precision (DECIMAL(5,2)), resulting in 123.46. The first 5 digits are the total number of digits including those after the decimal, and the last 2 digits are reserved for the decimal part.

Q21

Multiple Choice

Which SQL query uses CAST to convert a string '2024-08-25' into a DATE type?

SQL Code

SELECT CAST('2024-08-25' AS DATE) AS formatted_date;

SELECT CAST('2024-08-25' AS DATE) AS formatted_date; SELECT STR_TO_DATE('2024-08-25', '%Y-%m-%d') AS formatted_date; SELECT CONVERT('2024-08-25', DATE) AS formatted_date;SELECT CAST('2024-08-25' AS DATETIME) AS formatted_date;

The CAST function converts the string '2024-08-25' into a DATE type, which can then be used in date-related operations.

Q22

Multiple Choice

Identify the SQL query that uses CAST to convert a string '123.45' into a DECIMAL type.

SQL Code

SELECT CAST('123.45' AS DECIMAL(5,2)) AS decimal_value;

SELECT CAST('123.45' AS DECIMAL(5,2)) AS decimal_value; SELECT CONVERT('123.45', DECIMAL(5,2)) AS decimal_value; SELECT FORMAT('123.45', 2) AS decimal_value;SELECT CAST('123.45' AS FLOAT) AS decimal_value;

The CAST function converts the string '123.45' into a DECIMAL type with a precision of 5 and scale of 2, suitable for financial calculations.

Q23

Multiple Choice

Which SQL query uses CAST to convert a DATE column to a VARCHAR format?

SQL Code

SELECT CAST(order_date AS CHAR) AS order_date_str
FROM orders;

SELECT CAST(order_date AS CHAR) AS order_date_str FROM orders; SELECT DATE_FORMAT(order_date, '%Y-%m-%d') AS order_date_str FROM orders; SELECT CONVERT(order_date, CHAR) AS order_date_str FROM orders;SELECT CAST(order_date AS VARCHAR) AS order_date_str FROM orders;

The CAST function converts the DATE column 'order_date' into a VARCHAR (CHAR) format, allowing it to be treated as a string.

Q24

Multiple Choice

Determine the SQL query that uses CAST to convert a TIMESTAMP into a DATETIME type.

SQL Code

SELECT CAST(created_at AS DATETIME) AS created_at_dt
FROM events;

SELECT CAST(created_at AS DATETIME) AS created_at_dt FROM events; SELECT CONVERT(created_at, DATETIME) AS created_at_dt FROM events; SELECT CAST(created_at AS DATE) AS created_at_dt FROM events;SELECT CONVERT(created_at, TIMESTAMP) AS created_at_dt FROM events;

The CAST function converts the 'created_at' TIMESTAMP column into a DATETIME type for standard date-time operations.

Q25

Multiple Choice

Which SQL query uses CAST to convert an integer value '100' into a CHAR type?

SQL Code

SELECT CAST(100 AS CHAR) AS char_value;

SELECT CAST(100 AS CHAR) AS char_value; SELECT CONVERT(100, CHAR) AS char_value; SELECT CAST(100 AS VARCHAR) AS char_value;SELECT FORMAT(100, 'CHAR') AS char_value;

The CAST function converts the integer value '100' into a CHAR type, allowing it to be used as a string in text operations.

Q26

Multiple Choice

Which SQL query uses CAST to ensure a column 'price' is treated as DECIMAL during a SUM operation?

SQL Code

SELECT SUM(CAST(price AS DECIMAL(10,2))) AS total_price
FROM sales;

SELECT SUM(CAST(price AS DECIMAL(10,2))) AS total_price FROM sales; SELECT SUM(CAST(price AS FLOAT)) AS total_price FROM sales; SELECT SUM(price) AS total_price FROM sales WHERE price IS DECIMAL(10,2);SELECT SUM(CONVERT(price, DECIMAL(10,2))) AS total_price FROM sales;

The CAST function ensures that the 'price' column is treated as a DECIMAL type during the SUM operation, preserving accuracy in financial calculations.

Q27

Multiple Choice

Identify the SQL query that uses CAST to convert a VARCHAR column 'quantity' to an INTEGER for comparison.

SQL Code

SELECT * FROM inventory
WHERE CAST(quantity AS SIGNED) > 100;

SELECT * FROM inventory WHERE CAST(quantity AS SIGNED) > 100; SELECT * FROM inventory WHERE CONVERT(quantity, SIGNED) > 100; SELECT * FROM inventory WHERE CAST(quantity AS INT) > 100;SELECT * FROM inventory WHERE quantity > 100;

The CAST function converts the 'quantity' column from VARCHAR to INTEGER (SIGNED) to enable numeric comparisons.

Q28

Multiple Choice

Which SQL query uses CAST to format a numeric 'balance' column to display with two decimal places?

SQL Code

SELECT CAST(balance AS DECIMAL(10,2)) AS formatted_balance
FROM accounts;

SELECT CAST(balance AS DECIMAL(10,2)) AS formatted_balance FROM accounts; SELECT FORMAT(balance, 2) AS formatted_balance FROM accounts; SELECT CAST(balance AS CHAR(10,2)) AS formatted_balance FROM accounts;SELECT CONVERT(balance, DECIMAL(10,2)) AS formatted_balance FROM accounts;

The CAST function formats the 'balance' column as DECIMAL with two decimal places, ensuring consistent financial reporting.

Q29

Multiple Choice

Determine the SQL query that uses CAST to convert a binary string '101010' to an INTEGER.

SQL Code

SELECT CAST('101010' AS UNSIGNED) AS integer_value;

SELECT CAST('101010' AS UNSIGNED) AS integer_value; SELECT CONVERT('101010', UNSIGNED) AS integer_value; SELECT CAST(BINARY '101010' AS UNSIGNED) AS integer_value;SELECT BIN_TO_NUM('101010') AS integer_value;

The CAST function converts the binary string '101010' into an INTEGER (UNSIGNED), which can be used in numerical operations.

Q30

Multiple Choice

Which SQL query uses CAST to convert a JSON column 'data' to a VARCHAR for easy text manipulation?

SQL Code

SELECT CAST(data AS CHAR) AS data_str
FROM logs;

SELECT CAST(data AS CHAR) AS data_str FROM logs; SELECT JSON_UNQUOTE(data) AS data_str FROM logs; SELECT CONVERT(data, CHAR) AS data_str FROM logs;SELECT CAST(data AS TEXT) AS data_str FROM logs;

The CAST function converts the JSON column 'data' to a VARCHAR (CHAR) type, enabling text manipulation and string functions.

MySQL Database Quiz Questions