Posts

Showing posts with the label 1z0-001 Introduction to Oracle: SQL and PL/SQL Part 1

1z0-001 Introduction to Oracle: SQL and PL/SQL Part 1

Introduction to Oracle: SQL and PL/SQL  Part 1 Get Full version on: http://www.updateddumps.com/ QUESTION 1 You need to create a report to display the ship date and ordertotals of your ordid table. If the orderhas not been shipped your report must display not shipped. If the total is not available your report must say not available. In the ordid table the ship date column has a data type of date the total column has a data type of number. Which statement do you use to create this report? A. Select ordid, shipdate "Not shipped", total "Not available" FROM order; B. Select ordid, NVL (shipdate, 'Not shipped'), NVL (total, "Not available") FROM order; C. Select ordid, NVL (TO_CHAR (shipdate), 'Not shipped'), NVL (TO_CHAR (total), 'Not available') FROM order; D. Select ordid, TO_CHAR (shipdate, 'Not shipped') TO_CHAR (total, 'Not available') FROM order; Correct Answer: C Explanation: Answer C s...