YouneedtoperformanonlinetableredefinitionofanexistingSALEStabletopartitionitintotwotablespacesTBS1andTBS2.TheSALEStablehasamaterializedview，materializedlog，indexes，referentialintegrityconstraint，andtriggerswiththePRECEDESclauseexistingonit.Whatactionisrequiredfordependentobjectswhenyouperformonlinetableredefinition？（）
A.Thedependentmaterializedviewshouldhaveacompleterefreshperformedaftertheonlinetableredefinitionprocess.
B.TriggerswiththePRECEDESclauseshouldbedisabledbeforetheonlinetableredefinitionprocess.
C.Referentialintegrityconstraintsmustbemanuallyenabledaftertheonlinetableredefinitionprocess.
D.Thematerializedlogshouldbedroppedbeforetheonlinetableredefinitionprocess.

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.