Review the following program. What is the possible problem?()
A. #!/bin/ksh line is missing
B. Variable name VAR is not properly initialized
C. Loop variable is not incremented inside the loop
D. Loop variable is not decremented inside the loop
查看答案
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