




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
(新)OCP认证082考试题库及答案
一、单选题
1.ViewtheExhibitsandexaminethestructureofthecostsandPROMOTIONStabIes
YouwanttodispIayPRODIDSwhosepromotioncostisIessthanthehighestcostPROD
IDinapromotiontimeintervaI
13COSI8TMtFROMOTXXJS
NE
Name
NuW?TypePROMOJOI
PROMONAVENO1KUU.|vARCHAH2(30)|
KMfAm阳;Hm阳m1
TIMEJDNOTNULLDAYE
PROMOSUEiCAIfcGORYJDNOTNUU.NUVBtR
PROMOJDNUMBER一
NOTNULLPROMO.CATtGORYKOISULLVARCHAR2(30j
二NOTHULLNUMBER~~阳6V。一匕ATEGORY」。SOTNULLNUMBER
万PR0U6cdir
UMT_COSTNOTNULLNUMBER0O
kUI/BERHoilPROMOBEGINDAUNOTHULLlDATE
UNITPRICENOTNULLPROMODATt2TSULL|DATt
ExaminethisSQLstatement
SELECTprod_id
FROMcosts
WHEREproao_idIN
(SELECTpr8O_id
FROMpromotions
WHEREpromo-cost<ALL
(SELECTHAX(promo_COSt)
FROMpromotions
GROUPBY(oromoenddate-croaobegindate)));
WhatwiIIbetheresult?
A、ItexecutessuccessfuIIyandgivestherequiredresu11.
B、ItgivesanerrorbecausetheGROUPBYcIauseisnotvaIid
C、ItexecutessuccessfuIIybutdoesnotgivetherequiredresu11
D、ItgivesanerrorbecausetheALLkeywordisnotvaIid
答案:C
2.ExaminethedescriptionoftheSATESItabIe
SALES2isatabIewiththesamedescriptionassAIeS1SomesaIesdataiscontainede
rroneousIyinbothtabIes
YoumustdispIayrowsfromsAIEs1andSALESandwishtoseethedupIicatestooWhich
setoperatorgeneratestherequiredoutput?
NameNullType
SALESIDNOTNULLNUMBER
STOREIDNOTNULLHUMBER
ITEMS-IDNUMBER
QUANTITYNUMBER
SALESDATE
A、MINUS
B、UNIONALL
C、SUBTRACT
D、UNION
E、INTERSECT
答案:B
3.YourdatabaseinstanceisstartedwithaPFILE.
Examinetheseparameters:
NAMETYPEVALUE
memory_max_targetbiginteger0
memory_targetbiginteger0
sga_max_sizebiginteger2G
sga_targetbiginteger2G
Youwanttoincreasethesizeofthebuffercache.FreememoryisavaiIabIetoincre
asethesizeofthebuffercache.Youexecutethemand:SQL>ALTERSYSTEMSETDB_CAC
HE_SIZE=1024M;
Whatistheoute?
AvThevaIueischangedonIyinthePFILEandtakeseffectatthenextinstancestar
tup
B、ThevaIueischangedforthecurrentinstanceandinthePFILE
C、ItfaiIsbecausetheSCOPEcIauseismissing
D、ChangeisappIiedtothecurrentinstance,butdoesnotpersistafterinstance
restart
答案:D
4.WhichstatementistrueaboutdatabaseIinks?
A、AdatabaseIinkcreatedinadatabaseaIIowsaconnectionfromthatdatabase's
instancetothe
Targetdatabase'sinstance,butnotviceversa
B、PrivatedatabaseIinkcreationrequiresthesameusertoexistinboththeIoca
Iandtheremotedatabases
CxApubIicdatabaseIinkcanbeusedbyauserconnectedtotheIocaIdatabaseinst
ancetoconnecttoanyschemaintheremotedatabaseinstance
DxApubIicdatabaseIinkcanbecreatedonIybysys
E、AdatabaseIinkcanbecreatedonIybetweentwoOracIedatabases
答案:c
5.WhichstatementistrueabouttheINTERSECToperatorusedinpoundqueries?
AxMultiple!NTERSECToperatorsarenotpossibIeinthesameSQLstatement
B、ItprocessesNULLSintheseIectedcoIumns
C、INTERSECTisoflowerprecedencethanUNIONorUNIONALL
D、ItignoresNULLS
答案:B
6.YourdatabaseinstanceisstartedwithanSPFILEAPFILEisalsoavaiIable
Youexecutethismand
ALTERSYSTEMSETDBCACHESIZE=100K
WhereisthevaIuechanged?
A、intheSPFILEandPFTIE
BxintheSPFILE,PFILE,andmemory
C、onlyintheSPFILE
D、intheSPFILEandinmemory
Exonlyinmemory
答案:D
7.ExaminethedescriptionofthePRODUCTINEORMATTONtabIe
Naa«Null?Typ«
PROD_IDNOTNULLNUMBER(2)
PROD二NAMtVARCHAK2(10)
LIST二PRX3NUMBER2)
WhichqueryretrievesthenumberofproductswithanuIllistprice?
A、SELECTCOUNT(Iistprice)FROMproductinformationWHEREIistpriceNULL
B、SELECTCOUNT(Iistprice)FROMproductinformationWHEREIistpriceIsNULL,
C、SELECTCOUNT(DISTINCTIistprice)PROMproductinformationWHEREIistprice
IsNULL:
D、SELECTCOUNT(NVL(Iistprice,0))FROMproductinformationWHEREIistpriceI
sNULL
答案:D
8.ExaminethedescriptionoftheEMPLOYEEStabIeNISDATEFORMATissettoDD-MON-
YY
WhichqueryrequiresexpIicitdatatypeconversion?
A、SELECTjoindateFROMempIoyeesWHEREjoindate>'10-02-2018';
B、SELECTjoindate||f'|IsalaryFROMemployees
GSELECTsaIary+'120.50'FROMempIoyees
D、SELECTSUBSTR(join_date,1,2)-1OFROMempIoyees
ExSELECTjoindate+'20'FROMempIoyees
答案:A
9.Whatistrueaboutnon-equiJoinstatementperformance?
A、Thejoinsyntaxusedmakesnodifferencetoperformance.
B、TheBETWEENconditionusedwithannon-equijoinsometimesperformsbetterth
anusingthe>=and<=conditions
CxTheBETWEENconditionusedwithannon-equijoinaIwaysperformsbetterthanw
henusingthe>=andUconditions
D、TheOracIejoinsyntaxperformsbetterthanthesoI:1999pIiantANSIjoinsynt
ax
ExTheOracIejoinsyntaxperformsIessweIIthanthesoI:1999pIiantANSIjoinsy
ntax
答案:A
10.Adatabaseisconfiguredtouseautomaticundomanagementwithtemporaryundo
enabIedAnUPDATEisexecutedonatemporarytabIe
WhereistheUNDOstored?
AxintheundotabIespace
B、intheSYSAUXtabIespace
CxintheSGA
D、inthePGA
E、inthetemporarytabIespace
答案:E
11.ExaminethedescriptionoftheCUSTOMERStabIe:
NameNull?Type
CUST-IDNOTNULLNUMBER
CUST_FIRST_NAMENOTNULLVARCHAR2(20)
CV3T_IAST_NAMENOTNULLVARCKAR2(30)
CU3T_INC<XE_LEVELVARCHAR2(30)
CUSTCREDITLIMITNUMBER
ForcustomerswhoseineIeveIhasavaIue,youwanttodispIaythefirstnameanddue
amountas5%
OftheircreditIimit.CustomerswhosedueamountisnuIIshouIdnotbedispIayed.
WhichqueryshouIdbeused?
A、SELECTcust_first_name,cust_credit_limit*.05ASDUE_AM0UNT
FROMcustomersWHEREcust_ins_levelISNOTNULLANDdue_amountISNOTNULL;
B、SELECTcust_first_name,cust_credit_limit*.05ASDUE_AM0UNT
FROMcustomersWHEREcust_ine_leveI!=NULLANDcust_credit_leveI!=NULL;
CxSELECTcust_first_name,cust_credit_limit*.05ASDUE_AM0UNT
FROMcustomersWHEREcust_ine_leveI<>NULLANDdue_amountONULL;
D、SELECTcust_first_name,cust_credit_limit*.05ASDUE_AM0UNT
FROMcustomersWHEREcust_ine_leveI!=NULLANDdue_amount!=NULL;
ExSELECTcust_first_name,cust_credit_limit*.05ASDUE_AM0UNTFR0Mcustome
rsWHEREcust_ine_IeveIISNOTNULLANDcust_credit_IimitISNOTNULL;
答案:E
12.YouwanttowriteaquerythatpromptsfortwocoIumnnamesandtheWHEREconditi
oneachtimeitIs
ExecutedinasessionbutonIypromptsforthetabIenamethefirsttimeitisexecut
edThevariabIesusedinyourqueryareneverundefinedinyoursession
Whichquerycanbeused?
A、SELECT&&co11&&co2FR0M&tabIeWHERE&&condition=&&cond
B、SELECT&coI1&C012FR0M&&tabIeWHERE&condition
C、SELECT&coI1&C012FR0M&tableWHERE&condition
D、ELECT&&co11&&coFR0M&tabIeWHERE&&condition=&cond
E、SELECT&&co11&&C0L2FR0M&tableWHERE&&condition
答案:B
13.WhichpressionmethodisremendedforDirect-PathInsertoperations?
A、COLUMNSTOREPRESSADVANCED
B、ROWSTOREPRESSADVANCED
C、COLUMNSTOREPRESSBASIC
D、ROWSTOREPRESSBASIC
答案:D
14.YouwanttousetabIepressionsuitabIeforOLTPthatwiII:1-pressrowsforaII
DMLstatementsonthattabIe
2-MinimizetheoverheadsassociatedwithpressionWhichpressionoptionisbest
suitedforthis?
A、COLUMNSTOREPRESSFORQUERYLOW
B、ROWSTOREPRESSBASIC
C、COLUMNSTOREPRESSFORARCHIVELOW
D、COLUMNSTOREPRESSFORARCHIVEHIGH
E、ROWSTOREPRESSADVANCED
答案:E
15.ExaminethedescriptionoftheCUSTOMERStabIe
NameIWType
CUSTJDNOTNULLVARCHAR2(6)
nRST_NAMEVARCHAR2(50)
LAST-NAMENOTNULLVARCHAR2(50)
ADDRESSVARCHAR2(50)
CITYVARCHAR2(25)
YouwanttodispIaydetaiIsofaIIcustomerswhoresideincitiesstartingwiththe
letterDfollowedbyat
LeasttwocharactersWhichquerycanbeused?
A、SELECT"FROMcustomersWHEREcityLIKED
B、SELECT*FROMcustomersWHERE
C、SELECT"FROMcustomersWHEREcityLIKED
D、SELECT"FROMcustomersWHEREcity=D
答案:A
16.WhichisthedefauItooIumnorcoIumnsforsortingoutputfrompoundqueriesus
ingSEToperatorssuchasINTERSECTinaSQLstatement?
AxthefirstNUMBERorVARCHAR2coIumnintheIastseIectofthepoundquery
BxthefirstNUMBERcoIumninthefirstseIectofthepoundquery
C、thefirstvARCHAR2coIumninthefirstseIectofthepoundquery
D、thefirstcolumninthefirstseIectofthepoundquery
E、thefirstcoIumnintheIastseIectsofthepoundquery
答案:D
17.YouhavebeentaskedtocreateatabIeforabankingappIicationOneofthecoIum
nsmustmeetthreerequirements:
Bestoredinaformatsupportingdatearithmeticwithoutusingconversionfuncti
onsStoreaIoanperiodofuptolOyears
BeusedforcaIculatinginterestforthenumberofdaystheIoanremainsunpaidWhi
chdatatypeshouIdyouuse?
A、INTERVALYEARTOMONTH
B、INTERVALDAYTOSECOND
GTIMESTAMPWITHLOCALTIMEZONE
D、TIMESTAMP
E、TIMESTAMPWITHTIMEZONE
答案:B
18.InthespfiIeofasingleinstancedatabase,LOCALLISTENERissettoLISTENER1.
TheTNSNAMESORAfileinSORACLEHOME/network/admininthedatabasehomecontain
s:LISTENER仁
(ADDRESS二(PROTOCOL=TCP)
(H0ST=host1abc.)(P0RT=1521)
)
Whichstatementistrue?
AxTherearetwoIistenersnamedLISTENERandLISTENER1runningsimuItaneousIy
usingportl521onthesamehostasthedatabaseinstances
B、ThedefinitionforLISTENER1requiresaCONNECTDATAsectiontoenabIedynami
cserviceregistration
GLISTENER1mustaIsobedefinedintheLISTENER.ORAfiIetoenabIedynamicserv
iceregistration
DxTheLREGprocessregistersservicesdynamicallywiththeLISTENER_1Iistene
r
ExDynamicserviceregistrationcannotbeusedforthisdatabaseinstance
答案:A
19.InthespfiIeofasingleinstancedatabase,LOCALLISTENERissettoLISTENER.
1
TheTNSNAMES.ORAfiIeinSORACLEHOME/network/admininthedatabasehomecontai
ns
LISTENER」=
(ADDRESS>
(PROTOCOL«TCP)
(HOST=hoMlabccom)
(PORT»1521)
)
Whichstatementistrue?
AxDynamicserviceregistrationcannotbeusedforthisdatabaseinstance
B、TheLREGprocessregistersservicesdynamicallywiththeLISTENERIIistener
C、LISTENER_1mustaIsobedefinedintheLISTENER.ORAfiIetoenabIedynamicser
viceregistration
D、TherearetwoIistenersnamedLISTENERandLISTENER1runningsimuItaneousIy
usingport1521onthesamehostasthedatabaseinstances
ThedefinitionforLISTENER1requiresaCONNECTDATAsectiontoenabIedynamicse
rvice
答案:D
20.TheCUSTOMERStablehasaCUST_LASTNAMEcoIumnofdatatypeVARCHAR2ThetabIe
hastworowswhoseCUST_LASTNAMEvaIuesareAndersonandAusson
WhichqueryproducesoutputforCUST_LASTNAMEcontainingoderforthefirstrowa
ndAusforthe
Second?
A、SELECTREPLACE(SUBSTR(cust_Iast_name,-3),'AN',"0')FROMcustomers;
B、SELECTINITCAPREPLACE(TRIM('S0NFR0Mcust_Iast_namE.,1AN,'0'))FROM
Customers;
C、SELECTREPLACE(TRIM(TRAILINGHS0N'FR0McustIastnamE.,*AN,'O')FROM
Customers
DxSELECTREPLACE(REPLACE(oustlastname,'son','),'AN','O')FROMcustomers;
答案:D
21.ExaminethedescriptionoftheproductstabIe
NameNull?
PRODNAMEVARCHAR2(40)
COSTNUMBER(H•Z)
A、SELECTprodid,AVG(MAX(cost))FROMproductsGROUPBYprod.
BvSELECTprodid,MAX(AVG(cost))FROMproductsGROUPBYprodid:
GSeIectprodid,reIeasedate,SUM(cost)FROMproductsGROUPBYprodid
D、SELECTprodid,reIeasedate,SUM(cost)FROMproductsGROUPBYprodid,reIeas
edate
答案:D
多选题
1.WhichthreestatementsaretrueaboutsequencesinasingleinstanceOracIedat
abase?
AvAsequencenumberthatwasaIIocatedcanberoIIedbackifatransactionfaiIs
BvAsequencecanonIybedroppedbyaDBA
C、SequencescanaIwayshavegaps
DvAsequencecanissuedupIicatevaIues.
E、Asequence'sunaIIocatedcachedvaIuesareIostiftheinstanceshutsdown
F、TwoormoretabIescannothavekeysgeneratedfromthesamesequence
答案:CDE
2.WhichthreestatementsaretrueaboutusingSQL*PIus?
A、ItcanrunscriptspassedtoitbyasheIIscript.
B、ItcanrunscriptsenteredattheSQLprompt
C、Ithasbothmand-lineandgraphicaIuserinterfaces(Gun)
D、IthasitsownmandsthatareseparatefromanySQLstatements
E、ItcanrunRecoveryManager(RMAN)mands
F、ItmustbedownIoadedfromtheOracIeTechnoIogyNetwork(OTN)
答案:BCD
3.Examinethesemands
[oracleghostOlsqlplusul/oracle
SQL>SELECT*FROMemp;
ENOENAMEDN
1Alan2
23en2
SQL>exit
[oracleghostOlcatemp.dat
.t2
3,Curl,4
4,Bob,4
[oracleShostOl*•]Ssqlldrul/oracle
WhichtwostatementsaretrueaboutthesqIIdrexecution?
A、ItoverwritesthedataforAIanandaddsdataforCurIandBob
B、ItgeneratesasqIscriptthatitusestoIoaddatafromEMP.DATtoEMP
C\ItoverwritesaIIdatainEMPwithdatafromEMP.DAT.
D、ItgeneratesaIogthatcontainscontroIfiIeentries,whichcanbeusedwithno
rmaISQL*Loaderoperations
ExItappendsdatafromEMP.DATtoEMP.
答案:DE
4.Whichtwostatementsaretrueaboutundosegmentsandtheuseofundobytransact
ionsinanOracle
Databaseinstance
AxAsingIetransactionmayusemuItipleundosegmentssimuItaneousIy.
BxUndosegmentscanbestoredintheSYSAUXtabIespace
C、UndosegmentscanextendwhenatransactionfiIIstheIastextentoftheundose
gment
DxUndosegmentscanwraparoundtothefirstextentwhenatransactionfiIIstheI
astextendoftheundosegment
E、UndosegmentscanbestoredintheSYSTEMtabIespace
答案:DE
5.WhichtwostatementsaretrueaboutsubstitutionvariabIes?
A、AsubstitutionvariabIeusedtopromptforacoIumnnamemustbeencIosedindou
bIequotationmarks.
B、AsubstitutionvariabIeprefixedwithsaIwayspromptsonIyonceforavaIuein
asession
C、AsubstitutionvariabIeusedtopromptforacoIumnnamemustbeencIosedinsin
gIequotationmarks
D、AsubstitutionvariabIeprefixedwith&&promptsonIyonceforavaIueinasess
ionunIessitissettoundefinedinthesession
E、AsubstitutionvariabIecanbeusedonIyinaSELECRstatement
F、AsubstitutionvariabIecanbeusedwithanycIauseinaseIectstatement
答案:DF
6.TheORDERStabIehasacoIumnORDERDATEofdatatypeDATE.ThedefauItdispIayfo
rmatforadateisDD-MON-RR
WhichtwoWHEREconditionsdemonstratethecorrectusageofconversionfunction
s?
A、WHEREorderdateTODATE(ADDMONTHS(SYSDATE,6),'MONDDYYYY')
B、WHERETOCHAR(orderdate,'MONDDYYYY')="JAN202019,
C、WHEREorderdate>TODATE(JUL102018','NONDDYYYY')
D、WHEREorderdateTOCHAR(ADDMONTHS(SYSDATE,6),'MONDDYYYY)
E、WHEREorderdateIN(ToDATE('oct212018','monDDYYYY'),roCHAR('Nov212018
'MonDDYYYY'))
答案:BC
7.Inoneofyourdatabases,youcreateauser,HR,andthenexecutethismandGRANTC
REATESESSIONTOhrWITHADMINOPTION:
WhichthreeactionscanHRperform?
AxGranttheCREATESESSIONpriviIegewithADMTNOPTIONtootherusers
B、Logintothedatabaseinstance.
CxRevoketheCREATEsessionpriviIegefromotherusers
D、ExecuteDDLstatementsintheHRschema
E、ExecuteDMLstatementsintheHRschema
F、RevoketheCREATESESSIONprivilegefromuserHR
答案:ACF
8.WhichthreestatementsaretrueaboutsingIe-rowfunctions?(Choosethree.)
AxTheycanbeusedonIyintheWHEREcIauseofaSELECTstatement
B、TheargumentcanbeacoIumnname,variabIe,IiteraIoranexpression
CxThedatatypereturnedcanbedifferentfromthedatatypeoftheargument
D、TheycanbenestedtoanyIeveI
E、TheycanacceptonIyoneargument
TheyreturnasingleresuItrowpertabIe
答案:BCD
9.WhichthreestatementsaretrueabouttheAutomaticDiagnosticRepository(AD
R)?
Ax11isafiIe-basedrepositoryheIdoutsideanydatabase
B、TheADRbaseisspecifiedintheDIAGNOSTICDESTdatabaseparamete
C、11isonIyusedforOracIeDatabasediagnosticinformation
D、11isheIdinsideanOracIedatabaseschema
E、ItcanbeusedforprobIemdiagnosisofadatabasewhenthatdatabase'sinstanc
eisdow
答案:ABE
10.WhichthreestatementsaretrueaboutaseIfjoin?
AxItcanbeanouterjoin
BxTheONcIausecanbeused
CxThequerymustusetwodifferentaIiasesforthetabIe
DxItmustbeanequijoin
E、Itmustbeaninnerjoin
F、TheONcIausemustbeused
答案:ABC
11.1nthePROMOTIONstabIe,thePROMOBEGINDATEcoIumnisofdatatypeDATEandthe
defauItdateformatisDD-MON-RR
WhichtwostatementsaretrueaboutexpressionsusingPROMOBEGINDATEcontained
inaquery?
A、PROMOBEGINDATE-SYSDATEwiIIreturnanumber
B、T0DATE(PR0M0BEGINDATE*5)wiIIreturnadate
C、TONUMBER(PROMOBEGINDATE.-5wiIIreturnanumber
D、PROMOBEGINDATE-SYSDATEwiIIreturnanerror
E、PROMOBEGINDATE-5wiIIreturnadate
答案:AE
12.WhichthreestatementsaretrueaboutGLOBALTEMPORARYTABLES?
A、AGLOBALTEMPORARYTABLEcanhaveonIyoneindex
B、AtriggercanbecreatedonaGLOBALTEMPORRYTABLE
C、DataManipuIationLanguage(DML)onGLOBALTEMPORARYTABLESgeneratesnoRED
0
D、AGLOBALTEMPORARYTABLEcannothaveaPUBLICSYNONYM
ExAGLOBALTEMPORARYTABLEcanbereferencedinthedefiningqueryofaview.
F、AGLOBALTEMPORARYTABLEcanhavemu11ipIeindexes.
答案:BEF
13.YoumustcreateatabIespaceofnon-standardbIocksizeinanewfiIesystemand
pIantousethismand
CREATETABLESPACEns_tb3
DATAFILE'/u02/oraclc/data/n3tbs_f01.dbf*
SIZE100G
BLOCKSIZE32K;
ThestandardbIocksizeis8kbutothernon-standardbIocksizeswiIIaIsobeusedW
hichtwoarerequirementsforthismandtosucceed?
AxDB32KCACHESIZEmustbesettoavaIuethatcanbeacmodatedintheSGA
B、DB32KCACHESIZEshouIdbesettoavaIuegreaterthanDBCACHESIZE
C、DB32KCACHESIZEmustbeIessthanDBCACHESIZE
D、Theoperatingsystemmustusea32kbIocksize
ExDBCACHESIZEmustbesettoasizethatissmaIIerthanDB32KCACHESIZE
F、The/uo2fiIesystemmusthaveatIeastlOOgspaceforthedatafiIe
答案:AF
14.WhichtwoarebenefitsofexternaItabIes?
AxTheysupportUPDATESwhichtransparentIyupdatesrecordsinthefiIesystema
siftheyweretable
B、TheycanbequeriedwhiIethedatabaseisintheMOUNTstateIikedynamicperfor
manceviews
C、TheysupportDELETEswhichtransparentIydeIetesrecordsinthefiIesystema
siftheyweretabIerows
D、TheresuItsofapIexjoinoraggregatingfunctionorbothcanbeunIoadedtoafi
Iefortransportationtoanotherdatabase
E、Theycanbequeried,transformed,andjoinedwithothertabIeswithouthaving
toIoadthedatafirst
答案:DE
15.WhichtwostatementsaretrueconcerninglogicalandphysicaIdatabasestruc
tures?
A、Asegment'sbIockscanbeofdifferentsizes.
B、AsegmentmighthaveonIyoneextent
CxAlItablespacesmayhaveoneormoredatafiles
D、Segmentscanspanmu11ipIetabIespaces
E、AsegmentcanspanmuItipledatafilesinsometabIespaces
答案:BE
16.WhichthreestatementsaretrueregardingsingIerowsubqueries?
A、TheymustbepIacedontheIeftsideoftheparisonoperatororcondition
B、TheymustreturnarowtopreventerrorsintheSQLstatement
C、TheycanbeusedintheHAVINGclause.
D、ASQLstatementmayhavemuItiplesinglerowsubquerybIocks
E、TheycanbeusedintheWHEREcIause
F、TheymustbepIacedontherightsideoftheparisonoperatororcondition
答案:CDE
17.YoucurrentIyhaveanactivetransactioninyoursessionandhavebeengranted
seIectaccesstoVSTRANSACTION
InwhichthreesituationswiIIre-executingthisquerystiIIreturnarowbutwith
adifferentXIDindicatinganewtransactionhasstarted?
Executing:
SELECTxid,statusFROMv$transaction;
inyoursessionreturns:
XIDSTATUS
0A0007000A07000DACTIVE
A、aftersuccessfuIIyexecutingaTRUNCATEstatementfoIIowedbyaDMLstatemen
t
B、aftersuccessfuIIyexecutingaCREATETABLEASSeIectstatementfoIIowedbya
SELECTFORUPDATEstatement
C、aftersuccessfulIyexecutingaCREATETABLEstatementfoIIowedbyaCREATEIN
DEXstatement
DxaftersuccessfuIIyexecutingamitorROLLBACKfoIIowedbyaDMLstatement
E、aftersuccessfuIIyexecutingaDMLstatementfoIlowingafaiIedDMLstatemen
t
F、aftersuccessfuIIyexecutingamitorROLLBACKfoIIowedbyaSeIectstatement
答案:ABD
18.orcI.dmpcontainsafuIIexportoftheORCIdatabase
(oraclefthostOl*]impdpsystem/oracle\
>SCHEMAS=sh,o«\
>REMAP_SCHEMA«Bh:hx\
>DUMPrTLE-orcl.dmp\
>EXCLUDE>index\
>TABLE_EXISTS_ACTIONax*pl*C«\
>LOGFILETmpdp.log
ThismandIsexecutedtoIoaddatafromorcI.dmpintotheRESRDBdatabase
Whichtwostatementsaretrue?
A、ItskipsonIytabIesthatexistInbothORCL:SHandTESTDB:HR
B、Itdropsandre-createstabIesthatexistinbothORCL:SHandTESTDB:HR.
C、ItskipsalIindexesofORCL:SHandORCI:OE
D、Itdropsandre-createsindexesthatexistInbothORCI:SHandTESTDB:HR
E、ItskipsonIyindexesthatexistinbothORCL:SHandTESTDB:HR
答案:BC
19.ExaminetheseSOLstatementswhichexecutesuccessfuIIy
CREATETABLEQmp
(ompnoNUMBER(2>CONSTRAINTPRIMARYKEY.
on^imoVARCHAR2(15>r
salaryNVMBER(8,2),
ALTERTABLEcmpADDCOHSTRADn1enip_niar_fk
FOREIGNKEYjno)
REFERENCESemp(cxp-no)
ONDELETESETML:
ALTERTABLEQ»p
DISABLECOKSTBAIJrrep_emp_no_pk
CASCADE;
ALTERTABLEgp
EKABLEC0:JS7RA:NTfcxp_Gxp__no__Fk;
Whichtwostatementsaretrueafterexecution?
AvTheprimarykeyconstraintwiIIbeenabIedandIMMEDIATE
BvTheforeignkeyconstraintwiIIbeenabledandDEFERRED
C、TheforeignkeyconstraintwiIIbedisabIed
D\TheforeignkeyconstraintwiIIbeenabIedandIMMEDIATE
ExTheprimarykeyconstraintwiIIbeenabledandDEFERRED
答案:AC
20.WhichthreestatementsaretrueaboutDeferredSegmentCreationinOracIedat
abases?
A、11isthedefauItbehaviorfortabIesandindexes.
B、Itissupportedforsys-ownedtabIescontainedinIocaIIymanagedtabIespace
s
C、SessionsmaydynamicaIIyswitchbackandforthfromDEFERREDtoIMMEDIATEseg
mentcreation.
D、IndexesinherittheDEFERREDorIMMEDIATEsegmentcreationattributefromth
eirparenttable
Ex11issupportedforIndexOrganizedTabIes(lOTs)containedinIocaIIymanage
dtabIespaces.
答案:ACD
21.Whichtwostatementsaretrueaboutviews?
AxAviewmustonIyrefertotablesinitsdefiningquery.
B、TheWITHCHECKcIausepreventseertainrowsfrombeingdispIayedwhenqueryin
gtheview
C、Viewscanbeupdatedwithouttheneedtore-grantpriviIegesontheview
D、TheWITHCHECKcIausepreventseertainrowsfrombeingupdatedorinsertedint
heunderlying
TabIethroughtheview.
ExViewscanbeindexed
答案:CD
22.WhichthreeactivitiesarerecordedinthedatabaseaIertIog?
A、bIockcorruptionerrors
B、DataDefinitionLanguage(DDL)statements
C、Non-defauItdatabaseparameters
D、deadIockerrors
E、sessionIoginsandIogouts
答案:ACD
23.WhichtwoaretrueaboutaSQLstatementusingSEToperatorssuchaslINION?
A、ThedatatypeofeachcoIumnreturnedbythesecondquerymustexactIymatchthe
datatypeofthecorrespondingcoIumnreturnedbythefirstquery
B、Thenumber,butnotnames,ofcoIumnsmustbeidenticaIforaIISELECTstatemen
tsinthequery
C、ThenamesandnumberofcoIumnsmustbeidenticaIforaIISELECTstatementsint
hequery
D、ThedatatypeofeachcoIumnreturnedbythesecondqueryisautomaticaIIyconv
ertedtothedatatypeofthecorrespondingcoIumnreturnedbythefirstquery
ExThedatatypegroupofeachcoIumnreturnedbythesecondquerymustmatchtheda
tatypegroupofthecorrespondingcoIumnreturnedbythefirstquery
答案:BE
24.WhichtwostatementsaretrueregardingaSAVEPOINT?(Choosetwo.
A、RollingbacktoaSAVEPOINTcanundoaCREATEINDEXstatement
B、RoIIingbacktoaSAVEPOINTcanundoaTRUNCATEstatement
CxOnIyoneSAVEPOINTmaybeissuedinatransaction
DxASAVEPOINTdoesnotissueaMIT
E、RoIIingbacktoaSAVEPOINTcanundoaDELETEstatement
答案:DE
25.hichthreefunctionsareperformedbydispatchersinasharedserverconfigur
ation?(Choosethree
A、writinginboundrequesttothemonrequestqueuefromaIIsharedserverconnec
tions
B、checkingforoutboundsharedserverresponsesonthemonoutboundresponsequ
eue
C、receivinginboundrequestsfromprocessesusingsharedserverconnections
D、sendingeachconnectioninputrequesttotheappropriatesharedserverinput
queue
ExbroadcastingsharedserversessionresponsesbacktorequestersonaIIconne
ctions
F、sendingsharedserversessionresponsesbacktorequestersontheappropriat
econnection
答案:ACF
26.ExaminethedescriptionoftheBOORSTRANSACTIONStabIe:
WhichtwoWHEREconditionsgivethesameresu11?
NameNull?Type
TRANSACTIOH-IDHOTNULLVARCHAR2(6)
TRANSACT工ON_TYPEVARCHAR2(3)
BORROWED-DATEDATE
BOOK_IDVARCHAR2⑹
MEMBERIDVARCHAR2(6)
ExaminethispartialSQLstatement:
SELECT•FROMbooks_tcansactions
A、WHEREborroweddate=SYSDATEAND(transaction_type='RM'AND(member_id'A1
01'ORmemberid=1A1021))
B、WHEREborroweddate=SYSDATEAND(transactiontype='RM'ORmemberidINCA10
IJA102D)
C、WHEREborroweddate=SYSDATEAND(transactiontype='RM'ANDmember_id'A101
'ORmemberid='A102')
D、WHEREborroweddate=SYSDATEANDtransactiontype='RM'ORmemberidINCA101
,,'A102f)
E、WHERE(borroweddate=SYSDATEANDtransactiontype='RM')ORmemberidINA101
,,'A1021)
答案:DE
27.WhichthreetasksareperformedbybackgroundprocessesinanOracIedatabase
instance?
AxregisteringserviceswithOracIeNetIisteners
B、writingdirtydatabasebIockimagesfromthebuffercache
CxwritingredotoIogfiIes
D、readingdatabasebIocksintothebuffercache
Excreatingdedicatedserverconnections
答案:ABC
28.Whichfourstatementsaretrueregardingprimaryandforeignkeyconstraints
andtheeffecttheycanhaveontabIedata?
Ax11ispossibIeforchiIdrowsthathaveaforeignkeytoremaininthechiIdtabIe
atthetimetheparentrowisdeIeted
B、PrimarykeyandforeignkeyconstraintscanbedefinedatboththecoIumnandta
bIeIeveI
C、AtabIecanhaveonIyoneprimarykeyandoneforeignkey.
D、AtabIecanhaveonIyoneprimarykeybutmuItipleforeignkeys
ExOnIytheprimarykeycanbedefinedatthecoIumnandtabIeIeveI
F、TheforeignkeycoIumnsandparenttabIeprimarykeycoIumnsmusthavethesame
names.
G、11ispossibIeforchiIdrowsthathaveaforeignkeytobedeIetedautomaticaII
yfromthechiIdtabIeatthetimetheparentrowisdeIeted
答案:ABDG
29.WhichtwostatementsaretrueabouttheOracIejoinandANSIjoinsyntax?
A、TheOracIejoinsyntaxperformsbetterthantheSQL:1999pIiantANSIjoinsynt
ax.
B、TheOra
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 门诊办投诉管理制度
- 门诊抽血室管理制度
- 非油品仓库管理制度
- 非现场监督管理制度
- 鞋材厂员工管理制度
- 餐厅设备间管理制度
- 饮水机清洁管理制度
- 湖南人文科技学院《煤岩动力灾害防治》2023-2024学年第二学期期末试卷
- 湖北中医药高等专科学校《物理因子治疗学》2023-2024学年第二学期期末试卷
- 天津医科大学临床医学院《财务决策支持系统》2023-2024学年第二学期期末试卷
- 物流仓储中心项目建设背景和必要性
- 安徽省涡阳县2023-2024学年七年级下学期期中考试语文试题
- 艺术设计专业面试问题
- 广东省深圳市龙华区2023-2024学年二年级下学期期中数学试题
- 小学科学湘科版六年级下册全册同步练习含答案
- (2024年)传染病培训课件
- 公车拍卖拍卖工作方案
- 幼儿园大班教案《娃哈哈》含反思
- C语言课程设计-家庭财务管理系统
- 二升三应用题100道
- 典当管理手册
评论
0/150
提交评论