深圳易高科技有限公司面试题目

RecruitmentQuiz

PaperA






PrepareBy

2GoTradeLtd.

Version:1.0

6Jan2006

Pleasecompletethefollowing8questionswithin2hours.

Question1

TheVBFunction,()function,GetCurrencyCodedemonstratesthetranslationbetweenthecurrencycodeandcurrencynumber.However,theperformanceofthisFunctionis()functionisnotgoodenough;thehigherorderofinputnumbertakesmuchmoretimestocalculate.Pleasesuggestawaytoimprovetheprogramperformance:

FunctionGetCurrencyCode()FunctionGetCurrencyCode(ByValinputAsString)AsString
Ifinput="01"Then
return="AFA"
ElseIfinput="02"Then
return="ALL"
ElseIfinput="03"Then
return="DZD"
ElseIfinput="04"Then
return="USD"
ElseIfinput="05"Then
return="HKD"
ElseIfinput="75"Then
return="EUR"
ElseIfinput="76"Then
return="XCD"
ElseIfinput="77"Then
return="AMD"
EndIf
EndFunction

Answer:
FunctionGetCurrencyCode()FunctionGetCurrencyCode(ByValinputAsString)AsStringSelectCaseinputCase"01":
return="AFA"Case"02":
return="ALL"Case"03":
return="DZD"Case"04":
return="USD"Case"05":
return="HKD"
Case"75":
return="EUR"
Case"76":
return="XCD"
Case"77":
return="AMD"
CaseElse:
return="unknown"EndSelectEndFunction


Question2

WriteaFunctionthat()functionthatreversestheorderofthewordsinastring.Forinstance,yourFunctionshould()functionshouldtransformthestring“Doordonot,thereisnotry.”To“try.Noistherenot,doorDo”.Assumethatallwordsarespacedelimitedandtreatpunctuationthesameasletters.

Useyourmosthands-onprogramminglanguage.

Answer:

JavaScriptVersion:
FunctionReversesOrder()functionReversesOrder()
{
varOldStr="Doordonot,thereisnotry."
varNewStr="";
varArrayStr=OldStr.split("");

for(vari=ArrayStr.length-1;i>=0;i--)
{
NewStr+=ArrayStr[i]+"";
}
returnNewStr;
}
Question3

StudythefollowingVBprogram:

ImportsSystem
ImportsSystem.IO
ModuleModule1ModuleModule1
PublicArtListAsArrayList
EndModule

PublicClassForm1ClassForm1
InheritsSystem.Windows.Forms.Form

WindowsFormDesignergeneratedcode#Region"WindowsFormDesignergeneratedcode"
…
#EndRegion

<[Serializable]()>PublicClassArtClassArt
PublicTitleAsString
PublicDesAsString
PublicValueAsInteger
PublicPriceAsDouble
PublicPictureAsString
EndClass

PrivateSubButton1_Click_1()SubButton1_Click_1(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesButton1.Click
DimmyArtAsNewObject
DimhashtableAsNewCollections.Hashtable
DimkeyAsString

Try
myArt=NewArt
WithmyArt
.Title="Title"
.Des="Desc"
.Value=123
.Price=321.05
EndWith
key=myArt.Title&myArt.Des&CStr(myArt.Value)&CStr(myArt.Price)
hashtable.Add(key,myArt)
ArtList.Add(myArt)

CatchexAsException'Thisistheline94’
MsgBox(ex.Message&vbCrLf&ex.StackTrace)
EndTry
EndSub
EndClass
Aformiscreatedonwhichabuttoncontrolisplaced.WhentheButton1_Clickisfired,amessageboxispopup:



Whatistheproblemandhowtofixit?

Answer:


Question4

InthefollowingVBprogram,pleasestatesanypotentialproblem(s)andhowtocorrect.

PrivateSubbtnCalc_Click()SubbtnCalc_Click()
DimresultAsInteger
Try
Me.Cursor=Windows.Forms.Cursors.WaitCursor
result=Convert.ToInt32(txtInput1.Text)/Convert.ToInt32(txtInput2.Text)
txtResult.Text=result
Me.Cursor=Windows.Forms.Cursors.Default
CatchexAsException
MsgBox(ex.StackTrace)
CatchexAsArgumentNullException
MsgBox("InputTestboxcannotbenull.")
CatchexAsOverflowException
MsgBox("InputTestbox2cannotbezero!")
CatchexAsFormatException
MsgBox("InputTestboxshouldbenumericformat!")
EndTry
EndSub

Answer:


Question5

GetRecordset()isaVBFunctionthat()functionthatreturnsaADODB.Recordsetobject:

Ref_IDQtyPrice
Row000123100060.50
Row100123200060.00
Row200123350059.50
Row300124300060.50
Row400125200059.50
Row500125100058.00

(ThisrecordsetissortedbyRef_ID)

Thefollowingprogram

DimrstasADODB.Recordset
Rst=GetRecordset
DoWhileNotrst.EOF
Console.writeline(rst.Fields("Ref_ID")&vbcrlf&rst.Fields("Qty")&vbcrlf&rst.Fields("Price"))
rst.MoveNext()
Loop

Cangeneratethefollowingoutput:

Output:

00123100060.50
00123200060.00
00123350059.50
00124300060.50
00125200059.50
00125100058.00

Pleasesuggesthowtomodifytheaboveprogramtogeneratethefollowingoutput:

Output:
00123
100060.50
200060.00
350059.50
---------
650060.00
00124
300060.50
---------
300060.50
00125
200059.50
100058.00
------