面试小结

上个月因为非个人能力原因被无情的从上个项目提了出来，很是不爽，不过在这个项目待了也有两年多了，换个环境也是好的。回到公司，面试了几个项目

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.