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 8190

You want to retrieve the employee details from the emp table and process them in PL/SQL block. Which type of variable do you create in the PL/SQL block to retrieve all the rows and columns using a single select statement from the emp table?

Option A

PL/SQL record.

Option B

%ROWTYPE variable.

Option C

PL/SQL table of scalars.

Option D

PL/SQL table of records.D

Correct Answer D
Explanation Explanation/Reference: Explanation: Answers D is correct because to retrieve ALL the rows and columns you need to use PL/SQL table of records. Incorrect Answers: A: One PL/SQL record will store only one row, not all rows from the table EMP. B: %ROWTYPE attribute is used to define PL/SQL variable, not to retrieve rows from the table EMP. C: PL/SQL table of scalars will store only scalar types, not columns from the table EMP. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 213-215 Chapter 5: Introducing PL/SQL


Question ID 8191

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