你真的有多好？ [英] Just how good are you really?
问题描述
亲爱的开发者，
首先，我不确定这篇文章应该去哪里，所以如果这个
在错误的群组中，我道歉区域。我正在面试一个vb.net
开发人员，他不介意使用
MS Access对客户需求进行原型设计。我们没有太多运气找到很多合适的人通过代理商和我接受采访的人没有得分
我的小测试非常高这是原因对于我的帖子。
请一定要给我发一封电子邮件，里面有你的答案，我很高兴
给他们留下标记并将结果返回给你！ < tpodonnell at plls.co.uk>
干杯，
Tim
p.s.任何有兴趣从ms访问移动到.net的开发者然后
如果你在布里斯托尔的位置上有兴趣的话，请给我留言......好工资
和良好的安全性。
--------------------------------------- ------------------------------------
**接下来的两个问题假设你可以看到一个数据库图
和问题二已被省略，因为它引用了这个
图**
问题1
图1.1的上图说明了
组织数据库系统的图表，术语ERD的含义是什么。在
插图描述中？
问题3.
假设在SQL Server中查看此图表
企业管理器，表格旁边的*符号表示什么
图表上的
名称。
问题4.
以下详细说明的SQL语句在上述系统中使用，可以说明你认为开发人员想要实现的目标。
CREATE PROCEDURE [DBO]。[SP_CURRENTUSER_DATA]
@USER_NAME CHAR（30）OUT，
AS
SET @USER_NAME = TRIM（@USER_NAME）
SELECT TBL_PERSONNEL.PK_PERSONNEL_ID，
TBL_PERSONNEL.FK_ORGANISATION_REF，
TBL_PERSONNEL.FK_MANAGER_REF，
TBL_PERSONNEL.FK_SECRETARY_REF，
TBL_PERSONNEL.FK_TITLE_REF，
TBL_PERSONNEL.FORE_NAME，
TBL_PERSONNEL.SURNAME，
TBL_PERSONNEL.DIRECT_PHONE，
TBL_PERSONNEL.MOBILE ，
TBL_PERSONNEL.DIRECT_FAX，
TBL_PERSONNEL.EMAIL，
TBL_STAFF_INFO.PK_STAFF_ID，
TBL_STAFF_INFO.PASSWORD，
TBL_STAFF_INFO.PASSWORD_DATE，
TBL_STAFF_INFO.USER_NAME，
TBL_STAFF_INFO.ORGAN_ADMIN
来自TBL_PERSONNEL，
TBL_STAFF_INFO
WHERE TBL_PERSONNEL.PK_PERSONNEL_ID =
TBL_STAFF_INFO.FK_PERSONNEL_REF
AND TBL_STAFF_INFO。[USER_NAME] = @USER_NAME
GO
问题5.
上述SQL语句中是否存在任何错误？
问题6.
假设任何错误都已修复，如果您在MS查询分析器中运行上述内容，您希望发生什么？
问题7.
你会在这个存储过程中添加什么来帮助开发团队环境？
a团队环境？ />
问题8.
申报时会使用哪些关键字？在确定
后，你能够捕获任何由课程触发的事件
它已经被实例化了吗？
问题9.
面向对象编程的两个主要优点是什么？
标准程序语言？
问题10.
下面是我们的一个VB.NET
系统的一小段代码。假设所有外部变量和类都已经正确实例化了，你认为这个
代码的主要功能是什么？注意：opcAdditionalProducers是一个专门为生产者信息的交互而写的
的类。
GetAdditionalProducerInfoStatus返回一个特定的
行的DataRowState。这个类中的本地数据表。
Private Sub PopulateProducerListview（）
尝试
Dim ProducerLimit As Integer =
CType（opcAdditionalProducers.CountAdditionalProduc ers，Integer）
Dim ProducerCount As Integer
Dim intIndex As Integer = 0
lstvwAdditionalProducers.Items.Clear（）
直到ProducerCount = ProducerLimit
如果opcAdditionalProducers.GetAdditionalProducerInfoSt atus（intIndex）
<> DataRowState.Deleted然后
lstvwAdditionalProducers.Items.Add（opcAdditionalPr oducers.GetAdditionalProducerAsListViewItem（intInd ex））
ProducerCount + = 1
结束如果
intIndex + = 1
循环
如果lstvwAdditionalProducers.Items.Count> 0然后
lstvwAdditionalProducers.Items（0）.Selected = True
结束如果
Catch excep As System.Exception
''捕获所有错误
MessageBox.Show（" Message："& excep.Message）
结束尝试< br $>
End Sub
问题11.
假设函数CountAdditionalProducers返回没有DataRowState为已删除的行的总数
来自
本地数据表保存在opcAdditionalProducers类中。
如果此函数返回值15并且
中有10行
DataRowState为已删除的数据表
的2行DataRowState为已修改，您期望
do循环多少次？循环？
问题12
下面详细说明的代码取自标准MS Access
数据库应用。不幸的是，代码无法正确编译
，您能否突出显示您认为错误为
的任何区域。假设cnnLocal是本地数据库的全局连接。
Private Sub UpdateBordereau（）
Dim rst as new ADODB.command
如果cnnLocal.State = adStateClosed然后调用OpenConnection
rst.Open" SELECT *" &安培; _
" FROM TBL_BORDEREAUS" &安培; _
" WHERE PK_BORDEREAU_ID =" &安培; intBordereauID，cnnLocal，
adOpenKeyset，adLockOptimistic
rst
.Fields（" MONTH"）= cmbMonths.ItemData（ cmbMonths.ListIndex）
.Fields（" SUPPLIED_DATE"）= CDate（txtSuppliedDate）
.Fields（" EXCEL_DATA_LOCATION"）= txtExcelFileLocation
.Fields（" EXCEL_ORIGINAL_LOCATION"）=
txtOriginalFileLocation
.Fields（" TOT_NEW_CONTRACTS"）= CInt（Nz（txtNewContracts，
） 0））
.Fields（" TOT_CANCELLATIONS"）= CInt（Nz（txtCancellations，
0））
.Fields（"） TOT_EXCEPTIONS"）= CInt（Nz（txtExceptions，0））
.Fields（" TOT_FROM_PREVIOUS_MONTH"）=
CInt（Nz（txtPreviousMonth，0））
.Fields（" TOT_ENROLLED"）= CInt（Nz（txtEnrolled，0））
.Fields（" TOT_RV"）= CCur（Nz（txtTotalRV，0））
.Fields（" TOT_GROSS_PREMIUM"）= CCur（Nz（txtGrossPremium，
0） ））
.Fields（" TOT_BROKER_COMMISSION"）=
CCur（Nz（Me.txtGrossPremium * Nz（txtCommission，0），0））
.Fields（" TOT_NET_PREMIUM"）= CCur（Nz（txtNetPremium，0））
.UpdateTableRow
结束
rst = Nothing
cnnLocal.Close
End Sub
< blockquote> tp********@plls.co.uk （Tim）写道：
我正在面试一位vb.net开发人员，他不介意使用MS Access进行客户需求原型设计。
为什么继续使用VB.NET？为什么不在MS Access中构建系统？要快得多
因此便宜。
Tony
-
Tony Toews，微软访问MVP
请仅在新闻组中回复，以便其他人可以阅读整个邮件主题。
Microsoft Access Links，Hints，Tips &安培;会计系统
http://www.granite.ab.ca /accsmstr.htm
" Tim"写了
亲爱的开发者，
首先，我不确定这篇文章应该去哪里，所以如果这个
出错，我道歉团体或地区。我正在面试一个vb.net
开发人员，他不介意使用MS Access对客户需求进行原型设计。 。 。 。
p.s.任何有兴趣从ms访问移动到.net的开发人员如果你在布里斯托尔的位置上有兴趣，那么请给我一条线路......好工资和良好的安全性。
亲爱的Tim，
我肯定布里斯托尔很好，薪水很好，但你肯定知道
广告，包括招聘，即使伪装成b $ b测试，在USENET新闻组中是被禁止的，除非特许章程明确地允许它为b $ b。您可以在FAQ
网站上查看comp.databases.ms-access的章程， http://www.mvps.org/access/netiquette.htm ，以确认它不会特别允许广告支持
。
那个常见问题解答信息每天都会在这里发布，但是你可能会因为频率错误而错过了它吗？
谢谢供您考虑未来再次违反USENET规则和新闻组的
章程。
Larry Linson
comp.databases.ms-access的创始成员
Tim：
看起来像你韩元。我们欠你
Dear Developers,
Firstly, I''m not sure where this post should go so I apologise if this
is in the wrong group or area. I''m currently interviewing for a vb.net
developer who doesn''t mind prototyping the client requirements using
MS Access. We''ve not had much luck in finding many suitable people
through agencies and those that I have interviewed are not scoring
very high on my little test which is the reason for my post.
Please have a go and send me an email with your answers, I''ll happly
mark them and return the results to you! <tpodonnell at plls.co.uk>
Cheers,
Tim
p.s. Any developers interested in moving to .net from ms access then
drop me a line if your intersted in a position in Bristol ... good pay
and good security.
---------------------------------------------------------------------------
**These next two question assumes that you can see a database diagram
and question two has been omitted due to it''s reference to this
diagram**
Question 1
The above diagram of figure 1.1 illustrates a diagram of the
organisational database system, what is meant by the term "E.R.D." in
the illustration description?
Question 3.
Assuming that this diagram is being viewed within SQL Server
Enterprise Manager, what do the * symbols indicate next to the table
names on the diagram.
Question 4.
The SQL statement detailed below is used within the above system, can
you describe what you think the developer is trying to achieve.
CREATE PROCEDURE [DBO].[SP_CURRENTUSER_DATA]
@USER_NAME CHAR(30) OUT,
AS
SET @USER_NAME = TRIM(@USER_NAME)
SELECT TBL_PERSONNEL.PK_PERSONNEL_ID,
TBL_PERSONNEL.FK_ORGANISATION_REF,
TBL_PERSONNEL.FK_MANAGER_REF,
TBL_PERSONNEL.FK_SECRETARY_REF,
TBL_PERSONNEL.FK_TITLE_REF,
TBL_PERSONNEL.FORE_NAME,
TBL_PERSONNEL.SURNAME,
TBL_PERSONNEL.DIRECT_PHONE,
TBL_PERSONNEL.MOBILE,
TBL_PERSONNEL.DIRECT_FAX,
TBL_PERSONNEL.EMAIL,
TBL_STAFF_INFO.PK_STAFF_ID,
TBL_STAFF_INFO.PASSWORD,
TBL_STAFF_INFO.PASSWORD_DATE,
TBL_STAFF_INFO.USER_NAME,
TBL_STAFF_INFO.ORGAN_ADMIN
FROM TBL_PERSONNEL,
TBL_STAFF_INFO
WHERE TBL_PERSONNEL.PK_PERSONNEL_ID =
TBL_STAFF_INFO.FK_PERSONNEL_REF
AND TBL_STAFF_INFO.[USER_NAME] = @USER_NAME
GO
Question 5.
Do any errors exist within the above SQL statement?
Question 6.
Assuming that any errors are fixed what would you expect to happen if
you ran the above within MS Query Analyzer?
Question 7.
What would you add to this stored procedure to aid development within
a team environment?
Question 8.
What keyword(s) would you use when declaring a class to ensure that
you are able to catch any events that are triggered by the class after
it has been instantiated?
Question 9.
What are the two main advantages of Object Orientated Programming over
standard procedural languages?
Question 10.
Below there is a short snippet of code taken from one of our VB.NET
systems. Assuming that all external variables and classes have been
instantiated correctly, what do you think the main function of this
code is? Note: "opcAdditionalProducers" is a class that has been
written specifically for the interaction of producer information and
GetAdditionalProducerInfoStatus returns the DataRowState of a specific
row held within a local data-table within this class.
Private Sub PopulateProducerListview()
Try
Dim ProducerLimit As Integer =
CType(opcAdditionalProducers.CountAdditionalProduc ers, Integer)
Dim ProducerCount As Integer
Dim intIndex As Integer = 0
lstvwAdditionalProducers.Items.Clear()
Do Until ProducerCount = ProducerLimit
If opcAdditionalProducers.GetAdditionalProducerInfoSt atus(intIndex)
<> DataRowState.Deleted Then
lstvwAdditionalProducers.Items.Add(opcAdditionalPr oducers.GetAdditionalProducerAsListViewItem(intInd ex))
ProducerCount += 1
End If
intIndex += 1
Loop
If lstvwAdditionalProducers.Items.Count > 0 Then
lstvwAdditionalProducers.Items(0).Selected = True
End If
Catch excep As System.Exception
''CATCHES ALL ERRORS
MessageBox.Show("Message: " & excep.Message)
End Try
End Sub
Question 11.
Assume that the function "CountAdditionalProducers" returns the total
number of rows that do not have a DataRowState of "deleted" from the
local data-table held within the opcAdditionalProducers class.
If this function returns a value of 15 and there are 10 rows within
the data-table that are have a DataRowState of "deleted" and 2 rows at
have a DataRowState of "modified", how many times would you expect the
"do loop" to cycle?
Question 12
The code detailed below has been taken from a standard MS Access
database application. Unfortunately the code will not compile
correctly, can you highlight any area(s) where you think an error is
present. Assume cnnLocal is a global connection to the local database.
Private Sub UpdateBordereau()
Dim rst As New ADODB.command
If cnnLocal.State = adStateClosed Then Call OpenConnection
rst.Open "SELECT * " & _
"FROM TBL_BORDEREAUS " & _
"WHERE PK_BORDEREAU_ID = " & intBordereauID, cnnLocal,
adOpenKeyset, adLockOptimistic
With rst
.Fields("MONTH") = cmbMonths.ItemData(cmbMonths.ListIndex)
.Fields("SUPPLIED_DATE") = CDate(txtSuppliedDate)
.Fields("EXCEL_DATA_LOCATION") = txtExcelFileLocation
.Fields("EXCEL_ORIGINAL_LOCATION") =
txtOriginalFileLocation
.Fields("TOT_NEW_CONTRACTS") = CInt(Nz(txtNewContracts,
0))
.Fields("TOT_CANCELLATIONS") = CInt(Nz(txtCancellations,
0))
.Fields("TOT_EXCEPTIONS") = CInt(Nz(txtExceptions, 0))
.Fields("TOT_FROM_PREVIOUS_MONTH") =
CInt(Nz(txtPreviousMonth, 0))
.Fields("TOT_ENROLLED") = CInt(Nz(txtEnrolled, 0))
.Fields("TOT_RV") = CCur(Nz(txtTotalRV, 0))
.Fields("TOT_GROSS_PREMIUM") = CCur(Nz(txtGrossPremium,
0))
.Fields("TOT_BROKER_COMMISSION") =
CCur(Nz(Me.txtGrossPremium * Nz(txtCommission, 0), 0))
.Fields("TOT_NET_PREMIUM") = CCur(Nz(txtNetPremium, 0))
.UpdateTableRow
End With
rst = Nothing
cnnLocal.Close
End Sub
tp********@plls.co.uk (Tim) wrote:
I''m currently interviewing for a vb.net
developer who doesn''t mind prototyping the client requirements using
MS Access.
Why continue on to VB.NET? Why not build the system in MS Access? Be a lot faster
thus cheaper.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
"Tim" wrote
Dear Developers,
Firstly, I''m not sure where this post should go so I apologise if this
is in the wrong group or area. I''m currently interviewing for a vb.net
developer who doesn''t mind prototyping the client requirements using
MS Access. . . .
p.s. Any developers interested in moving to .net from ms access then
drop me a line if your intersted in a position in Bristol ... good pay
and good security.
Dear Tim,
I''m sure Bristol is nice, and the pay is good, but surely you are aware that
advertising, including employment solicitation, even if disguised as a
"test", is prohibited in USENET newsgroups unless the charter specifically
permits it. You can view the charter of comp.databases.ms-access at the FAQ
site, http://www.mvps.org/access/netiquette.htm to veryify that it does NOT
specifically permit ads.
That FAQ information is only posted here every single day, but perhaps you
missed it in spite of its frequency?
Thanks for your consideration in not violating the USENET rules and the
charter of the newsgroup again in the future.
Larry Linson
founding member of comp.databases.ms-access
Tim:
Looks like you won. We owe you
这篇关于你真的有多好？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
