A.FORMS_DDL
B.DO_SQL
C.FORM_SUCCESS
D.FORM_NOT_SUCCESS
E.DBMS.ERROR_CODE
第1题
A.0
B.1
C.2
D.3
E.4
第2题
A.Theremaybeabottleneckintheapplicationthatadditionalhardwarewouldnotsolve.
B.Addingmorehardwareiscostlyandtimeconsuming.
C.Addinghardwareattheapplicationlayermayplaceadditionalloadonanalreadyoverloadeddatabase,networkappliance,orstoragesystem.
D.Addingmorehardwaremayintroducenewconfigurationrequirementsthatneedtobetested.
第3题
uirements.1.Theobjectscreatedbytheusermustbestoredinatablespace,TBS1,iftheTABLESPACEoptionisnotdefinedduringtheobjectcreation.2.Theusershouldbeabletouse10MBofspaceinthetablespaceTBS1.3.Theusermustchangethepasswordimmediatelyafterlogginginforthefirsttime.WhichthreeoptionsoftheCREATEUSERcommandwouldyouusetoachievethisobjective?()
A.profile
B.accountlock
C.accountunlock
D.passwordexpire
E.quota10MBonTBS1
F.passwordneverexpire
G.defaulttablespaceTBS1
H.quotaunlimitedonTBS1
I.temporarytablespaceTEMP
J.temporarytablespaceSYSTEM
第4题
A.ReferencetheObjectIronpackagesinyourformmodule.
B.WriteanHTMLinterface,andinvokeitfromyourformmodule.
C.IncludetheWizardclassreusablecomponentinyourapplication.
D.Buildacustomizedwizardusingtabcanvasesandahorizontaltoolbarcanvas.
第5题
A. The root container can be flashed back without flashing back the pluggable databases (PDBs).
B. To enable flashback database, the CDB must be mounted.
C. Individual PDBs can be flashed back without flashing back the entire cdb.
D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
第6题
ps:CREATEDISKGROUPtdgroupANORMALREDUNDANCYFAILOVERGROUPcontrol01DISK’/devices/A1’,’/devices/A2’,’/devices/A3’FAILOVERGROUPcontrol02DISK’/devices/B1’,’/devices/B2’,’/devices/B3’mThedisk"/devices/A1"iscurrentlyamemberdiskofadiskgroupbythename"tdgroup1".Whichtaskwouldbeaccomplishedbythecommand?()
A.Thiscommandwouldresultinanerrorbecauseadiskgroupcanhaveonlyonefailovergroup.
B.Thiscommandwouldresultinanerrorbecausethe/devices/A1diskisamemberofanotherdiskgrouptdgroup1.
C.AnewdiskgroupcalledtdgroupAwillbeaddedwithtwofailovergroupsandthe/devices/A1diskwillgetreattachedtothenewdiskgroupwithoutbeingdetachedfromtheexistingone.
D.AnewdiskgroupcalledtdgroupAwillbeaddedwithtwofailovergroupsandthe/devices/A1diskwillbeignoredforthenewdiskgroupbecauseitisamemberofanexistingdiskgrouptdgroup1.
E.AnewdiskgroupcalledtdgroupAwillbeaddedwithtwofailovergroupsandthe/devices/A1diskgetsdetachedfromtheexistingdiskgrouptdgroup1andattachedtothenewdiskgrouptdgroupA
第7题
A.Thedatabasecanhavemorethanoneundotablespace.
B.TheUNDO_TABLESPACEparameterisvalidinbothautomaticandmanualundomanagement.
C.Undosegmentsautomaticallygrowandshrinkasneeded,actingascircularstoragebufferfortheirassignedtransactions.
D.AnundotablespaceisautomaticallycreatediftheUNDO_TABLESPACEparameterisnotsetandtheUNDO_MANAGEMENTparameterissettoAUTOduringthedatabaseinstancestartup.
第8题
A.Transactionmanagementisblock-orientedratherthanwindow-oriented.
B.Formsautomaticallynavigatestoanitemlocatedinanactivatedwindow.
C.Awindowmaycontainmultipleblocks,buteachblockcanonlyspanonewindow.
D.Awindowcancontainmultiplecanvases,andanitemcanbelocatedonmultiplecanvases.
第9题
nancialapplication.Whilecreatingthedatabase,youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective?()
A.UsetheCREATEDATABASE..commandtocreatethedatabasewithOracle-managedfiles.
B.UsetheDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithOracle-managedfiles.
C.UseEnterpriseManagertocreateanewdatabasewiththeOnlineTransactionProcessing(OLTP)option.
D.UseDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithTransactionProcessingtemplate.
E.UsetheCREATEDATABASE..commandtocreatethedatabasewithAutomaticStorageManagement(ASM)filesystem.
第10题
A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!