I'd agree with SP -- if it's entry level, I'd worry more about the person's general knowledge, how well their personality meshes with the organization, and their willingness and aptitude to learn more.
I was doing a telephone interview for a PL/SQL programmer (with no advance warning), and for one of the questions, the candidate said he didn't know, but he was fairly sure the answer was in a given book. I accepted that as a right answer -- for entry level, admitting that you don't know everything is pretty important.
If you're asking what you should look over before the interview -- I'd say don't study too much, or you might stress out and make a bad impression. Normally, I'd look see if the person has good skills for the job at hand, but I don't know what they're hiring for ... so if you want to look at something, a good understanding of cursors and sql statement tuning go a long way.
When interviewing PL/SQL developers for entry position I except: 0. Ability to write simple SQL queries for simple examples (joins, aggregates) 1. Understanding common concepts (triggers, indexes, sequences) 2. Understaning Shcema/User Oracle concepts, grants and synonyms 3. Understanding packages, procedures and functions concepts 4. Ability to write on PL/SQL as normal procedural language (assignments, loops, procdeures, types, etc)
If only 0. and 1. statisfied additional expirience on other big SQL server (Sybase, Microsoft) required. And time to learn after hiring, of course :)
P.S. At period of active entry-level programmers hiring (not now :( ) we require for entry level only degree in CS and ability to learn.
From a technical point of view, I would expect the candidate to be able to create tables, perform simple selects, joins, inserts, updates and deletes.
While interviewing them I would ask questions about working with dates and strings, cursors etc, asking more detailed questions until they couldn't answer. At that point I'd ask them what they would do to find an answer. With consulting the Oracle help files, asking a team member or web searches being acceptable answers.
Entry level applicants must demonstrate the following skills:
Ability to find the interview site successfully.
Can breathe in and out without prompting.
Demonstrate adequate control of voluntary bodily functions.
Successfully spell own name. Use of items such as driver's license, credit cards, etc, as aids is acceptable.
OK, but seriously...
I'd expect an entry-level applicant to be able to demonstrate some basic familiarity with programming (iteration, loops, subroutines). Give them a logic test - see how they do. Have them show that they can write some very basic DML queries. Polite - no attitude. Ability to listen. Ability to talk coherently. Dress and deportment reasonable for an office setting. (This means you can have all the tattoos and body piercings you want, and can wear the most eclectic clothing you like - but I won't be hiring you).
发布评论
评论（6）
我同意 SP 的观点——如果是入门级的，我会更担心这个人的常识、他们的个性与组织的契合程度，以及他们学习更多知识的意愿和能力。
我正在为一位 PL/SQL 程序员进行电话面试（没有提前警告），对于其中一个问题，应聘者说他不知道，但他相当确定答案就在一本给定的书中。我接受了这是一个正确的答案——对于入门级来说，承认你不知道一切是非常重要的。
如果你问面试前应该看什么——我会说不要研究太多，否则你可能会压力很大并给人留下不好的印象。通常情况下，我会看看这个人是否具备适合手头工作的技能，但我不知道他们招聘的目的是什么......所以如果你想看一些东西，对游标和 sql 有很好的理解语句调整有很长的路要走。
I'd agree with SP -- if it's entry level, I'd worry more about the person's general knowledge, how well their personality meshes with the organization, and their willingness and aptitude to learn more.
I was doing a telephone interview for a PL/SQL programmer (with no advance warning), and for one of the questions, the candidate said he didn't know, but he was fairly sure the answer was in a given book. I accepted that as a right answer -- for entry level, admitting that you don't know everything is pretty important.
If you're asking what you should look over before the interview -- I'd say don't study too much, or you might stress out and make a bad impression. Normally, I'd look see if the person has good skills for the job at hand, but I don't know what they're hiring for ... so if you want to look at something, a good understanding of cursors and sql statement tuning go a long way.
我想说，对于入门级职位，您应该拥有学位并学习过一两门数据库课程。无需经验。
I'd say for an entry level position you should have a degree and have taken a course or two on DBs. No experience necessary.
在面试 PL/SQL 开发人员的入门职位时，我除了：
0. 能够为简单示例（连接、聚合）编写简单的 SQL 查询
1. 理解常见概念（触发器、索引、序列）
2. 了解 Shcema/User Oracle 概念、授权和同义词
3. 理解包、过程和函数的概念
4. 能够像普通过程语言一样在 PL/SQL 上编写（赋值、循环、过程、类型等）
如果只有 0. 和 1. 则需要在其他大型 SQL 服务器（Sybase、Microsoft）上满足额外的经验。当然，还有招聘后的学习时间:)
PS 在活跃的入门级程序员招聘期间（不是现在:( ），我们只需要入门级的 CS 学位和学习能力。
When interviewing PL/SQL developers for entry position I except:
0. Ability to write simple SQL queries for simple examples (joins, aggregates)
1. Understanding common concepts (triggers, indexes, sequences)
2. Understaning Shcema/User Oracle concepts, grants and synonyms
3. Understanding packages, procedures and functions concepts
4. Ability to write on PL/SQL as normal procedural language (assignments, loops, procdeures, types, etc)
If only 0. and 1. statisfied additional expirience on other big SQL server (Sybase, Microsoft) required. And time to learn after hiring, of course :)
P.S. At period of active entry-level programmers hiring (not now :( ) we require for entry level only degree in CS and ability to learn.
汤姆·凯特是谁？
Who is Tom Kyte?
从技术角度来看，我希望候选人能够创建表，执行简单的选择、连接、插入、更新和删除。
在采访他们时，我会问有关使用日期、字符串、光标等的问题，询问更详细的问题，直到他们无法回答为止。那时我会问他们会做什么来找到答案。查阅 Oracle 帮助文件、询问团队成员或网络搜索都是可接受的答案。
祝面试顺利。
From a technical point of view, I would expect the candidate to be able to create tables, perform simple selects, joins, inserts, updates and deletes.
While interviewing them I would ask questions about working with dates and strings, cursors etc, asking more detailed questions until they couldn't answer. At that point I'd ask them what they would do to find an answer. With consulting the Oracle help files, asking a team member or web searches being acceptable answers.
Good luck with the interview.
入门级申请人必须具备以下技能：
好吧，但说真的……
我希望入门级申请人能够表现出对编程（迭代、循环、子例程）的一些基本熟悉程度。给他们一个逻辑测试——看看他们做得如何。让他们展示他们可以编写一些非常基本的 DML 查询。礼貌——没有态度。倾听的能力。能够连贯地说话。着装和举止适合办公室环境。 （这意味着您可以拥有您想要的所有纹身和身体穿孔，并且可以穿您喜欢的最不拘一格的衣服 - 但我不会雇用您）。
Entry level applicants must demonstrate the following skills:
OK, but seriously...
I'd expect an entry-level applicant to be able to demonstrate some basic familiarity with programming (iteration, loops, subroutines). Give them a logic test - see how they do. Have them show that they can write some very basic DML queries. Polite - no attitude. Ability to listen. Ability to talk coherently. Dress and deportment reasonable for an office setting. (This means you can have all the tattoos and body piercings you want, and can wear the most eclectic clothing you like - but I won't be hiring you).