RecruitmentQuiz
PaperA
PrepareBy
2GoTradeLtd.
Version:
1.0
6
Jan
2006
Pleasecompletethefollowing
8
questionswithin
2
hours.
Question
1
TheVB
function
,GetCurrencyCodedemonstratesthetranslationbetweenthecurrencycode
and
currencynumber.However,theperformanceofthis
function
is
not
goodenough;thehigherorderof
input
numbertakesmuchmoretimes
to
calculate.Pleasesuggestaway
to
improvetheprogramperformance:
TheVB
Function
GetCurrencyCode(
ByVal
input
As
String
)
As
String
If
input
=
"
01
"
Then
return
=
"
AFA
"
ElseIf
input
=
"
02
"
Then
return
=
"
ALL
"
ElseIf
input
=
"
03
"
Then
return
=
"
DZD
"
ElseIf
input
=
"
04
"
Then
return
=
"
USD
"
ElseIf
input
=
"
05
"
Then
return
=
"
HKD
"
ElseIf
input
=
"
75
"
Then
return
=
"
EUR
"
ElseIf
input
=
"
76
"
Then
return
=
"
XCD
"
ElseIf
input
=
"
77
"
Then
return
=
"
AMD
"
End
If
EndFunction
Answer:
Function
GetCurrencyCode(
ByVal
input
As
String
)
As
String
Select
Case
input
Case
"
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
"
Case
Else
:
return
=
"
unknown
"
End
Select
EndFunction
Question
2
Write
a
function
thatreversestheorderofthewords
in
a
string
.
For
instance,your
function
shouldtransformthe
string
“
Do
or
do
not
,there
is
no
try
.”
To
“
try
.No
is
there
not
,
do
or
Do
”.Assumethatallwordsare
space
delimited
and
treatpunctuationthesame
as
letters.
Useyourmosthands
-
on
programminglanguage.
Answer:
JavaScriptVersion:
function
ReversesOrder()
{
varOldStr
=
"
Doordonot,thereisnotry.
"
varNewStr
=
""
;
varArrayStr
=
OldStr.split(
"
"
);
for
(vari
=
ArrayStr.length
-
1
;i
>=
0
;i
--
)
{
NewStr
+=
ArrayStr[i]
+
"
"
;
}
return
NewStr;
}
Question
3
StudythefollowingVBprogram:
Imports
System
Imports
System.IO
Module
Module1
Public
ArtList
As
ArrayList
EndModule
Public
Class
Form1
Inherits
System.Windows.Forms.Form
WindowsFormDesignergeneratedcode
<
[Serializable]()
>
Public
Class
Art
Public
Title
As
String
Public
Des
As
String
Public
Value
As
Integer
Public
Price
As
Double
Public
Picture
As
String
EndClass
Private
Sub
Button1_Click_1(
ByVal
sender
As
System.Object,
ByVal
e
As
System.EventArgs)
Handles
Button1.Click
Dim
myArt
As
New
Object
Dim
hashtable
As
New
Collections.Hashtable
Dim
key
As
String
Try
myArt
=
New
Art
With
myArt
.Title
=
"
Title
"
.Des
=
"
Desc
"
.Value
=
123
.Price
=
321.05
End
With
key
=
myArt.Title
&
myArt.Des
&
CStr
(myArt.Value)
&
CStr
(myArt.Price)
hashtable.Add(key,myArt)
ArtList.Add(myArt)
Catch
ex
As
Exception
'
Thisistheline94’
MsgBox
(ex.Message
&
vbCrLf
&
ex.StackTrace)
End
Try
EndSub
EndClass
Aform
is
created
on
whichabuttoncontrol
is
placed.WhentheButton1_Click
is
fired,amessagebox
is
popup:
What
is
theproblem
and
how
to
fix
it?
Answer:
Question
4
In
thefollowingVBprogram,pleasestatesanypotentialproblem(s)
and
how
to
correct.
Private
Sub
btnCalc_Click()
Dim
result
As
Integer
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
Catch
ex
As
Exception
MsgBox
(ex.StackTrace)
Catch
ex
As
ArgumentNullException
MsgBox
(
"
InputTestboxcannotbenull.
"
)
Catch
ex
As
OverflowException
MsgBox
(
"
InputTestbox2cannotbezero!
"
)
Catch
ex
As
FormatException
MsgBox
(
"
InputTestboxshouldbenumericformat!
"
)
End
Try
EndSub
Answer:
Question
5
GetRecordset()
is
aVB
function
thatreturnsaADODB.Recordset
object
:
Ref_IDQtyPrice
Row
0
00123
1000
60.50
Row
1
00123
2000
60.00
Row
2
00123
3500
59.50
Row
3
00124
3000
60.50
Row
4
00125
2000
59.50
Row
5
00125
1000
58.00
(Thisrecordset
is
sortedbyRef_ID)
Thefollowingprogram
Dim
rst
as
ADODB.Recordset
Rst
=
GetRecordset
Do
While
Not
rst.EOF
Console.writeline(rst.Fields(
"
Ref_ID
"
)
&
vbcrlf
&
rst.Fields(
"
Qty
"
)
&
vbcrlf
&
rst.Fields(
"
Price
"
))
rst.MoveNext()
Loop
Cangeneratethefollowingoutput:
Output:
00123
1000
60.50
00123
2000
60.00
00123
3500
59.50
00124
3000
60.50
00125
2000
59.50
00125
1000
58.00
Pleasesuggesthow
to
modifytheaboveprogram
to
generatethefollowingoutput:
Output:
00123
1000
60.50
2000
60.00
3500
59.50
----
-----
6500
60.00
00124
3000
60.50
----
-----
3000
60.50
00125
2000
59.50
1000
58.00
----
--
分享到：
發表評論
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
評論