Free 1Z0-071 Using Conversation Functions Questions and Answers

What is the purpose of the TO_CHAR function in SQL?

To convert a number or date to a string.

To convert a string to a number.

To convert a date to a number.

To convert a string to a date.

Correct! Wrong!

The TO_CHAR function is used to convert a number or a date to a string. It is often used to format dates or numbers for display purposes.

Which SQL function can be used to convert a string to a number?

TO_CHAR

TO_NUMBER

TO_DATE

NVL

Correct! Wrong!

The TO_NUMBER function is used to convert a string to a number. This is useful when dealing with string data that needs to be processed numerically.

Which statement executes successfully?

SELECT TO_DATE(TO_NUMBER(INTERVATL '800' SECOND)) FROM DUAL;

SELECT TO_NUMBER(INTERVAL'800' SECOND, 'HH24:MM') FROM DUAL;

SELECT TO_DATE(INTERVAL '800' SECOND,'HH24:MM') FROM DUAL;

SELECT TO_NUWBER(TO_DATE(INTERVAL '800' SECOND)) FROM DUAL;

SELECT TO_CHAR(INTERVAL '800' SECOND, 'HH24:MM') FROM DUAL;

Correct! Wrong!

Which two queries return rows for employees whose manager works in a different department?

Please select 2 correct answers

SELECT emp. * FROM employees emp WHERE manager_ id NOT IN ( SELECT mgr.employee_ id FROM employees mgr WHERE emp. department_ id mgr.department_ id );

SELECT emp.* FROM employees emp WHERE NOT EXISTS ( SELECT NULL FROM employees mgr WHERE emp.manager id = mgr.employee_ id AND emp.department_idmgr.department_id );

SELECT emp.* FROM employees emp LEFT JOIN employees mgr ON emp.manager_ id = mgr.employee_ id AND emp. department id mgr. department_ id;

SELECT emp. * FROM employees emp RIGHT JOIN employees mgr ON emp.manager_ id = mgr. employee id AND emp. department id mgr.department_ id WHERE emp. employee_ id IS NOT NULL;

SELECT emp. * FROM employees emp JOIN employees mgr ON emp. manager_ id = mgr. employee_ id AND emp. department_ id mgr.department_ id;

Correct! Wrong!

Which two are SQL features?

Please select 2 correct answers

providing graphical capabilities

providing variable definition capabilities.

providing database transaction control

processing sets of data

providing update capabilities for data in external files

Correct! Wrong!

Free 1Z0-071 Using Conversation Functions Questions and Answers

What is the purpose of the TO_CHAR function in SQL?

Which SQL function can be used to convert a string to a number?

Which statement executes successfully?

Which two queries return rows for employees whose manager works in a different department?

Which two are SQL features?

Related Post