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





Question ID 8061

You want to display the details of all employees whose last names is Smith. But you are not sure in which case last names are stored. Which statement will list all the employees whose last name is Smith?

Option A

Select last name, first name. FROM emp WHERE last name= 'smith';

Option B

Select last name, first name. FROM emp WHERE UPPER (last name)= 'smith';

Option C

Select last name, first name. FROM emp WHERE last name=UPPER ('smith');

Option D

Select last name, first name. FROM emp WHERE LOWER (last name)= 'smith';

Correct Answer D
Explanation Explanation/Reference: Explanation: Select last name, first name. FROM emp WHERE LOWER (last name)= 'smith' Answer D shows all records with last name Smith because function LOWER returns the column value passed as x into all lowercase Incorrect Answers: A: This command will show only records with last name 'smith'. B: Command UPPER converts all data in last_name column into uppercase. C: This command will show only records with last name 'SMITH'. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 22 Chapter 1: Selecting Data from Oracle


Question ID 8062

You need to analyze how long your orders to be shipped from the date that the order is placed. To do this you must create a report that displays the customer number, date order, date shipped and the number of months in whole numbers from the time the order is placed to the time the order is shipped. Which statement produces the required results?

Option A

SELECT custid, orderdate, shipdate, ROUND(MONTHS_BETWEEN(shipdate,orderdate)) "Time Taken" FROM ord;

Option B

SELECT custid, orderdate, shipdate, ROUND(DAYS_BETWEEN(shipdate,orderdate))/30. FROM ord;

Option C

SELECT custid, orderdate, shipdate, ROUND OFF (shipdate-orderdate) "Time Taken" FROM ord;

Option D

SELECT custid, orderdate, shipdate, MONTHS_BETWEEN (shipdate,orderdate) "Time Taken". FROM ord;

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A shows the number of months (rounded to integer) between the date of order and the date of shipment. Incorrect Answers: B: Function, function DAYS_BETWEEN shows number of days between shipping date and order date. C: Incorrect function ROUND OFF. D: This command will show not rounded to integer value, like 8.6451613. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 30 Chapter 1: Selecting Data from Oracle

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