面试回来发考题1 - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

面试回来发考题1

面试回来发考题1# Database - 数据库

n*62008-12-02 08:12

1 楼

Position: Database Developer/DBA
Requirements:
postgreSQL,Oracle
Linux/Unix/Solaris
Perl, Ruby, Shell scripting
Many Question, mostly focused on SQL basic concept, coding logic, logic in
trouble shooting and tuning
Concept Questions:
1. Difference between Having and Where
2. Difference between Delete and Truncate
3. Joins
4. Difference between IN and Exist (I was not sure about the difference in interview. I just answered: I use IN for assigned value, I use exist for query.)
Coding logic: Intere

B*g2008-12-02 08:12

2 楼

answer for 4 is not good.
for so called interesting question, i am not complete understand the questio
n. But I believe they are asking "connect by" w/o "level", I think I mention
ed before sql server should include this feature.

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

: Position: Database Developer/DBA
: Requirements:
: postgreSQL,Oracle
: Linux/Unix/Solaris
: Perl, Ruby, Shell scripting
: Many Question, mostly focused on SQL basic concept, coding logic, logic in
: trouble shooting and tuning
: Concept Questions:
: 1. Difference between Having and Where
: 2. Difference between Delete and Truncate