单项选择题

YourdatabaseisrunninginARCHIVELOGmode.TheSCOTT.EMPtable……

YourdatabaseisrunninginARCHIVELOGmode.TheSCOTT.EMPtablebelongstotheDATA1tablespace.ThejuniorDBAerroneouslyrunsascriptthatexecutesthefollowingstatement：SQL>DROPTABLESCOTT.EMPPURGE；Afteronehour，youareperformingtheusermanagedincompleterecovery.Whichdatafileswillyourestorefromthelastfullbackup？（）
A.thedatafilesassociatedwiththeSYSTEMtablespace
B.thedatafilesassociatedtotheDATA1tablespace
C.thedatafilesassociatedtotheSYSTEMandDATA1tablespaces
D.allthedatafilesinthedatabase

A.TheSCOTT.EMPtablebelongstotheDATA1tablespace.ThejuniorDBAerroneouslyrunsascriptthatexecutesthefollowingstatement：SQL>DROPTABLESCOTT.EMPPURGE；Afteronehour，youareperformingtheusermanagedincompleterecovery.Whichdatafileswillyourestorefromthelastfullbackup？（）
A.thedatafilesassociatedwiththeSYSTEMtablespace
B.thedatafilesassociatedtotheDATA1tablespace
C.thedatafilesassociatedtotheSYSTEMandDATA1tablespaces
D.allthedatafilesinthedatabase

<上一题目录下一题>

热门试题

单项选择题YouareusingthebackupschedulerinEnterpriseManager（EM）toscheduleabackupofyourdatabase.Whichtypeofscriptdoesthebackupschedulergenerate？（）

A.SQLscript
B.PL/SQLscript
C.OperatingSystem（OS）script
D.EnterpriseManager（EM）script
E.RecoveryManager（RMAN）script

单项选择题classsuper（publicintI=0；publicsuper（stringtext）（I=1））publicclasssubextendssuper（publicsub（stringtext）（i=2）publicstaticvoidmain（straingargs）（subsub=newsub（Hello”）；system.out.PrintIn（sub.i）；））Whatistheresult？（）A.Compilationwillfail.B.Compilationwillsucceedandtheprogramwillprint“0”C.Compilationwillsucceedandtheprogramwillprint“1”D.Compilationwillsucceedandtheprogramwillprint“2”

A.out.PrintIn（sub.i）；））Whatistheresult？（）
A.Compilationwillfail.
B.Compilationwillsucceedandtheprogramwillprint“0”
C.Compilationwillsucceedandtheprogramwillprint“1”
D.Compilationwillsucceedandtheprogramwillprint“2”

单项选择题GiventheActionEvent，whichmethodallowsyoutoidentifytheaffectedcomponent？（）

A.GetClass.
B.GetTarget.
C.GetSource.
D.GetComponent.
E.GetTargetComponent.

单项选择题1.classExc0extendsException{}2.classExc1extendsExc0{}3.publicclassTest{4.publicstaticvoidmain（Stringargs[]）{5.try{6.thrownewExc1（）；7.}catch（Exc0e0）{8.System.out.println（Ex0caught”）；9.}catch（Exceptione）{10.System.out.println（exceptioncaught”）；11.}12.}13.}Whatistheresult？（）A.Ex0caughtB.exceptioncaughtC.Compilationfailsbecauseofanerroratline2.D.Compilationfailsbecauseofanerroratline6.

A.classExc0extendsException{}2.classExc1extendsExc0{}3.publicclassTest{4.publicstaticvoidmain（Stringargs[]）{5.try{6.thrownewExc1（）；7.}catch（Exc0e0）{8.System.out.println（Ex0caught”）；9.}catch（Exceptione）{10.System.out.println（exceptioncaught”）；11.}12.}13.}Whatistheresult？（）
A.Ex0caught
B.exceptioncaught
C.Compilationfailsbecauseofanerroratline2.
D.Compilationfailsbecauseofanerroratline6.

单项选择题AnapplicationconnectstoaSQLAzuredatabase.TheapplicationoccasionallylosestheconnectiontotheSQLAzuredatabase.Youneedtorecommendanapproachforreliablycompletingdataaccessoperations.Whatshouldyourecommend？（）A.UseMicrosoftADO.NETconnectionpooling.B.Passexceptionstotheuserinterfacelayer.C.Implementaretrypolicyinthedataaccesslayer.D.Beginatransactionbeforeeachdataaccessoperation.

A.TheapplicationoccasionallylosestheconnectiontotheSQLAzuredatabase.Youneedtorecommendanapproachforreliablycompletingdataaccessoperations.Whatshouldyourecommend？（）
A.UseMicrosoftADO.NETconnectionpooling.
B.Passexceptionstotheuserinterfacelayer.
C.Implementaretrypolicyinthedataaccesslayer.
D.Beginatransactionbeforeeachdataaccessoperation.

单项选择题YouaredesigningaWindowsAzuresolution.Thesolutionwillbeusedbymultiplecustomers.Eachcustomerhasdifferentbusinesslogicanduserinterfacerequirements.Notallcustomersusethesameversionofthe.NETruntime.Youneedtorecommendadeploymentstrategy.Whatshouldyourecommend？（）A.Deployinamultitenantconfiguration.B.Deployinasingle-tenantconfiguration.C.Deploywithmultiplewebroleinstances.D.Deploywith multipleworkerroleinstances.

A.Thesolutionwillbeusedbymultiplecustomers.Eachcustomerhasdifferentbusinesslogicanduserinterfacerequirements.Notallcustomersusethesameversionofthe.NETruntime.Youneedtorecommendadeploymentstrategy.Whatshouldyourecommend？（）
A.Deployinamultitenantconfiguration.
B.Deployinasingle-tenantconfiguration.
C.Deploywithmultiplewebroleinstances.
D.Deploywith

单项选择题YouareinstallinganapplicationonacomputerthatrunsWindowsServer2008R2.Duringinstallation，theapplicationwillneedtoaddnewattributesandclassestotheActiveDirectorydatabase.Youneedtoensurethatyoucaninstalltheapplication.Whatshouldyoudo（）A.ChangethefunctionalleveloftheforesttoWindowsServer2008R2.B.LogonbyusinganaccountthathasServerOperatorrights.C.LogonbyusinganaccountthathasSchemaAdministratorrightsandtheappropriaterightstoinstalltheapplicatioD.LogonbyusinganaccountthathastheEnterpriseAdministratorrightsandtheappropriaterightstoinstalltheapplicatio

A.Duringinstallation，theapplicationwillneedtoaddnewattributesandclassestotheActiveDirectorydatabase.Youneedtoensurethatyoucaninstalltheapplication.Whatshouldyoudo（）
A.ChangethefunctionalleveloftheforesttoWindowsServer2008R2.
B.LogonbyusinganaccountthathasServerOperatorrights.
C.LogonbyusinganaccountthathasSchemaAdministratorrightsandtheappropriaterightstoinstalltheapplicatio
D.LogonbyusinganaccountthathastheEnterpriseAdministratorrightsandtheappropriaterightstoinstalltheapplicatio

单项选择题Ifabackupisexpired，whichofthefollowingistrue？（）

A.Itcanneverbeusedforarestore/recoveroperation.
B.Oraclewillremovethebackupsetpiecesfromtheflashrecoveryarea.
C.Thebackuphasbeenusedatleastoncetorestoreandrecoverthedatabase.
D.Thebackupisnolongervalidbecauseofaresetlogsoperation.
E.Thephysicalbackupsetpiecesaremissingfromthemedia.

单项选择题Whichcommandwillresultinatracefilebeingcreatedwiththecreatecontrolfilecommandcontainedinit？（）

A.alterdatabasebackupcontrolfile
B.alterdatabasebackupcontrolfiletotrace
C.alterdatabasecontrolfilebackup
D.alterdatabasecontrolfilebackupto’/ora01/oracle/ctrl_backup.ctl’
E.alterdatabasebegincontrolfilebackup

单项选择题（）个变量的地址称为该变量的“指针”。

A.1
B.2
C.3
D.4

单项选择题Becauseofhardwarefailure，youdecidedtodroparedologmemberfromthedatabase.Whichconditionshouldbemettodroparedologfile？（）

A.Theredologfileshouldbelongtoanactivegroup.
B.Theredologfileshouldbelongtoaninactivegroup.
C.Theredologfileshouldbelongtothecurrentgroup.
D.Theredologfilecanbedroppedonlyifallthetransactionsarestopped.
E.Beforearedologfileisdropped，itshouldbedeletedfromtheoperatingsystem（OS）.

单项选择题WhatdoestheFastConnectionFailoverfeatureofActiveGridLinkforRACprovide?（）

A.instantnotificationofaRACnodefailuresoapplicationsneverhavetoretryatransactionthatwassenttoanodethatfailedduringthetransaction
B.near-instantnotificationofthefailureofaRACnodefailurethatminimizesthepossibilityconnectiontoafailednodebeingprovidedtoanapplication
C.applicationlevelnotificationofafailedRACnodesuchthatanapplicationcanretryatransactionifrequired
D.fasterfailoverforMultiDatasources
E.guaranteedtransactionhighavailabilitywheninteractingwithanOracleRACDatabase

单项选择题YouobservethatinyourPRODdatabase，customerinformationisbeingmodifiedbysomeunauthorizedusers.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL SQL.WhichtypeofPL SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）A.functionsB.packagesC.proceduresD.databasetriggersE.anonymousPL SQLblock

A.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL/SQL.WhichtypeofPL/SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）
A.functions
B.packages
C.procedures
D.databasetriggers
E.anonymousPL/SQLblock

单项选择题Evaluatethefollowingfunctioncode：CREATEFUNCTIONget_dept_avg（dept_idNUMBER）RETURNNUMBERRESULT_CACHERELIES_ON（EMPLOYEES）ISavgsalNUMBER（6）；BEGINSELECTAVG（SALARY）INTOavgsalFROMEMPLOYEESWHEREDEPARTMENT_ID=dept_id；RETURNavgsal；ENDget_dept_avg；Whichstatementistrueregardingtheabovefunction？（）A.ThecachedresultbecomesinvalidwhenanystructuralchangeisdonetotheEMPLOYEEStable.B.Ifthefunctionexecutionresultsinanunhandledexception，theexceptionresultisalsostoredinthecache.C.Eachtimethefunctionisinvokedinadifferentsession，thecurrentresultintheresultcachegetsoverwritten.D.Ifthefunctionisinvokedwithadifferentparametervalue，theexistingresultintheresultcache getsoverwrittenbythelatestvalue.

A.ThecachedresultbecomesinvalidwhenanystructuralchangeisdonetotheEMPLOYEEStable.
B.Ifthefunctionexecutionresultsinanunhandledexception，theexceptionresultisalsostoredinthecache.
C.Eachtimethefunctionisinvokedinadifferentsession，thecurrentresultintheresultcachegetsoverwritten.
D.Ifthefunctionisinvokedwithadifferentparametervalue，theexistingresultintheresultcache

单项选择题YouconfiguredthelargepoolforOraclebackupandrestoreoperations.Asaresult，whichcomponentwouldrequirelessmemory？（）

A.streamspool
B.sharedpool
C.logbuffer
D.keepbuffercache
E.recyclebuffercache