2009-07-22

面试小结

上个月因为非个人能力原因被无情的从上个项目提了出来,很是不爽,不过在这个项目待了也有两年多了,换个环境也是好的。回到公司,面试了几个项目
M公司的开发:
1)write 2 tables: Book and Author, then write a sql query that find all books written by you; (based on what tables you wrote)modify tables to support multi authors for one book
2)write code to display all fileNames in a directory include sub directory
3)write settings to a XML file, read setting back from XML file
4)read message from message queue
5)Do you have some experience on creating a winform setup file(MSI) and deploy it? Detail steps of creating a setup project
6)what is inner join and left join

Give a mark or your c# ablity (out of 10)
Give a mark or your SQLablity (out of 10)
what is Polymorphism
what is delegate
Database design experience, how many table, how many row in a table
left join, inner join, outer join
You may have a sql query that have a lot of join, cause query very slow, what you can do to let query quick?
Thread,lock,double checked lock
WPF experience
unit test
mock test, mock object

M公司测试:
堆和栈的区别
win32下的堆和.net下的堆的区别
GC 在什么情况下被调用
写一个广度优先遍历二叉树的程序
网络协议相关
全球化和本地化的区别
Globalization is the process of designing and developing applications that function for multiple cultures. Localization is the process of customizing your application for a given culture and locale.