最新OracleOCP11g考试题库Word格式.docx
- 文档编号:13255079
- 上传时间:2022-10-08
- 格式:DOCX
- 页数:65
- 大小:1.22MB
最新OracleOCP11g考试题库Word格式.docx
《最新OracleOCP11g考试题库Word格式.docx》由会员分享,可在线阅读,更多相关《最新OracleOCP11g考试题库Word格式.docx(65页珍藏版)》请在冰豆网上搜索。
promo_cost*0.25,100)"
Discount"
FROMpromotions;
B.SELECTpromo_id,DECODE(promo_cost,10000,
DECODE(promo_category,'
G1'
promo_cost*.25,NULL),NULL)"
Catcost"
CSELECTpromo_id,DECODE(NULLIF(promo_cost,10000),NULL,
promo_cost*.25,'
N/A'
)"
D.SELECTpromo_id,DECODE(promo_cost,>
10000,'
High'
<
Low'
)
"
Range"
A,B
3.
ViewtheExhibitandexaminethestructureofORDERSandCUSTOMERStables.Thereisonlyonecustomerwiththecust_last_namecolumnhavingvalueRoberts.WhichINSERTstatementshouldbeusedtoaddarowintotheORDERStableforthecustomerwhoseCUSTLASTNAMEisRobertsandCREDITLIMITis600?
A.INSERTINTOordersVALUES(1,'
10-mar-2007'
'
direct'
(SELECTcustomer_id
FROMcustomers
WHEREcustlastname='
Roberts'
AND
credit_limit=600),1000);
B.INSERTINTOorders(order_id,order_date,order_mode,
credit_limit=600),order_total)
VALUES(1,'
&
&
customer_id,1000);
C.INSERTINTO(SELECTo.order_id,o.order_date,o.order_mode,c.customer_id,
o.order_total
FROMorderso,customersc
WHEREo.customer_id=c.customer_id
ANDc.cust_last_name='
ANDc.credit_limit=600|
VALUES(1,'
(SELECTcustomer_id
WHEREcust_last_name='
ANDcredit_limit=600),1000);
D.INSERTINTOorders(order_id,order_date,order_mode,
VALUES(1,'
A
4.
ViewtheExhibitandexaminethestructureoftheCUSTOMERStable.EvaluatethefollowingSQLstatement
SQL>
SELECTcust_city,COUNT(cust_last_name)
WHEREcust_credit_limit>
1000
GROUPBYcust_city
HAVINGAVG(cust_credit_limit)BETWEEN5000AND6000;
Whichstatementistrueregardingtheoutcomeoftheabovequery?
A.Itexecutessuccessfully
B.ItreturnsanerrorbecausetheBETWEENoperatorcannotbeusedintheHAVING
clause
C.ItreturnsanerrorbecauseWHEREandHAVINGclausescannotbeusedinthesameSELECTstatement
D.ItreturnsanerrorbecauseWHEREandHAVINGclausescannotbeusedtoapply
conditionsonthesamecolumn
5.
ViewtheExhibitandexaminethestructureofthePROMOTIONStable.ExaminethefollowingtwoSQLstatements:
WhichstatementistrueregardingtheabovetwoSQLstatements?
A.statement1givesanerror,statement2executessuccessfullyB.statement2givesanerror,statement1executessuccessfullyC.statement1andstatement2executesuccessfullyandgivethesameoutputD.statement1andstatement2executesuccessfullyandgiveadifferentoutput
D
6.
YoucreatedanORDERStablewiththefollowingdescription:
Youinsertedsomerowsinthetable.Aftersometime,youwanttoalterthetablebycreatingthePRIMARYKEYconstraintontheORD_IDcolumn.Whichstatementistrueinthisscenario?
A.Youcannothavetwoconstraintsononecolumn
B.YoucannotaddaprimarykeyconstraintifdataexistsinthecolumnC.TheprimarykeyconstraintcanbecreatedonlyatthetimeoftablecreationD.Youcanaddtheprimarykeyconstraintevenifdataexists,providedthattherearenoduplicatevalues
7.
Whendoesatransactioncomplete?
(Chooseallthatapply.)
A.whenaDELETEstatementisexecuted
B.whenaROLLBACKcommandisexecuted
C.whenaPL/SQLanonymousblockisexecuted
D.whenadatadefinitionlanguage(DDL)statementisexecutedE.whenaTRUNCATEstatementisexecutedafterthependingtransaction
B,D,E
8.
YouneedtodisplaythefirstnamesofallcustomersfromtheCUSTOMERStablethatcontainthecharacter'
e'
andhavethecharacter'
a'
inthesecondlastpositionWhichquerywouldgivetherequiredoutput?
A.SELECTcust_first_name
WHEREINSTR(cust_first_name,'
)<
>
0AND
SUBSTR(cust_first_name,-2,l)='
;
B.SELECTcustfirstname
SUBSTR(cust_first_name,-2,l)='
C.SELECTcust_first_name
)ISNOTNULLAND
SUB
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 最新 OracleOCP11g 考试 题库