16,555
社区成员
发帖
与我相关
我的任务
分享明天面试笔试考题，请高手做答！(.net/sql)高分重谢！
1. compare the performance of the following two statements and explain .
statement1:SELECT * From Table1 WHERE field1= CONVERT ( DATETIME,’01/01/2003’)
statement2:SELECT * From Table1 WHERE CONVERT(VARCHAR(10),field1,103)=’01/01/2003’
2. Enhance the following statement to support the insertion of Unicode data.
INSERT INTO Table1 VALUES(‘data’)
3. what is UDF stand far? Name two limitations on using UDF?
4. which one of the followings has a better performance and why?
5. write a SQL statement in joining Table A and Table B to product the result set as listed.
Table A
Code Area
1 A1
2 A2
3 A3
5 A5
7
Table B
Code Region
1 R1
3 R3
6 R6
8
Result Set
Code Area Code Region
1 A1 1 B1
3 A3 3 B3
NULL NULL 6 B6
NULL NULL 8 NULL
6. write a statement using Table A and Table B in question 5 to product the following result set.
Code Area
1 A1
1 B1
2 A2
3 A3
3 B3
5 A5
6 B6
7 NULL
8 NULL
7. write a statement using Table A and Table B in question 5 to product the following result set.
Code Area
2 A2
5 A5
7 NULL
8. what is IDENTITY Column? How to enable the insertion of value to the Coumn?
9. what is Cluster index?
10. The following result Set is listed on executing the statement.
SELECT * From temp_cost
Staff_no Pay_code Total-allowance
1001 P1 70
1002 P2 60
1001 P1 100
1002 P1 80
1002 P2 90
What is the result in executing the statement .
SELECT staff_no,Pay_code,MAX(total_allowance) FROM temp_cost
1. How to display Chinese in the field for crystal Report and what are the constaint(s)?
2. How do you change all existing report to connect to the database if the database has been moved to a new location or if the database has been renamed?
3. How do you update your report to reflect the changes in your database?
4. Can the section Format event handler change the outcome of a formatted report section at runtime?
If Yes, what are the constrains ? if No,how are can handle the change of format relating to the runtime data?
5. what if a Sub-report?
1. Describe the approach in enabling a component with long name reference to be share by different applications.
2. what is the validation class ? what is the usage ?
3. Compare the Performance of the following two sets of codes and explain
Coding Set 1
Dim s as string
For I = 1 to 5000
S=s + “some text”
Next
Coding Set 2
Dim sb as New StringBuider
For I = 1 to 5000
s.Append(“some text”)
Next
4. what is cache dependeney ? List types of Cache dependentay
5. what are serviced components ? what are the disadvantages?
6. Briefly describe how to re-activate the environment if you find the ASPX.
Deelopment environment is hanged up (something related to the IIS service)
7. Describe 2 ways to deal. With an Unexpencted or unhandled exceptions that is not captured by a try/catch/Finall
Block.
8. Briefly describe what are ideatity ,Roles, Principal in managed security context.
9. what is SmartNavigation?
What are the main advantages of using SmartNavigation?
10. what is code-Behind?
Please describe the benefit of having this feature in the .NET enviroument.
statement1:SELECT * From Table1 WHERE field1= CONVERT ( DATETIME,’01/01/2003’)
statement2:SELECT * From Table1 WHERE CONVERT(VARCHAR(10),field1,103)=’01/01/2003’
2. Enhance the following statement to support the insertion of Unicode data.
INSERT INTO Table1 VALUES(‘data’)
3. what is UDF stand far? Name two limitations on using UDF?
4. which one of the followings has a better performance and why?
5. write a SQL statement in joining Table A and Table B to product the result set as listed.
Table A
Code Area
1 A1
2 A2
3 A3
5 A5
7
Table B
Code Region
1 R1
3 R3
6 R6
8
Result Set
Code Area Code Region
1 A1 1 B1
3 A3 3 B3
NULL NULL 6 B6
NULL NULL 8 NULL
6. write a statement using Table A and Table B in question 5 to product the following result set.
Code Area
1 A1
1 B1
2 A2
3 A3
3 B3
5 A5
6 B6
7 NULL
8 NULL
7. write a statement using Table A and Table B in question 5 to product the following result set.
Code Area
2 A2
5 A5
7 NULL
8. what is IDENTITY Column? How to enable the insertion of value to the Coumn?
9. what is Cluster index?
10. The following result Set is listed on executing the statement.
SELECT * From temp_cost
Staff_no Pay_code Total-allowance
1001 P1 70
1002 P2 60
1001 P1 100
1002 P1 80
1002 P2 90
What is the result in executing the statement .
SELECT staff_no,Pay_code,MAX(total_allowance) FROM temp_cost
1. How to display Chinese in the field for crystal Report and what are the constaint(s)?
2. How do you change all existing report to connect to the database if the database has been moved to a new location or if the database has been renamed?
3. How do you update your report to reflect the changes in your database?
4. Can the section Format event handler change the outcome of a formatted report section at runtime?
If Yes, what are the constrains ? if No,how are can handle the change of format relating to the runtime data?
5. what if a Sub-report?
1. Describe the approach in enabling a component with long name reference to be share by different applications.
2. what is the validation class ? what is the usage ?
3. Compare the Performance of the following two sets of codes and explain
Coding Set 1
Dim s as string
For I = 1 to 5000
S=s + “some text”
Next
Coding Set 2
Dim sb as New StringBuider
For I = 1 to 5000
s.Append(“some text”)
Next
4. what is cache dependeney ? List types of Cache dependentay
5. what are serviced components ? what are the disadvantages?
6. Briefly describe how to re-activate the environment if you find the ASPX.
Deelopment environment is hanged up (something related to the IIS service)
7. Describe 2 ways to deal. With an Unexpencted or unhandled exceptions that is not captured by a try/catch/Finall
Block.
8. Briefly describe what are ideatity ,Roles, Principal in managed security context.
9. what is SmartNavigation?
What are the main advantages of using SmartNavigation?
10. what is code-Behind?
Please describe the benefit of having this feature in the .NET enviroument.
...全文
请发表友善的回复…
发表回复
wpr_tzp 2003-11-21
- 打赏
- 举报
10是得不到结果的，会报错
除了写语句好多还不懂，关注……
除了写语句好多还不懂，关注……
hscc2008 2003-11-21
- 打赏
- 举报
看你会不会是我的同事，呵呵~
chengxing 2003-11-11
- 打赏
- 举报
up
树莓派 2003-11-11
- 打赏
- 举报
╮╮
\█/ ~~倒！ 这个东西很有趣~
●
\█/ ~~倒！ 这个东西很有趣~
●
Linvic 2003-11-11
- 打赏
- 举报
╮╮
\█/ ~~倒！
●
\█/ ~~倒！
●
canyqf 2003-11-10
- 打赏
- 举报
2. INSERT INTO Table1 VALUES(N'data') 不是 U
sindyzhou 2003-11-10
- 打赏
- 举报
9. what is Cluster index?
聚簇索引，索引顺序跟数据在介质上存储的物理顺序相同
dxlth 2003-11-10
- 打赏
- 举报
老兄，你是考什么啊？
晕倒
晕倒
jjstar 2003-11-10
- 打赏
- 举报
1. Describe the approach in enabling a component with long name reference to be share by different applications.
创建密钥对，
为程序集指定签名，
添加到GAC
2. what is the validation class ? what is the usage ?
3. Compare the Performance of the following two sets of codes and explain
Coding Set 1
Dim s as string
For I = 1 to 5000
S=s + “some text”
Next
Coding Set 2
Dim sb as New StringBuider
For I = 1 to 5000
s.Append(“some text”)
Next
set1中每次s=s+"some text"都创建了一个新的字符串，内存开销大，速度慢
4. what is cache dependeney ? List types of Cache dependentay
文件（数组）依赖，键（数组）依赖
5. what are serviced components ? what are the disadvantages?
使用 COM+ 服务的类。
使用serviceComponent实现事务的性能要次于ADO.NET或者DB的事务。
6. Briefly describe how to re-activate the environment if you find the ASPX.
Deelopment environment is hanged up (something related to the IIS service)
maybe you should re-start the IIS service
7. Describe 2 ways to deal. With an Unexpencted or unhandled exceptions that is not captured by a try/catch/Finall
Block.
写一个HTTPMODULE，捕获error事件
利用web.config中的customErrors
8. Briefly describe what are ideatity ,Roles, Principal in managed security context.
9. what is SmartNavigation?
What are the main advantages of using SmartNavigation?
在大多数情况下不要在代码中设置该属性。在 .aspx 文件的 @ Page 指令中将 SmartNavigation 属性设置为 true。请求该页时，动态生成的类将设置该属性。
Internet Explorer 5 或更高版本浏览器请求页时（或稍后），智能导航将通过执行下列功能提高用户对该页的操作能力：
消除导航导致的闪烁。
从一页移动到另一页时保持滚动位置。
保持导航之间的元素焦点。
在浏览器的历史记录中只保留最后一页的状态。
智能导航最适用于需要频繁回发但是其可是内容在返回时不会发生显著更改的 ASP.NET 页。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
顺便问一句，这是要什么水平的人的笔试
创建密钥对，
为程序集指定签名，
添加到GAC
2. what is the validation class ? what is the usage ?
3. Compare the Performance of the following two sets of codes and explain
Coding Set 1
Dim s as string
For I = 1 to 5000
S=s + “some text”
Next
Coding Set 2
Dim sb as New StringBuider
For I = 1 to 5000
s.Append(“some text”)
Next
set1中每次s=s+"some text"都创建了一个新的字符串，内存开销大，速度慢
4. what is cache dependeney ? List types of Cache dependentay
文件（数组）依赖，键（数组）依赖
5. what are serviced components ? what are the disadvantages?
使用 COM+ 服务的类。
使用serviceComponent实现事务的性能要次于ADO.NET或者DB的事务。
6. Briefly describe how to re-activate the environment if you find the ASPX.
Deelopment environment is hanged up (something related to the IIS service)
maybe you should re-start the IIS service
7. Describe 2 ways to deal. With an Unexpencted or unhandled exceptions that is not captured by a try/catch/Finall
Block.
写一个HTTPMODULE，捕获error事件
利用web.config中的customErrors
8. Briefly describe what are ideatity ,Roles, Principal in managed security context.
9. what is SmartNavigation?
What are the main advantages of using SmartNavigation?
在大多数情况下不要在代码中设置该属性。在 .aspx 文件的 @ Page 指令中将 SmartNavigation 属性设置为 true。请求该页时，动态生成的类将设置该属性。
Internet Explorer 5 或更高版本浏览器请求页时（或稍后），智能导航将通过执行下列功能提高用户对该页的操作能力：
消除导航导致的闪烁。
从一页移动到另一页时保持滚动位置。
保持导航之间的元素焦点。
在浏览器的历史记录中只保留最后一页的状态。
智能导航最适用于需要频繁回发但是其可是内容在返回时不会发生显著更改的 ASP.NET 页。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
顺便问一句，这是要什么水平的人的笔试
tanjinfeng 2003-11-09
- 打赏
- 举报
买本SQL的书看看得了
citylamp 2003-11-09
- 打赏
- 举报
3. Compare the Performance of the following two sets of codes and explain
Coding Set 1
Dim s as string
For I = 1 to 5000
S=s + “some text”
Next
Coding Set 2
Dim sb as New StringBuider
For I = 1 to 5000
s.Append(“some text”)
Next
A:第一种比较慢，因为每次要先生成一个中间变量内存单元用于拷贝新字串，再传给s
10. what is code-Behind?
Please describe the benefit of having this feature in the .NET enviroument.
A:代码与页面分离的好处是可以“分而治之”，UI人员去设计页面，编程人员用心去搞编程，可以“并行”。
Coding Set 1
Dim s as string
For I = 1 to 5000
S=s + “some text”
Next
Coding Set 2
Dim sb as New StringBuider
For I = 1 to 5000
s.Append(“some text”)
Next
A:第一种比较慢，因为每次要先生成一个中间变量内存单元用于拷贝新字串，再传给s
10. what is code-Behind?
Please describe the benefit of having this feature in the .NET enviroument.
A:代码与页面分离的好处是可以“分而治之”，UI人员去设计页面，编程人员用心去搞编程，可以“并行”。
jjstar 2003-11-09
- 打赏
- 举报
mark
Angelnet 2003-11-09
- 打赏
- 举报
这些问题到数据库专区去，哪里高手很多，每次我问的问题都圆满解决。
chengxing 2003-11-08
- 打赏
- 举报
up
江山一片红8888 2003-11-08
- 打赏
- 举报
我頂住！！
lwplwp123 2003-11-07
- 打赏
- 举报
Mark & Learn
Hard!!!
Hard!!!
树莓派 2003-11-07
- 打赏
- 举报
10 CodeHide is what used in Asp.Net with VB.net,it allow you write asp like write windows form.
6HZ 2003-11-07
- 打赏
- 举报
1.statement1 is much efficient.
The statement2 will perform the function of CONVERT for each record, the statement1 only once.
2.INSERT INTO Table1 VALUES(QUOTENAME(‘data’))
6.SELECT * FROM A UNION ALL SELECT * FROM B
The statement2 will perform the function of CONVERT for each record, the statement1 only once.
2.INSERT INTO Table1 VALUES(QUOTENAME(‘data’))
6.SELECT * FROM A UNION ALL SELECT * FROM B
hscc2008 2003-11-06
- 打赏
- 举报
up
dimtxw 2003-11-06
- 打赏
- 举报
1. The first will perform the function of CONVERT for each record, the second only once.
2. INSERT INTO Table1 VALUES(U'data')
3. I don't know
4. I can't see the followings
5. SELECT * FROM A RIGHT JOIN B ON B.code=A.code
6. SELECT * FROM A UNION ALL SELECT * FROM B
7. SELECT * FROM A WHERE code NOT IN (SELECT code FROM B)
8. It will add the step value automatically base the basic value when inserted a record
you can set identity_... table on. I have forgot the text of ...
9. I can't answer this.
10. I think is
1001 P1 100
1002 P2 100
1001 P1 100
1002 P1 100
1002 P2 100
or you will get a error for 'need for group statement'
2. INSERT INTO Table1 VALUES(U'data')
3. I don't know
4. I can't see the followings
5. SELECT * FROM A RIGHT JOIN B ON B.code=A.code
6. SELECT * FROM A UNION ALL SELECT * FROM B
7. SELECT * FROM A WHERE code NOT IN (SELECT code FROM B)
8. It will add the step value automatically base the basic value when inserted a record
you can set identity_... table on. I have forgot the text of ...
9. I can't answer this.
10. I think is
1001 P1 100
1002 P2 100
1001 P1 100
1002 P1 100
1002 P2 100
or you will get a error for 'need for group statement'
加载更多回复（1）
