WhichofthefollowingareallvalidDB2datatypes?()
A. LONGVARCHAR,SMALLINT,NUMBER,BLOB
B. DECIMAL,DATE,DBCLOB,INTERVAL
C. NUMERIC,TIMESTAMP,BYTE,FLOAT
D. NUM,TIME,XML,DOUBLE
查看答案
Given the following script, why does the output come out as an empty line instead of "dog"?()
A. The $VAR variable was not exported
B. The $VAR should have been set as VAR
C. dog needs double quotes around it when setting $VAR
D. The { } should not be around VAR in the echo command
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