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

Inyourdatabase,youdiscoveredthatatempfileinalocallymanagedtemporarytablespacehasbeendeletedattheoperatingsystemlevel.Howwouldyourecoverthetablespace?()

A.flashbackthedatabase
B.performpoint-in-timerecovery
C.performafulldatabaserecovery
D.dropandre-createthetablespace
E.useRecoveryManager(RMAN)torecoverthedatabase
热门试题

单项选择题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.