TestPassPort は試験の問題集の専門を認証して 11g 1Z0-051 最新の問題集のダウンロードを提供して、11g 試験の真実試験問題です、. 最新の 11g 1Z0-051 問題と解答を提供、 Oracle Database: SQL Fundamentals I

VUE/Prometric 試験番号: 1Z0-051

試験の名称: Oracle Database: SQL Fundamentals I

問題と解答: 155 Q&A

更新: 2009-08-18

お客様、ようこそtestpassportへ、私達の商品は品質がよくて、値段も高くないです。ご存じのように、testpassportの試験ガイドを使って、合格率は96％以上です。testpassportはお客様が試験を一度目合格指せる自信があります。

いいニュース

今、www.testpassport.jpの上ので、問題集を買って5％割引ができます。買う時に、testpassportを入力して、すぐ5％割引が楽しめます。

何か質問があるなら、sales@testpassport.jpです、まで、連絡してください。

1Z0-051: ダウンロード 1Z0-051 試験 Software format Demo

6. Examine the structure of the SHIPMENTS table:
name Null Type
PO_ID NOT NULL NUMBER(3)
PO_DATE NOT NULL DATE
SHIPMENT_DATE NOT NULL DATE
SHIPMENT_MODE VARCHAR2(30)
SHIPMENT_COST NUMBER(8,2)
You want to generate a report that displays the PO_ID and the penalty amount to be paid if the
SHIPMENT_DATE is later than one month from the PO_DATE. The penalty is $20 per day.
Evaluate the following two queries:
SQL> SELECT po_id, CASE
WHEN MONTHS_BETWEEN (shipment_date,po_date)>1 THEN
TO_CHAR((shipment_date - po_date) * 20) ELSE 'No Penalty' END PENALTY
FROM shipments;
SQL>SELECT po_id, DECODE

(MONTHS_BETWEEN (po_date,shipment_date)>1,
TO_CHAR((shipment_date - po_date) * 20), 'No Penalty') PENALTY
FROM shipments;
Which statement is true regarding the above commands?
A. Both execute successfully and give correct results.
B. Only the first query executes successfully but gives a wrong result.
C. Only the first query executes successfully and gives the correct result.
D. Only the second query executes successfully but gives a wrong result.
E. Only the second query executes successfully and gives the correct result.
Answer: C
7. Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
A. Both USING and ON clauses can be used for equijoins and nonequijoins.
B. A maximum of one pair of columns can be joined between two tables using the ON clause.
C. The ON clause can be used to join tables on columns that have different names but compatible data
types.
D. The WHERE clause can be used to apply additional conditions in SELECT statements containing the
ON or the USING clause.
Answer: CD