Oracle 1Z0

大家好，我在http://download.csdn.net/source/836323上发的帖子，确实只是个demo，其题库内容见下文，此为最新题库的一部分，正式版题库是175题。需要正式版本的朋友，可以直接联系我或者到www.certinside.cn/1z0-051  上面看看，我们和testinside是一家的，需要的话我可以给你打个折，价格再议。我的QQ：390970748　
　
Exam   :  Oracle 1Z0-051
Title    :  Oracle Database: SQL Fundamentals I
1. Evaluate the following query:
SQL> SELECT promo_name  q'{'s start date was }'  promo_begin_date
AS "Promotion Launches"
from promotions;
What would be the outcome of the above query?
A. It produces an error because flower braces have been used.
B. It produces an error because the data  types are not matching.
C. It executes successfully and introduces an  's at the end of each promo_name in the output.
D. It executes successfully and displays the literal " {'s start date was } " for each row in the output.
Answer: C
2. Which statement is true regarding the INTERSECT operator?
A. It ignores NULL values.
B. Reversing the order of the intersected tables alters the result.
C. The names of columns in all SELECT statements must be identical.
D. The number of columns and data  types must be identical for all SELECT statements in the query.
Answer: D
3. 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_DA