关键词：
choose three
Which three are true about the CREATE TABLE command?
A) It can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.
B) The owner of the table should have space quota available on the tablespace where the table is defined.
C) It implicitly executes a commit.
D) It implicitly rolls back any pending transactions.
E) A user must have the CREATE ANY TABLE privilege to create tables,
F) The owner of the table must have the UNLIMITED TABLESPACE system privilege
Answer：ABC
(解析：建表的要求有两个：1、要有表空间的 quota;2、要有 create table 的权限。ddl语句执行后自动提交。)
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... 查看详情