ADBAhasbeenaskedtocreateatablewhichwillcontainasubstantialamountofdetailedsalesinformationforeachcalendarmonthandmaintainittocontainonlythelast12months.Whichofthefollowingmethodswillfacilitatetheonlineremovaloftheoldestmonth’sdata?()
A. CreateanMQTthatselectstheoldestmonthofdatawiththeREFRESHIMMEDIATEoption.
B. Create12separatetables,createaviewbasedonall12,dropthetablewiththeoldestmonth'sdatathendropandre-createtheview.
Createarangepartitionedtable,partitionedbymonth,andusetheALTERTABLEstatementtodetachtheoldestmonthandattachstoragefornewdata.
D. Createasingletable,extractthedatatoberetainedusingUNLOADwithaSELECTstatement,dropandre-createthetablethenloadonlythedatatoberetained.
查看答案
During the initial cluster design,a disk heartbeat,Point-to-Point non-IP network is being planned as part of a three-node cluster implementation. The disk environment will use LVM mirroring for disk redundancy. The volume groups will be created as Enhanced Concurrent Capable. To facilitate disk heartbeating,how many disks per node and how many networks will be required?()
A. One disk per node,one network
B. Two disks per node,one network
C. Two disks per node,six networks
D. Two disks per node,three networks
Given the following scripts, both found in /usr/local/bin, what would the output be when executing /usr/local/bin/script1?()
A. dog cat
B. dog fish
C. mouse cat
D. mouse fish
WhichofthefollowingstringscanbeinsertedintoanXMLcolumnusingXMLPARSE?()
A. ""
B. ""
C. "hello_world.dtd'>"
D. ""
Given the following scripts, what output would be generated?()
A. The sky is red.
B. The sky is blue.
C. The sky is green.
D. The sky is yellow.