Free 1Z0-071 Using Conversation Functions Questions and Answers

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!

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 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.

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.

Free 1Z0-071 Using Conversation Functions Questions and Answers

Which two are SQL features?

Which statement executes successfully?

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

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

What is the purpose of the TO_CHAR function in SQL?

Related Post