关键词：
Choose the best answer.Examine this query:
SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL;
What is the result?
A) 16
B) 160
C) 150
D) 200
E) 100
Answer：D
(解析：关键就是 round 函数，0 是小数点左边第一位，以此类推。)
2019年8月版本ocp071认证考试最新版本的考试原题-第2题
choosethreeWhichthreearetrueabouttheCREATETABLEcommand?A)ItcanincludetheCREATE...INDEXstatementforcreatinganindextoenforcetheprimarykeyconstraint.B)Theownerofthetableshouldhavespacequotaavailableonthetablespacewherethetableisdefined.C)Itimplicitlyexecutesacommit.D)Itimplicitlyrollsbackanypendingtran... 查看详情
2019年8月版本ocp071认证考试最新版本的考试原题-第11题
Choosetwo.Whichtwostatementsaretrueaboutaselfjoin?A)Thejoinkeycolumnmusthaveanindex.B)Itcanbealeftouterjoin.C)Itmustbeafullouterjoin.D)Itcanbeaninnerjoin.E)Itmustbeanequiejoin.Answer：BD(自连接其实跟两张表的连接一样。可以是等连接、左右外连接等等。不过在进行内连... 查看详情
2019年8月版本ocp071认证考试最新版本的考试原题-第6题
choosethreeWhichthreestatementsaretrueaboutindexesandtheiradministrationinanOradedatabase?A)AnINVISIBLEindexisnotmaintainedwhenDataManipulationLanguage(DML)isperformedonitsunderlyingtable.B)AnindexcanbecreatedaspartofaCREATETABLEstatement.C)ADROPINDEXstatementalwayspreventsupdatestothetableduringthe... 查看详情
2019年8月版本ocp071认证考试最新版本的考试原题-第5题
choosethebestanswerTheCUSTOMERStablehasaCUST_LAST_NAMEcolumnofdatatypeVARCHAR2.ThetablehastworowswhoseCOST_LAST_MANEvaluesareAndersonandAusson.WhichqueryproducesoutputforCUST_LAST_SAMEcontainingOrderforthefirstrowandAusforthesecond?A)SELECTREPLACE(REPLACE(cust_last_name,‘son‘,‘‘),‘An‘,... 查看详情
2019年8月ocp071认证考试最新版本的考试原题-第14题
Choosetwo.ExaminethisSQLstatement:UPDATEordersoSETcustomer_name=(SELECTcust_last_nameFROMcustomersWHEREcustomer_id=o.customer_id);Whichtwoaretrue?A)ThesubqueryisexecutedbeforetheUPDATEstatementisexecuted.B)AllexistingrowsintheORDERStableareupdated.C)ThesubqueryisexecutedforeveryupdatedrowintheORDERS... 查看详情
2019年8月ocp071认证考试最新版本的考试原题-第15题
ChoonethreeExaminethedescriptionofthePRODUCTStable:NameNull?TypePRODUCT_IDNOTNULLNUMBER(2)PRODUCT_NANEVARCHAR2(10)UNIT_PRICENUMBER(3)PURCHARGEVARCHAR2(2)EXPIRY_DATEDATEDELIVERY_DATEDATEWhichthreequeresusevalidexpressions?A)SELECTproduet_id,unit_pricer,5"Discount",unit_price+purcharge-disco... 查看详情
2019年8月版ocp071认证考试原题-第43题
Choosetwo.Youexecutethiscommand:TRUNCATETABLEdepts;Whichtwoaretrue?A)Itdropsanytriggersdefinedonthetable.B)Itretainstheindexesdefinedonthetable.C)Itretainstheintegrityconstraintsdefinedonthetable.D)AROLLBACRstatementcanbeusedtoretrievethedeleteddata.E)Italwaysretainsthespaceusedbytheremovedrows.F)AF... 查看详情
2019年8月版ocp071认证考试原题-第41题
choosethreeTheORDERStablehasaprimarykeyconstraintontheORDER_IDcolumn.TheORDER_ITEMStablehasaforeignkeyconstraintontheORDER_IDcolumn,referencingtheprimarykeyoftheORDERStable.TheconstraintisdefinedwithonDELETECASCADE.TherearerowsintheORDERStablewithanORDER_TOTALlessthan1000.WhichthreeDELETEstatementse... 查看详情
2019年8月版ocp071认证考试原题-第43题
Choosetwo.Youexecutethiscommand:TRUNCATETABLEdepts;Whichtwoaretrue?A)Itdropsanytriggersdefinedonthetable.B)Itretainstheindexesdefinedonthetable.C)Itretainstheintegrityconstraintsdefinedonthetable.D)AROLLBACRstatementcanbeusedtoretrievethedeleteddata.E)Italwaysretainsthespaceusedbytheremovedrows.F)AF... 查看详情
2019年8月版ocp071认证考试原题-第40题
Choosetwo.Whichtwostatementsaretrueaboutsinglerowfunctions?A)CONCAT:canbeusedtocombineanynumberofvaluesB)MOD:returnsthequotientofadivisionoperationC)CEIL:canbeusedforpositiveandnegativenumbersD)FLOOR:returnsthesmallestintegergreaterthanorequaltoaspecifiednumberE)TRUNC:canbeusedwithNUMBERandDATEvalue... 查看详情
2019年8月版ocp071认证考试原题-第41题
choosethreeTheORDERStablehasaprimarykeyconstraintontheORDER_IDcolumn.TheORDER_ITEMStablehasaforeignkeyconstraintontheORDER_IDcolumn,referencingtheprimarykeyoftheORDERStable.TheconstraintisdefinedwithonDELETECASCADE.TherearerowsintheORDERStablewithanORDER_TOTALlessthan1000.WhichthreeDELETEstatementse... 查看详情
2019年8月版ocp071认证考试原题-第42题
ChoosetwoExaminethisSQLstatement:DELETEFROMemployeeseWHEREEXISTS(SELECT‘dummy‘FROMemp_historyWHEREemployee_id=e.employee_id)Whichtwoaretrue?A)ThesubqueryisexecutedforeveryrowintheEMPLOYEEStable.B)Thesubqueryisnotacorrelatedsubquery.C)ThesubqueryisexecutedbeforetheDELETEstatementisexecuted.D)Alle... 查看详情
2019年8月版ocp071认证考试原题-第39题
ChoosetwoExaninethedesatptionoftheBOOKS_TRANSACTIONStableNameNull?TypeTRANSACTION_IDNOTNULLVARCHAR2(6)TRANSACTION_TYPEVARCHAR2(3)BORROWED_DATEDATEBOOK_IDARCHAR2(6)MEMBER_IDVARCHAR2(6)ExaminethispartialSQLstatement:SELECT*FROMbooks_transctions;WhichtwoWHEREcondtionsgivethesameresut?A)WHEREborrowed_da... 查看详情
2019年8月版ocp071认证考试原题-第37题
ChoosethebestanswerExaminethedescriptionofthePRODUCT_INFORMATIONtable:NameNULL?TypePROD_IDNOTNULLNUMBER(2)PROD_NANEVARCRAR2(10)LIST_PRICENUMBER(6,2)Whichqueryretrievesthenumberofproductswithanulllistprice?A)SELECT(COUNT(list_price)FERMProduct_intormationWHERElist_price=NULL;B)SELECTCount(nvl(list_pr... 查看详情
ocp-12c2019年cuugocp071考试题库（74题）
74、ViewtheexhibitandexaminethestructureofORDERSandCUSTOMERStables.ORDERSNameNull?TypeORDER_IDNOTNULLNUMBER(4)ORDER_DATENOTNULLDATEORDER_MODEVARCHAR2(8)CUSTOMER_IDNOTNULLNUMBER(6)ORDER_TOTALNUMBER(8,2)CUSTOMERSNameNull?TypeCUSTOMER_IDNOTNULLNUMBER(6)CUST_FIRST_NAMENOTNULLVARCHAR2(20)CUST_LAST_NAMEN... 查看详情
ocp-12c2019年cuugocp071考试题库（75题）
75、Whichstatementsarecorrectregardingindexes?(Chooseallthatapply.)A.Anon-deferrablePRIMARYKEYorUNIQUEKEYconstraintinatableautomaticallyattemptstocreatesauniqueindex.B.Indexesshouldbecreatedoncolumnsthatarefrequentlyreferencedaspartofanyexpression.C.Whenatableisdropped,thecorrespondingindexesareaut... 查看详情
ocp-12c2019年cuugocp071考试题库（77题）
77、Whichtwostatementsaretrueaboutsequencescreatedinasingleinstancedatabase?(Choosetwo.)A.WhentheMAXVALUElimitforthesequenceisreached,youcanincreasetheMAXVALUElimitbyusingtheALTERSEQUENCEstatement.B.DELETE<sequencename>wouldremoveasequencefromthedatabase.C.Thenumbersgeneratedbyasequencecanbeu... 查看详情
ocp-12c2019年cuugocp071考试题库（77题）
77、Whichtwostatementsaretrueaboutsequencescreatedinasingleinstancedatabase?(Choosetwo.)A.WhentheMAXVALUElimitforthesequenceisreached,youcanincreasetheMAXVALUElimitbyusingtheALTERSEQUENCEstatement.B.DELETE<sequencename>wouldremoveasequencefromthedatabase.C.Thenumbersgeneratedbyasequencecanbeu... 查看详情