share some insane interview questions - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Actuary - 精算

share some insane interview questions

share some insane interview questions# Actuary - 精算

e*n2010-06-11 07:06

1 楼

所有干的事情都可以分成两类，科学和艺术。科学就是一般说的科学。艺术就是除了科
学以外的其他一切事情。
科学慢慢积累，比较严谨，对后世或者现世有指导作用，帮助人们了解无穷的universe。
其他都是艺术。
最主要的区别是科学没有独特性，你没干其他人也会干，相同的结果，历史的洪流。艺
术则是独特的，个人的独有，你没有干这件事，别人是不会干出任何相似的事情的。
按我理解艺术没有准确的定义。吃个饭也能吃出艺术来。

c*r2010-06-11 07:06

2 楼

col1, col2两个column存放人名id, 要求给出任意一个人的id,找出所有和这个人有联
系的人，以及所有其他有联系的人。例如
col1 col2
---- ----
A B
A C
B J
M B
X J
C K
Q A
输入的人名是A, 需要返回
1. COL2 WHERE COL1 = A，输出B和C；
2. COL1 WHERE COL2 = A, 结果加入Q;
3. COL2 WHERE COL1 IN (B,C,Q), 加入结果;
4. COL1 WHERE COL2 IN (B,C,Q)，加入结果；
...
如此类推直至找不到新的ID
这似乎是个递归问题，能写个store procedure吗

y*62010-06-11 07:06

3 楼

1. What is the least thing you like about your current job. (That's a trap!!)
2. What is the most thing you like about your current job.
3. What/where do you see yourself in 3-5 years.
4. Why do you want to work as an actuary.
5. Write a paragraph to describe the trend of the data. And also list any
unusual data you saw. Is that reasonable to group home values>=200,000 together, give your explanation. (5mins typing)
(I made up those data, but the type are the same)
Home values Time Pol

w*w2010-06-11 07:06

4 楼

Something like:
with friend_cte as (
select col1 as col from friend where col2='a'
union
select col2 as col from friend where col1='a'
union
select col1 as col from friend join friend_cte
on friend.col2=friend_cte.col
union
select col2 as col from friend join friend_cte
on friend.col1=friend_cte.col
);
select col from friend_cte;

s*02010-06-11 07:06

5 楼

thanks a lot !

a*y2010-06-11 07:06

6 楼

This only works with MS SQL Server, also there is a limitation for number of
recursion for CTE though.
Better to use procedure with while loop.

g*r2010-06-11 07:06

7 楼

thank you very much for sharing

d*u2010-06-11 07:06

8 楼

The first four questions are typical interview questions.
The reason why you didn't get the job is not necessarily you didn't answer
the last question well. It might because they have many strong candidates.
If you need a visa and are not the strongest one, you might not be able to
get the offer. Even if you are the strongest one, if other candidates are good enought, you might not get an offer either.
Don't be upset and move on. Good Luck!

!!)
together, give your explanation. (5mins typing)
Po

【在 y******6 的大作中提到】

: 1. What is the least thing you like about your current job. (That's a trap!!)
: 2. What is the most thing you like about your current job.
: 3. What/where do you see yourself in 3-5 years.
: 4. Why do you want to work as an actuary.
: 5. Write a paragraph to describe the trend of the data. And also list any
: unusual data you saw. Is that reasonable to group home values>=200,000 together, give your explanation. (5mins typing)
: (I made up those data, but the type are the same)
: Home values Time Pol

y*62010-06-11 07:06

9 楼

Well, I have green card. I forgot one thing, 'why do we have to hire you'.
So far two local p-c insurance companies asked about this question. I always
said I have four exams so I have the strong ability to pass exams in the
future, and also I have the ability to do the job since I'm a statistician for my current job. But seems that's not what they want. Anyway, move
on la.
Feel like if the company's size is medium or(red neck) and don't sponsor visa they really care about whether you can fit in

C*32010-06-11 07:06

10 楼

that's not how you should answer this question. Now days, all the candidate
they interview are fast at passing exams and have solid quantitative
background. You should say something like: I'll stay away from the
analytical side since I am confident that I can prove that to you once I
start, but what really distingishes me from others are .... (talk about
something unique about you - ie. background, etc)
good luck

always
for my current job. But seems that's not what they want. Anyway, move
visa

【在 y******6 的大作中提到】

: Well, I have green card. I forgot one thing, 'why do we have to hire you'.
: So far two local p-c insurance companies asked about this question. I always
: said I have four exams so I have the strong ability to pass exams in the
: future, and also I have the ability to do the job since I'm a statistician for my current job. But seems that's not what they want. Anyway, move
: on la.
: Feel like if the company's size is medium or(red neck) and don't sponsor visa they really care about whether you can fit in

C*32010-06-11 07:06

11 楼

其实这最后一个问题是一个自由发挥介绍一下resume上没发表示的东西好机会啊，不
要说什么techinical的东西，那些大家都会，不能impress到面试官

candidate
their

【在 C*****3 的大作中提到】

: that's not how you should answer this question. Now days, all the candidate
: they interview are fast at passing exams and have solid quantitative
: background. You should say something like: I'll stay away from the
: analytical side since I am confident that I can prove that to you once I
: start, but what really distingishes me from others are .... (talk about
: something unique about you - ie. background, etc)
: good luck
:
: always
: for my current job. But seems that's not what they want. Anyway, move

p*b2010-06-11 07:06

12 楼

谁给解释一下最后一道题目呢？
谢谢

!!)
together, give your explanation. (5mins typing)
Policy

【在 y******6 的大作中提到】

Y*H2010-06-11 07:06

13 楼

You need to find our what exactly they want first, then try to fit your
qualifications to that window.

always
for my current job. But seems that's not what they want. Anyway, move
visa they really care about whether you can fit into the group because their
group might not have any non-americans. If the company is really big and
sponsor visa then they want intership as well as first-time pass the exam. (
big monster one so far two/three asked whether I pass them the first-time or
not) Swiss-Re i

【在 y******6 的大作中提到】

j*a2010-06-11 07:06

14 楼

thank you

!!)
together, give your explanation. (5mins typing)
Policy

【在 y******6 的大作中提到】

d*u2010-06-11 07:06

15 楼

Since you are a career changer, you need to convince them why you want to be
an actuary rather than a statistician.
You'd better to get some insight information about the field where a company
is doing its buesiness. For example, if the company is in health, you'd
better relate your interest with health insurance.
Hope it helps and good luck!

always
for my current job. But seems that's not what they want. Anyway, move
visa they really care about whether you can fit into the group because their

【在 y******6 的大作中提到】

y*62010-06-11 07:06

16 楼

Thanks, everyone. Admittedly, I didn't prepare well for those behavior
questions. One more thing I want to add to is that the SAS certification may
not be helpful for those jobs. From my experience, except a small health
insurance really like my experience of using SAS (unfortunately I didn't
want to move to that location, so I didn't go to the on-site), the others
seems don't care SAS programming skills at all. And one p-c company said
they using EXCEL all the time.(I was freaking out after hea