英文面试

第一个人：
VincenTHuanG 说:
hello
Veronka 说:
hi
Veronka 说:
this is Veronka from Salary.com
Veronka 说:

are you familiar with interview process?
VincenTHuanG 说:
Hi,My name is Vicent Huang
VincenTHuanG 说:
I am sorry,I know little about it
Veronka 说:
ok
Veronka 说:
There will be 5 people asking you questions in different area
VincenTHuanG 说:
ok,I see
Veronka 说:
on average each person should interview yiu for 30 - 40 min
Veronka 说:
ready?
VincenTHuanG 说:
ok
Veronka 说:
I will ask you questionjs for .NET C# and Javascript
VincenTHuanG 说:
OK
VincenTHuanG 说:
Should we start now?
Veronka 说:
1) Could you explain what Global.asax file is used for in a .NET application?>
VincenTHuanG 说:
Global.asax is a Configuration Fileswhich contain application_start,session_start function
Veronka 说:
ould you give me an example of how this file would be useful in an application?
VincenTHuanG 说: 
such an an couter,if we Visit the index.aspx an session_start function will be actived
Veronka 说:
ok
Veronka 说:
2) Explain the difference between Response.Redirect and Server.Tranfer
VincenTHuanG 说:
Response.Redirect will raise two exchage from the server and the client,butServer.Tranfer will be on the server 
VincenTHuanG 说:
one time 
VincenTHuanG 说:
the Server.Tranfer is more efficiency thanResponse.Redirect
VincenTHuanG 说:
and the url is change if we use Response.Redirect
Veronka 说:
ok
Veronka 说:
3) What is a directive? Examples
VincenTHuanG 说:
sorry I have no idea
Veronka 说:
<@ page
Veronka 说:
... for example
Veronka 说:
you set up attributes which will be evaluated at complilation time
Veronka 说:
<@ language
VincenTHuanG 说:
such as <@import> we can use this directive import the useful function and class 
Veronka 说:
is another example
Veronka 说:
yes
VincenTHuanG 说:
<@contrl
VincenTHuanG 说:
control
Veronka 说:
4) Exaplain what are the advantages/disatvantages of geting field values from a form as seen from bellow.

a) hidden fields
b) query string
c) cookies
d) view state
Veronka 说:
adv/dosadvantages of each method
Veronka 说:
you understand the question?
VincenTHuanG 说:
yes
Veronka 说:
ok
VincenTHuanG 说:
b) query string disadvantage: we will see the secret message advantage:Convenient c) cookies advantage:the message can be stored in the clientdisadvantage:is not very Security 
VincenTHuanG 说:
the other two I have no idea
Veronka 说:
ok
Veronka 说:
5) How can you raise Event in a .NET application?
VincenTHuanG 说: 
bind an event method
Veronka 说:
What are the steps to follow when you define, register, subscribe an event?
VincenTHuanG 说:
1 .create one delegate 2.bind the delegate with the method that we want to use 3 Callthe delegate
Veronka 说:
could you write a small example?
VincenTHuanG 说:
ok
VincenTHuanG 说:
public class MyDelegate 

{ 
public delegate void MyDelegate(string name); 

public static void MyDelegateFunc(string name) 

{ 
//code here
} 

public static void Main () 

{ 
MyDelegate md = new MyDelegate(MyDelegate.MyDelegateFunc); 
md("1111"); 
} 
}
Veronka 说:
ok
Veronka 说:
You have a form with an dropdown box on it. 
Write a piece of code in Javascript :

When a user selects an item from the dropdown list, the dropdown list disapears; The value selected appears in a textbox instead.
VincenTHuanG 说:


VincenTHuanG 说:
obj.style.visible
Veronka 说:
ok
Veronka 说:
I am done with my questions
VincenTHuanG 说:
thank u
Veronka 说:
do you have any questions for me?
VincenTHuanG 说:
how do you think the answer from me?
Veronka 说:
good
VincenTHuanG 说:
thank u Very Much
Veronka 说:
I will have the next person to contact you
VincenTHuanG 说:
ok
Veronka 说:

please stand by
Veronka 说:
thanks

第二个人：
VincenTHuanG 说:
hi,my name is vicent
Lan 说:
HI, This is Lan from Salary.com
VincenTHuanG 说:
nice to see you
Lan 说:
How are you
VincenTHuanG 说:
Fine,hoho
Lan 说:
Can I call you and talk for 5 minutes?
VincenTHuanG 说:
Ok
VincenTHuanG 说:
and how should we start?
Lan 说:
I will talk to you on the phone in English, then type some question in MSN. 
VincenTHuanG 说:
Ok
Lan 说:
calling u now
Lan 说:
Is this number right?
Lan 说:
13636347762
Lan 说:
it says Invalid number
VincenTHuanG 说:
13636347762
VincenTHuanG 说:
021 55271766 that's ok too
Lan 说:
so it's correct
Lan 说:
let me try you home number
VincenTHuanG 说: 
ok
…tel interview
Lan 说:
1. How to send cookie in ASP? How to get cookie?
VincenTHuanG 说:
request.cookie method
Lan 说:
this is get?
VincenTHuanG 说:
write 
VincenTHuanG 说:
response.cookie()
Lan 说:
2. You want to update data to database, 
Lan 说:
A. you don’t want any data returned from DB, which ADODB object you can use? 
Lan 说:
B. you want some data returned from DB, which ADODB object you can use?
VincenTHuanG 说:
conn.execute(sql),that is right?
Lan 说:
this could be the answer for A
Lan 说:
if you want to get data from database as a dataset
VincenTHuanG 说:
set r = rs.open sql,conn,1,1?
Lan 说:
what is r?
VincenTHuanG 说:
adodb.recordset
Lan 说:
tell me the full name of this object
Lan 说:
here you go 
Lan 说:
3. What do ByVal and ByRef mean in VB
Lan 说:
function GetMarketValue (byval strTemp, byRef strResult)
VincenTHuanG 说:
ByRef means there is just one copy of the strResult ,if we change the content of it ,it will change
Lan 说:
if you call this function, and pass in two variables, what's the difference between these two?
VincenTHuanG 说:
and byval mean if when we use the vairable it will create one copy
Lan 说:
ok
Lan 说:
Thanks, Eric
Lan 说:
It's nice to talk to you
VincenTHuanG 说:
Thank U 
Lan 说:
Do you have any question for me?
VincenTHuanG 说:
Thanks for your Praisei will try my best!
Lan 说:

Lan 说:
see ya

VincenTHuanG 说:
88
Lan 说:
wait online for the next one, please
VincenTHuanG 说:
ok
这个小姐当时电话面试夸我英文是她面试过所有人中最好的一个，心里真是美滋滋的，信心增强了不少 


第三个面试官：
VincenTHuanG 说:
hi,I am Eric 
asvitacp@hotmail.com  说:
Hi Eric
asvitacp@hotmail.com  说:
I'm Asvita from Salary.com
VincenTHuanG 说:
nice to meet you~
Asvita (Salary.com) 说:
How are you today!
VincenTHuanG 说:
fine,I have graduate from school tody,
VincenTHuanG 说:
today
VincenTHuanG 说:
so happy
Asvita (Salary.com) 说:
Congratulations!!
VincenTHuanG 说:
thanks~
Asvita (Salary.com) 说:
yes...thats great
VincenTHuanG 说:
I will try my best to gain my dream from now on
Asvita (Salary.com) 说:
So could you tell me about your experience with the sql server 
Asvita (Salary.com) 说:
sure....I wish you good luck...you seem very excited 
VincenTHuanG 说:
I have use the sql server 1 more year,I can write sql stored and trigger 
Asvita (Salary.com) 说:
ok...I'm a DBA here...so I would be asking only about sql...simple stuff
Asvita (Salary.com) 说:

VincenTHuanG 说:
OK 
Asvita (Salary.com) 说:
So did you work on sql server 2005?
VincenTHuanG 说:
I only use sql server 2000,never use the 2005
Asvita (Salary.com) 说:
ok..
Asvita (Salary.com) 说:
could you tell me what recordset would be the result for a query "select * from A full outer join B on A.id = B.id"
Asvita (Salary.com) 说:
just tell me if it would be all the records or only reords that match..
VincenTHuanG 说:
only reords that match..
Asvita (Salary.com) 说:
what about select * from A inner join B on A.id = B.id
VincenTHuanG 说: 
I have no idea
Asvita (Salary.com) 说:
ok....an inner join would return records that have matching ids in both the tables
Asvita (Salary.com) 说:
and an outer join would return all the records in the both the tables
VincenTHuanG 说:
I do not know the diffrent between the two,hehe
Asvita (Salary.com) 说:
well...now you know 
VincenTHuanG 说:
now i Know
VincenTHuanG 说:
thanks
VincenTHuanG 说:
go on ?
Asvita (Salary.com) 说:
two tables
Asvita (Salary.com) 说:
Create table StoreInfo(
StoreName Varchar(100 NULL),
Sales Decimal(18,5) NULL,
Date Datetime NULL)

StoreName Sales Date
Boston 1500 2006-07-01 00:00:00.000
Maine 700 2006-07-01 00:00:00.000
New York 3000 2006-11-01 00:00:00.000 
LA 2700 2007-04-15 00:00:00.000

Asvita (Salary.com) 说:
Create table IntSales(
Date Datetime NULL,
Sales Decimal(18,5) NULL)

Date Sales
2006-07-05 00:00:00.000 1500 
2006-07-08 00:00:00.000 700 
2006-11-01 00:00:00.000 3000 
2007-05-15 00:00:00.000 2700 

Asvita (Salary.com) 说:
what would the following query return?
Asvita (Salary.com) 说:
Select Date from StoreInfo
INTERSECT
Select Date from IntSales


VincenTHuanG 说:
sorry I have not see INTERSECT too 
Asvita (Salary.com) 说: 
In storeinfo, Maine has 700 for sales and 2006-07-01 00:00:00.00 for date...it has shifted one tab there
Asvita (Salary.com) 说:
2006-11-01 00:00:00.000 that would be the answer
VincenTHuanG 说:
and what does INTERSECT mean?
Asvita (Salary.com) 说:
intersect gives the common record in botht he tables
VincenTHuanG 说:
oh,I see...
Asvita (Salary.com) 说:
have you worked on indexes?
VincenTHuanG 说:
yes
Asvita (Salary.com) 说:
so how many clustered indexes can a table have?
VincenTHuanG 说:
one
Asvita (Salary.com) 说:
yes..
Asvita (Salary.com) 说:
have you worked on temporary tables?
VincenTHuanG 说:
no,only know little
Asvita (Salary.com) 说:
ok...do uou know the difference between a global temporary table and a local temporary table?
VincenTHuanG 说:
I don't know
Asvita (Salary.com) 说:
A local temporary table exists only for the duration of a connection.. 
VincenTHuanG 说:
oh...
Asvita (Salary.com) 说:
A global temporary table remains in the database permanently, but the rows exist only within a given connection..
Asvita (Salary.com) 说:
you have used triggers right..
VincenTHuanG 说:
yes
Asvita (Salary.com) 说:
so do you know about inserted and deleted tables?
VincenTHuanG 说:
yes
Asvita (Salary.com) 说:
so when you update data in a table that has an AFTER UPDATE Trigger, could you tell me what the inserted and deleted would tables contain?
VincenTHuanG 说:
this will contain the two step,first it will insert the new data into the table,and the delete the old one
Asvita (Salary.com) 说:
so what records would the "inserted" table contain?
VincenTHuanG 说:
the new data
Asvita (Salary.com) 说:
ok...
Asvita (Salary.com) 说:
could you tell me what is the difference betweenquerying a UDF and a built in function?

VincenTHuanG 说:
I do not know too,55
Asvita (Salary.com) 说:
when you use a user defined function in a query you have to use the schema name in front eg. select dbo.test()
Asvita (Salary.com) 说:
for a built in function you dont need the schema name
Asvita (Salary.com) 说:
eg : select getdate()
VincenTHuanG 说:
ok,thanks i See now 
VincenTHuanG 说:
My DB Knowledge is so poor...
Asvita (Salary.com) 说:
Thats ok...I see that you have more experience in development 
Asvita (Salary.com) 说:
do you have any questions for me?
VincenTHuanG 说:
thanks you let me know my DB Knowledge,I I think I have to study more DB Knowledge ,hehe
VincenTHuanG 说:
I have no more question 
Asvita (Salary.com) 说:
ok...
Asvita (Salary.com) 说:
well...thats all from me
Asvita (Salary.com) 说:
Michael or Katie would be here next
Asvita (Salary.com) 说: 
one of them should be here in a few minutes..
VincenTHuanG 说:
OK,I Know...
Asvita (Salary.com) 说:
it was nice talking to you! Good luck to you for all you future dreams 
VincenTHuanG 说:
I will ...
Asvita (Salary.com) 说:
Thank you!
VincenTHuanG 说:
Thank you too~~