Posts Tagged ‘1z0-051’

1Z0-051

datePosted on 02:29, January 22nd, 2009 by killtest_does

Other Oracle Certification 1Z0-051 考試題庫由我們的資深IT認證講師及產品專家精心打造,包括了當前最新的全套全真1Z0-051考試試題,全部附有正確答案。所有購買本站認證考題的客戶都將得到60天的免費升級服務,保證了對Oracle Database: SQL Fundamentals I考試題庫的完整覆蓋。 助妳壹次通過 Oracle Database: SQL Fundamentals I 認證考試,壹次不過全額退款!

1、1Z0-051考題都是1Z0-051證照考試試題原題,對正式考試覆蓋率達96%以上,答案由多位專業資深講師原版破解得出,正確率100%,只要您使用本站的題庫參加 Oracle Database: SQL Fundamentals I 證照考試,我們保證您壹次輕松通過考試;

2、售後服務第壹!我們相信要想在當今時代取得成功,必須為廣大用戶提供全套的周到細致的全程優質售後服務,只有客戶滿意了,我們才能發展。

3、我們實行“壹次不過全額退款”承諾。如果您購買我們的考題,只要不是首次通過,憑蓋有PROMETRIC或VUE考試中心鋼印的考試成績單,我們將退還您購買 1Z0-051 考題的全部費用,絕對保證您的利益不受到任何的損失;

4、1Z0-051考題根據廠家考試的變化動態更新,在廠家考題每次發生變化後,我們承諾2天內更新1Z0-051:Oracle Database: SQL Fundamentals I題庫。確保Other Oracle Certification 1Z0-051 exam的覆蓋率始終都在96%以上。

1z0-051

datePosted on 02:28, December 25th, 2008 by killtest_does

在Oracle9I中,Oracle提供了3級認證:1、Oracle輔助OCA——這項較低級的認證是Oracle專為那些僅通過OCP兩項考試的人員設計的初級技能水平考試,是使用Oracle產品的基礎。要獲得OCA證書,必須通過自己選擇的認證途徑上的兩次考試。第壹次可以通過Internet進行,第二次考試則必須在授權的Prometric國際考試中心進行。2、Oracle9I專業認證OCP——Oracle專業認證要求通過4門具有壹定難度的考試,以證實在Oracle數據庫管理領域內的熟練程度。

專家級技能和技術知識考試,通過這種考試之後,說明此人可以管理大型數據庫,或者能夠開發可以部署到整個企業的強大應用。要成為OCP,必須先獲得OCA證書,然後才能參加OCP要求的其他考試。參加OCP認證的學員必須至少在Oracle大學或者其授權培訓中心學習壹門課程才能獲得OCP證書。這些考試也必須在授權的國際認證考試中心進行。獲得OCP證書後,您將有機會申請更高的職位,並增強老板對您的信任和支持。

1Z0-051Oracle Database: SQL Fundamentals I

1. Evaluate the following CREATE TABLE commands:
CREATE TABLE orders
(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,
ord_date DATE,
cust_id NUMBER(4));
CREATE TABLE ord_items
(ord_no NUMBER(2),
item_no NUMBER(3),
qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200),
expiry_date date CHECK (expiry_date > SYSDATE),
CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no),
CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));
The above command fails when executed. What could be the reason?
A.SYSDATE cannot be used with the CHECK constraint.
B.The BETWEEN clause cannot be used for the CHECK constraint.
C.The CHECK constraint cannot be placed on columns having the DATE data type.
D.ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY.
Answer: A

2. SLS is a private synonym for the SH.SALES table.
The user SH issues the following command:
DROP SYNONYM sls;
Which statement is true regarding the above SQL statement?
A.Only the synonym would be dropped.
B.The synonym would be dropped and the corresponding table would become invalid.
C.The synonym would be dropped and the packages referring to the synonym would be dropped.
D.The synonym would be dropped and any PUBLIC synonym with the same name becomes invalid.
Answer: A
3. Which statement is true regarding the default behavior of the ORDER BY clause?
A.In a character sort, the values are case-sensitive.
B.NULL values are not considered at all by the sort operation.
C.Only those columns that are specified in the SELECT list can be used in the ORDER BY clause.
D.Numeric values are displayed from the maximum to the minimum value if they have decimal positions.
Answer: A