单项选择题

A.Thevalueneededtogeneratethissummarydataarestoredinmul……

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.