Free 1Z0-071 Using Conversation Functions Questions and Answers

Question 1

Which two are SQL features?

Accepted Answer

providing database transaction control

Answer

providing graphical capabilities

Answer

providing variable definition capabilities.

Answer

providing update capabilities for data in external files

Question 2

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

Accepted Answer

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;

Answer

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

Answer

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

Answer

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

Question 3

Which statement executes successfully?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

Question 4

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

Accepted Answer

TO_NUMBER

Answer

TO_CHAR

Answer

TO_DATE

Answer

NVL

Question 5

What is the purpose of the TO_CHAR function in SQL?

Accepted Answer

To convert a number or date to a string.

Answer

To convert a string to a number.

Answer

To convert a date to a number.

Answer

To convert a string to a date.