文档介绍：Exam :1Z0-001
Title:Introduction to Oracle: SQL and PL/SQL
Version Number:
Fast Way to get your Certification
Real Level Practice Questions Guides
Important Note:
Please Read Carefully
This Study Guide has been carefully written piled by correctexams experts. It is designed to help you
learn the concepts behind the questions rather than be a strict memorization tool. Repeated readings will
increase prehension.
We continually add to and update our Study Guides with new questions, so check that you have the latest
version of this Guide right before you take your exam.
For security purposes, each PDF file is encrypted with a unique serial number associated with your correct
Exams account information. In accordance with International Copyright Law, correctexams reserves the right to
take legal action against you should we find copies of this PDF file has been distributed to other parties.
Please tell us what you think of this Study Guide. We appreciate both positive and ments as your
feedback helps us improve future versions.
We thank you for buying our Study Guides and look forward to supplying you with all your Certification
training needs.
Good studying!
correctexams Technical and Support Team
Fast Way to get your Certification
QUESTION NO: 1
You need to create a report to display the ship date and order totals of your ordid
table. If the order has 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 shippe