Test Your Knowledge of Oracle SQL CAST Function with This Quiz

Progress

True / False

In Oracle, the CAST function is used to convert one data type to another.

True False

The CAST function converts a value from one data type to another specified data type.

True / False

The CAST function in Oracle can convert a string to a number.

True False

The CAST function can convert a string to a number if the string represents a valid numeric value.

True / False

In Oracle, the CAST function can only be used to convert numeric data types.

True False

The CAST function can convert between various data types, including numeric, string, date, and others.

True / False

The CAST function in Oracle can be used to convert a DATE value to a VARCHAR2 value.

True False

The CAST function can convert a DATE value to a VARCHAR2 value by specifying the target data type as VARCHAR2.

True / False

In Oracle, the CAST function can be used to convert a BLOB to a CLOB.

True False

The CAST function cannot directly convert a BLOB to a CLOB. This requires using the DBMS_LOB package.

True / False

The CAST function in Oracle can be used in the SELECT clause to change the data type of columns in the result set.

True False

The CAST function can be used in the SELECT clause to convert the data type of columns in the query result.

True / False

In Oracle, the CAST function can be used to convert a TIMESTAMP value to a DATE value.

True False

The CAST function can convert a TIMESTAMP value to a DATE value, but the time portion will be truncated.

True / False

The CAST function in Oracle can convert an INTERVAL type to a NUMBER type.

True False

The CAST function does not support direct conversion from INTERVAL types to NUMBER types.

True / False

In Oracle, using the CAST function to convert data types can sometimes result in data loss if the conversion is not compatible.

True False

Data loss can occur if the source data type and target data type are not compatible, such as converting a large number to a smaller data type.

Q10

True / False

The Oracle Certified Professional (OCP) exam includes knowledge on using the CAST function effectively, understanding its syntax, and handling potential conversion errors in SQL queries.

True False

The OCP certification covers advanced topics, including the effective use of the CAST function, understanding its syntax, and managing potential conversion errors in SQL queries.

Q11

Single Choice

What is the primary purpose of the CAST function in Oracle SQL?

To join tables To convert a value from one data type to another To filter rowsTo concatenate strings

The CAST function is used in Oracle to explicitly convert a value from one data type to another.

Q12

Single Choice

Which of the following is a correct usage of the CAST function to convert a string to a number in Oracle SQL?

CAST('123' AS VARCHAR2) CAST('123' AS DATE) CAST('123' AS NUMBER)CAST(123 AS STRING)

The correct syntax for converting a string to a number is CAST('123' AS NUMBER).

Q13

Single Choice

What will be the result of the following Oracle SQL query?

SQL Code

SELECT CAST(123 AS VARCHAR2(5)) FROM dual;

123 123 (as a number) 12345NULL

The CAST function converts the number 123 to a string with a maximum length of 5 characters.

Q14

Single Choice

Consider the following Oracle SQL query:What does this query do?

SQL Code

SELECT CAST('2024-08-21' AS DATE) FROM dual;

Converts the string to a date Converts the date to a string Throws an error because the format is incorrectReturns the string as it is

The correct format for converting a string to a date must match Oracle's default date format or be explicitly defined. '2024-08-21' does not match the default format (DD-MON-YYYY).

Q15

Single Choice

Which Oracle SQL query correctly converts a string in the format 'YYYY-MM-DD' to a date?

CAST('2024-08-21' AS DATE) TO_DATE('2024-08-21', 'YYYY-MM-DD') TO_CHAR('2024-08-21', 'YYYY-MM-DD')CAST('21-AUG-2024' AS VARCHAR2)

The TO_DATE function is used to convert a string to a date when the format needs to be specified.

Q16

Single Choice

Given the Oracle SQL query:What will be the result?

SQL Code

SELECT CAST(ROUND(123.456, 1) AS VARCHAR2(6)) FROM dual;

123.5 123.4 123123.456 (as a number)

The ROUND function rounds the number to one decimal place, and then CAST converts it to a string.

Q17

Single Choice

What will be the result of the following Oracle SQL query?

SQL Code

SELECT CAST(SUBSTR('Oracle 123', 8, 3) AS NUMBER) FROM dual;

123 (as a number) Oracle (as a string) 123 (as a string)An error

The SUBSTR function extracts the substring '123', and CAST converts it to a number.

Q18

Single Choice

Consider this Oracle SQL query:What does the query return?

SQL Code

SELECT CAST(SYSDATE AS TIMESTAMP) FROM dual;

The current date and time as a DATE The current date and time as a TIMESTAMP The current date as a stringAn error because SYSDATE cannot be cast to TIMESTAMP

The CAST function converts SYSDATE (which is a DATE) to a TIMESTAMP, which includes fractional seconds.

Q19

Single Choice

Which of the following Oracle SQL queries correctly casts a TIMESTAMP to a DATE?

SELECT CAST(SYSDATE AS VARCHAR2(20)) FROM dual; SELECT CAST(CURRENT_TIMESTAMP AS DATE) FROM dual; SELECT TO_DATE(CURRENT_TIMESTAMP) FROM dual;SELECT CAST('2024-08-21' AS TIMESTAMP) FROM dual;

The CAST function is used to convert CURRENT_TIMESTAMP to a DATE, which will discard the fractional seconds.

Q20

Single Choice

What is the result of the following Oracle SQL query?

SQL Code

SELECT CAST(CAST('100.99' AS NUMBER) AS VARCHAR2(10)) FROM dual;

100.99 100 100.9An error due to double casting

The query first converts the string '100.99' to a number and then casts it back to a string, preserving the original value.

Q21

Multiple Choice

Which SQL code snippet demonstrates converting a string to a number using the `CAST` function in Oracle?

SQL Code

SELECT employee_id, CAST(salary AS NUMBER) AS salary_num
FROM employees
WHERE CAST('12345' AS NUMBER) > 10000;

SELECT employee_id, CAST(salary AS NUMBER) AS salary_num FROM employees WHERE CAST('12345' AS NUMBER) > 10000; SELECT employee_id, CAST(salary AS NUMBER) AS salary_num FROM employees WHERE CAST('12345' AS NUMBER) > 10000; SELECT employee_id, CAST(salary AS NUMBER) AS salary_num FROM employees WHERE CAST('12345' AS NUMBER) > 10000;SELECT employee_id, salary FROM employees WHERE '12345' > 10000;

Options A, B, and C correctly demonstrate the use of the `CAST` function to convert a string to a number. Option D is incorrect because it does not use the `CAST` function.

Q22

Multiple Choice

Which SQL code snippet demonstrates converting a date to a string using the `CAST` function in Oracle?

SQL Code

SELECT employee_id, hire_date, CAST(hire_date AS VARCHAR2(20)) AS hire_date_str
FROM employees
WHERE CAST(hire_date AS VARCHAR2(20)) = '01-JAN-2023';

SELECT employee_id, hire_date, CAST(hire_date AS VARCHAR2(20)) AS hire_date_str FROM employees WHERE CAST(hire_date AS VARCHAR2(20)) = '01-JAN-2023'; SELECT employee_id, hire_date, CAST(hire_date AS VARCHAR2(20)) AS hire_date_str FROM employees WHERE CAST(hire_date AS VARCHAR2(20)) = '01-JAN-2023'; SELECT employee_id, hire_date, CAST(hire_date AS VARCHAR2(20)) AS hire_date_str FROM employees WHERE CAST(hire_date AS VARCHAR2(20)) = '01-JAN-2023';SELECT employee_id, hire_date FROM employees WHERE hire_date = '01-JAN-2023';

Options A, B, and C correctly demonstrate the use of the `CAST` function to convert a date to a string. Option D is incorrect because it does not use the `CAST` function.

Q23

Multiple Choice

Which SQL code snippet demonstrates converting a number to a string using the `CAST` function in Oracle?

SQL Code

SELECT employee_id, salary, CAST(salary AS VARCHAR2(10)) AS salary_str
FROM employees
WHERE CAST(salary AS VARCHAR2(10)) LIKE '5%';

SELECT employee_id, salary, CAST(salary AS VARCHAR2(10)) AS salary_str FROM employees WHERE CAST(salary AS VARCHAR2(10)) LIKE '5%'; SELECT employee_id, salary, CAST(salary AS VARCHAR2(10)) AS salary_str FROM employees WHERE CAST(salary AS VARCHAR2(10)) LIKE '5%'; SELECT employee_id, salary, CAST(salary AS VARCHAR2(10)) AS salary_str FROM employees WHERE CAST(salary AS VARCHAR2(10)) LIKE '5%';SELECT employee_id, salary FROM employees WHERE salary LIKE '5%';

Options A, B, and C correctly demonstrate the use of the `CAST` function to convert a number to a string. Option D is incorrect because it does not use the `CAST` function.

Q24

Multiple Choice

Which SQL code snippet demonstrates converting a timestamp to a date using the `CAST` function in Oracle?

SQL Code

SELECT employee_id, CAST(hire_date AS DATE) AS hire_date_only
FROM employees
WHERE CAST(hire_date AS DATE) = TO_DATE('01-JAN-2023', 'DD-MON-YYYY');

SELECT employee_id, CAST(hire_date AS DATE) AS hire_date_only FROM employees WHERE CAST(hire_date AS DATE) = TO_DATE('01-JAN-2023', 'DD-MON-YYYY'); SELECT employee_id, CAST(hire_date AS DATE) AS hire_date_only FROM employees WHERE CAST(hire_date AS DATE) = TO_DATE('01-JAN-2023', 'DD-MON-YYYY'); SELECT employee_id, CAST(hire_date AS DATE) AS hire_date_only FROM employees WHERE CAST(hire_date AS DATE) = TO_DATE('01-JAN-2023', 'DD-MON-YYYY');SELECT employee_id, hire_date FROM employees WHERE hire_date = TO_DATE('01-JAN-2023', 'DD-MON-YYYY');

Options A, B, and C correctly demonstrate the use of the `CAST` function to convert a timestamp to a date. Option D is incorrect because it does not use the `CAST` function.

Q25

Multiple Choice

Which SQL code snippet demonstrates converting a string to a date using the `CAST` function in Oracle?

SQL Code

SELECT employee_id, CAST('2023-01-01' AS DATE) AS hire_date
FROM employees
WHERE CAST('2023-01-01' AS DATE) > TO_DATE('01-JAN-2022', 'DD-MON-YYYY');

SELECT employee_id, CAST('2023-01-01' AS DATE) AS hire_date FROM employees WHERE CAST('2023-01-01' AS DATE) > TO_DATE('01-JAN-2022', 'DD-MON-YYYY'); SELECT employee_id, CAST('2023-01-01' AS DATE) AS hire_date FROM employees WHERE CAST('2023-01-01' AS DATE) > TO_DATE('01-JAN-2022', 'DD-MON-YYYY'); SELECT employee_id, CAST('2023-01-01' AS DATE) AS hire_date FROM employees WHERE CAST('2023-01-01' AS DATE) > TO_DATE('01-JAN-2022', 'DD-MON-YYYY');SELECT employee_id, '2023-01-01' AS hire_date FROM employees WHERE '2023-01-01' > TO_DATE('01-JAN-2022', 'DD-MON-YYYY');

Options A, B, and C correctly demonstrate the use of the `CAST` function to convert a string to a date. Option D is incorrect because it does not use the `CAST` function.

Q26

Multiple Choice

Which SQL code snippet demonstrates advanced use of the `CAST` function to convert a number to a character and concatenate it with a string in Oracle?

SQL Code

SELECT employee_id, first_name || CAST(salary AS VARCHAR2(10)) AS employee_info
FROM employees
WHERE CAST(salary AS VARCHAR2(10)) LIKE '5%';

SELECT employee_id, first_name || CAST(salary AS VARCHAR2(10)) AS employee_info FROM employees WHERE CAST(salary AS VARCHAR2(10)) LIKE '5%'; SELECT employee_id, first_name || CAST(salary AS VARCHAR2(10)) AS employee_info FROM employees WHERE CAST(salary AS VARCHAR2(10)) LIKE '5%'; SELECT employee_id, first_name || CAST(salary AS VARCHAR2(10)) AS employee_info FROM employees WHERE CAST(salary AS VARCHAR2(10)) LIKE '5%';SELECT employee_id, first_name || salary AS employee_info FROM employees WHERE salary LIKE '5%';

Options A, B, and C correctly demonstrate advanced use of the `CAST` function to convert a number to a character and concatenate it with a string. Option D is incorrect because it does not use the `CAST` function.

Q27

Multiple Choice

Which SQL code snippet demonstrates advanced use of the `CAST` function to convert a date to a character and perform a string comparison in Oracle?

SQL Code

SELECT employee_id, CAST(hire_date AS VARCHAR2(20)) AS hire_date_str
FROM employees
WHERE CAST(hire_date AS VARCHAR2(20)) = '01-JAN-2023';

SELECT employee_id, CAST(hire_date AS VARCHAR2(20)) AS hire_date_str FROM employees WHERE CAST(hire_date AS VARCHAR2(20)) = '01-JAN-2023'; SELECT employee_id, CAST(hire_date AS VARCHAR2(20)) AS hire_date_str FROM employees WHERE CAST(hire_date AS VARCHAR2(20)) = '01-JAN-2023'; SELECT employee_id, CAST(hire_date AS VARCHAR2(20)) AS hire_date_str FROM employees WHERE CAST(hire_date AS VARCHAR2(20)) = '01-JAN-2023';SELECT employee_id, hire_date FROM employees WHERE hire_date = '01-JAN-2023';

Options A, B, and C correctly demonstrate advanced use of the `CAST` function to convert a date to a character and perform a string comparison. Option D is incorrect because it does not use the `CAST` function.

Q28

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `CAST` function to convert a character string to a timestamp in Oracle?

SQL Code

SELECT employee_id, first_name, CAST('2023-01-01 12:00:00' AS TIMESTAMP) AS hire_timestamp
FROM employees
WHERE CAST('2023-01-01 12:00:00' AS TIMESTAMP) > TO_TIMESTAMP('2022-01-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS');

SELECT employee_id, first_name, CAST('2023-01-01 12:00:00' AS TIMESTAMP) AS hire_timestamp FROM employees WHERE CAST('2023-01-01 12:00:00' AS TIMESTAMP) > TO_TIMESTAMP('2022-01-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS'); SELECT employee_id, first_name, CAST('2023-01-01 12:00:00' AS TIMESTAMP) AS hire_timestamp FROM employees WHERE CAST('2023-01-01 12:00:00' AS TIMESTAMP) > TO_TIMESTAMP('2022-01-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS'); SELECT employee_id, first_name, CAST('2023-01-01 12:00:00' AS TIMESTAMP) AS hire_timestamp FROM employees WHERE CAST('2023-01-01 12:00:00' AS TIMESTAMP) > TO_TIMESTAMP('2022-01-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS');SELECT employee_id, first_name FROM employees WHERE '2023-01-01 12:00:00' > '2022-01-01 12:00:00';

Options A, B, and C correctly demonstrate certification-level use of the `CAST` function to convert a character string to a timestamp. Option D is incorrect because it does not use the `CAST` function.

Q29

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `CAST` function to convert a number to a binary_float in Oracle?

SQL Code

SELECT employee_id, salary, CAST(salary AS BINARY_FLOAT) AS salary_float
FROM employees
WHERE CAST(salary AS BINARY_FLOAT) > 5000.00;

SELECT employee_id, salary, CAST(salary AS BINARY_FLOAT) AS salary_float FROM employees WHERE CAST(salary AS BINARY_FLOAT) > 5000.00; SELECT employee_id, salary, CAST(salary AS BINARY_FLOAT) AS salary_float FROM employees WHERE CAST(salary AS BINARY_FLOAT) > 5000.00; SELECT employee_id, salary, CAST(salary AS BINARY_FLOAT) AS salary_float FROM employees WHERE CAST(salary AS BINARY_FLOAT) > 5000.00;SELECT employee_id, salary FROM employees WHERE salary > 5000.00;

Options A, B, and C correctly demonstrate certification-level use of the `CAST` function to convert a number to a binary_float. Option D is incorrect because it does not use the `CAST` function.

Q30

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `CAST` function to convert a string to a blob in Oracle?

SQL Code

SELECT employee_id, CAST('SampleData' AS BLOB) AS data_blob
FROM employees
WHERE CAST('SampleData' AS BLOB) IS NOT NULL;

SELECT employee_id, CAST('SampleData' AS BLOB) AS data_blob FROM employees WHERE CAST('SampleData' AS BLOB) IS NOT NULL; SELECT employee_id, CAST('SampleData' AS BLOB) AS data_blob FROM employees WHERE CAST('SampleData' AS BLOB) IS NOT NULL; SELECT employee_id, CAST('SampleData' AS BLOB) AS data_blob FROM employees WHERE CAST('SampleData' AS BLOB) IS NOT NULL;SELECT employee_id, 'SampleData' FROM employees WHERE 'SampleData' IS NOT NULL;

Options A, B, and C correctly demonstrate certification-level use of the `CAST` function to convert a string to a blob. Option D is incorrect because it does not use the `CAST` function.

Oracle Database Quiz Questions