ADBAhasbeenaskedtocreateatablewhichwillcontainasubstantialamountofdetailedsalesinformationforeachcalendarmonthandmaintainittocontainonlythelast12months.Whichofthefollowingmethodswillfacilitatetheonlineremovaloftheoldestmonth’sdata?()
A. CreateanMQTthatselectstheoldestmonthofdatawiththeREFRESHIMMEDIATEoption.
B. Create12separatetables,createaviewbasedonall12,dropthetablewiththeoldestmonth'sdatathendropandre-createtheview.
Createarangepartitionedtable,partitionedbymonth,andusetheALTERTABLEstatementtodetachtheoldestmonthandattachstoragefornewdata.
D. Createasingletable,extractthedatatoberetainedusingUNLOADwithaSELECTstatement,dropandre-createthetablethenloadonlythedatatoberetained.