AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 7871

Which three SELECT statements displays 2000 in the format "$2,000.00"? (Choose three)

Option A

SELECT TO CNAR(2000, '$#,###.##') FROM dual;

Option B

SELECT TO CNAR(2000, '$0,000.00') FROM dual;

Option C

SELECT TO CNAR(2000, '$9,999.00') FROM dual;

Option D

SELECT TO CNAR(2000, '$9,999.99') FROM dual;

Option E

SELECT TO CNAR(2000, '$2,000.00') FROM dual;

Option F

SELECT TO CNAR(2000, '$N,NNN.NN') FROM dual; 

Correct Answer BCD
Explanation Explanation/Reference: Explanation: Only queries in answers B, C and D will show result as in the format "$2,000.00". Incorrect Answers A: Oracle error "ORA-01481: invalid number format model" will be generated. E: Oracle error "ORA-01481: invalid number format model" will be generated. F: Oracle error "ORA-01481: invalid number format model" will be generated. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 356-365 Chapter 8: User Access Control in Oracle


Question ID 7872

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEESEMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHARD2(25) LAST_NAME VARCHARD2(25) HIRE_DATE DATE NEW EMPLOYEESEMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which UPDATE statement is valid?

Option A

UPDATE new_employees SET name = (Select last_name|| first_name FROM employees Where employee_id =180) WHERE employee_id = 180;

Option B

UPDATE new_employees SET name = (SELECT last_name||first_name FROM employees) WHERE employee_id = 180;

Option C

UPDATE new_employees SET name = (SELECT last_name|| first_name FROM employees WHERE employee_id =180) WHERE employee_id =(SELECT employee_id FROM new employees

Option D

UPDATE new_employees SET name = (SELECT last name|| first_name FROM employees WHERE employee_id= (SELECT employee_id FROM new_employees)) WHERE employee_id =180;

Correct Answer A
Explanation Explanation/Reference: Explanation: Sub-query in this answer will return one row value, concatenated first and last name for the employee with ID 180, so update will be successful. When sub-queries are linked to the parent by equality comparisons, the parent query expects only one row of data from the sub-query. Incorrect Answers B: Sub-query will return concatenated first and last name for ALL records from the table EMPLOYEES. It will cause an error for the parent query, because it expects one only one row. C: Last WHERE statement in this query will generate error because sub-query returns multi-row result. D: SELECT statement for the NEW_EMPLOYEES table in this query will generate error because sub-query returns multi-row result. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 150-156 Chapter 4: Subqueries

Send email to admin@getfreedumps for new dumps request!!!