找考题网-背景图
单项选择题

A.flashbackthedatabaseB.performpoint-in-timerecoveryC.p……

Inyourdatabase，youdiscoveredthatatempfileinalocallymanagedtemporarytablespacehasbeendeletedattheoperatingsystemlevel.Howwouldyourecoverthetablespace？（）

A.flashbackthedatabase
B.performpoint-in-timerecovery
C.performafulldatabaserecovery
D.dropandre-createthetablespace
E.useRecoveryManager（RMAN）torecoverthedatabase
<上一题 目录 下一题>
热门试题

单项选择题本地电子商务指的是().

A.在全世界范围内进行的电子交易活动,交易各方通过网络做生意
B.指利用本地区或者本城市的信息网络实现的电子商务活动
C.就是利用EDI网络进行电子交易
D.利用Internet网络进行电子交易

单项选择题Theaccountingmanagerwantsyoutocreateaformthatwhenqueriedwilldisplayacalculatedtotalofyear-to-dateactualexpendituresforthefundcodeentered.Thevalueneededtogeneratethissummarydataarestoredinmultipletables.HowwouldyoudefinethedatasourceforthisdatablockwithouthavingtheDBAcreateadatabaseobject?（）A.ChooseTools->DataBlockWizard,selectViewasthedatasourcetype,andbasetheblockonthecolumnsfromthebales.B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.C.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.ChoosetobuildthedatablockmanuallyandaltertheQueryDataSourceColumnsandQueryDataSourceArgumentspropertiestoentertheSELECTstatement.D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘Table‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.E.ChooseTools->DataBlockWizard,selectStoredProcedureasthedatasourcetype,andbasetheblockonthecolumnsthetables.F.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually.AltertheQueryDataSourceTypeto‘FROM‘clausequery‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.

A.Thevalueneededtogeneratethissummarydataarestoredinmultipletables.HowwouldyoudefinethedatasourceforthisdatablockwithouthavingtheDBAcreateadatabaseobject?（）
A.ChooseTools->DataBlockWizard,selectViewasthedatasourcetype,andbasetheblockonthecolumnsfromthebales.
B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.
C.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.ChoosetobuildthedatablockmanuallyandaltertheQueryDataSourceColumnsandQueryDataSourceArgumentspropertiestoentertheSELECTstatement.
D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘Table‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.
E.ChooseTools->DataBlockWizard,selectStoredProcedureasthedatasourcetype,andbasetheblockonthecolumnsthetables.
F.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually.AltertheQueryDataSourceTypeto‘FROM‘clausequery‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.

单项选择题WhichcomponentoftheSGAstoresparsedSQLstatementsisusedforprocesssharing?（）

A.Buffercache
B.Redologbuffer
C.PrivateSQLarea
D.Librarycache
E.Rowcache

单项选择题Managementhasdecidedthatthedatabasemustbeavailable24hoursaday，7daysaweek.Giventhisrequirement，whichtypeofbackupisrequired？（）

A.user-managedbackups.
B.partialdatabasebackups.
C.consistentdatabasebackups.
D.inconsistentdatabasebackups.

单项选择题OnswitchR1youissuethe udldenable globalcommand.Whatdoesthiscommandaccomplish？（）

A.Enablesallfiber-opticLANportsforUnidirectionalLINKDetection（UDLD）
B.EnablesallcoppermediaLANportsUnidirectionalLinkDetection（UDLD）
C.OverridesthedefaultUDLSsettingforallports
D.GloballyenablesallportsonthedeviceforUnidirectionalLinkDetection（UDLS）
E.Noneoftheotheralternativesapply

单项选择题Whiledesigningyourdatabase，youhavecreatedtheEMPLOYEEStableasanindex-organizedtable（IOT）.YouwanttocreateabitmapindexontheJOB_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）A.Aprimarykeymusthavebeencreated.B.Amappingtablemusthavebeencreated.C.Anoverflowtablespacemusthavebeenspecified.D.ThePCTTHRESHOLDoptionmusthavebeenspecified.

A.YouwanttocreateabitmapindexontheJOB_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）
A.Aprimarykeymusthavebeencreated.
B.Amappingtablemusthavebeencreated.
C.Anoverflowtablespacemusthavebeenspecified.
D.ThePCTTHRESHOLDoptionmusthavebeenspecified.

单项选择题Whatistheimpactoftheresultsoftheoutputofthefollowingcommand？（）RMAN>reportunrecoverabledatabase；ReportoffilesthatneedbackupduetounrecoverableoperationsFileTypeofBackupRequiredName4fullorincrementalC： ORACLE ORADATA ORCL USERS01.DBFA.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.C.Theusers01.dbfdatafileiscorrupted.D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.

A.DBF
A.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.
B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.
C.Theusers01.dbfdatafileiscorrupted.
D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.
E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.

单项选择题WhichofthefollowingisaprerequisiteforrunningDBMS_TDB.CHECK_DBtoasuccessfulcompletion？（）

A.Thedatabasemustbeinread-writemode.
B.Thedatabasemusthavenoexternalfiles.
C.Thedatabasemustopeninread-onlymode.
D.Thedatabasemustbemountedbutnotopened.