YouarecreatingtheDEPT_SALdatablockfromthePAYHISTform.UsersshouldbeabletoenteravaliddepartmentIDnumber,whichwillthendisplaytheemployeesalaryinformationforthatdepartment.Thisdatablockcouldpotentiallyretrievealargenumberofrecords.Sinceuserswillprobablyonlyviewasmallnumberoftheserecords,only10recordsshouldbefetchedatonetime.Howwouldyoucreatethedatablock?()A.SelectTheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,entertheprocedurenameintheQueryDataSourceColumnsproperty,andtheprocedurecodeintheQueryDataSourceArgumentsproperty.B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.C.ChooseTools->DataBlockWizard,select,Viewasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘FROMclausequery‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.E.SelecttheDataBlocknodeintheObjectNavigatorandclicktheCreatebutton.AltertheQueryDataSourceType,QueryDataSourceName,QueryDataSourcesColumns,andQueryDataSourceArgumentspropertiestocreateastoredprocedurethatusesaredcursor.
A.UsersshouldbeabletoenteravaliddepartmentIDnumber,whichwillthendisplaytheemployeesalaryinformationforthatdepartment.Thisdatablockcouldpotentiallyretrievealargenumberofrecords.Sinceuserswillprobablyonlyviewasmallnumberoftheserecords,only10recordsshouldbefetchedatonetime.Howwouldyoucreatethedatablock?()
A.SelectTheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,entertheprocedurenameintheQueryDataSourceColumnsproperty,andtheprocedurecodeintheQueryDataSourceArgumentsproperty.
B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.
C.ChooseTools->DataBlockWizard,select,Viewasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.
D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘FROMclausequery‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.
E.SelecttheDataBlocknodeintheObjectNavigatorandclicktheCreatebutton.AltertheQueryDataSourceType,QueryDataSourceName,QueryDataSourcesColumns,andQueryDataSourceArgumentspropertiestocreateastoredprocedurethatusesaredcursor.