面试题参考

面试题参考，前面数字代表题目估计需要的回答时间（分钟），部分后面括号代表答案重点。

 

[Common]

• (3m) Self introduction.
• (5m) Work experience.
• (3m) What is your favorite job?
• (3m) What is your role in your job?
• (5m) What is the most difficulty you had in your job? How did you deal with it?
• (3m) What is your next 3 years' career plan?

[SQL]

• (1m) What is the difference between primary key and unique key?          (primary key cannot be null, unique key can be null)
• (1m) How to filter the result set when using grouping?       (use having)
• (3m) What is the difference between bitmap index and b-tree index? How do they work?
• (3m) When to use "in" and when to use "exists"?      (where a.id in (b.id),  b.id should be a small set;    where a.id exists (select 1 from b where b.id=a.id),   b.id is a big set)
• (5m) What is the difference between inner join, outer join and cross join?
• (5m) What is the difference between hash join and sort merge join?
• (3m) What should we pay attention when checking the SQL execution plan?  （table full access, nest loop)
• (3m) Give some advice on SQL tuning.

[BigData]

• (1m) What is HDFS?
• (1m) What is Yarn used for?
• (3m) What is parquet file?
• (3m) What is Spark?
• (3m) What is the difference between Spark RDD, DataFrame and DataSet?

[Programming]

• (1m) In MQ, what is the difference between topic and queue?
• (1m) What is asynchronous call used for?
• (1m) What is thread safe?
• (1m) What is deadlock, for example?
• (3m) If your Java application got hang in Linux environment, list out the things you want to check in sequence.
• (3m) What is micro service?
• (3m) Why we need to consider the consistency in distributed system?
• (3m) What is SQL injection? How to prevent?
• (1m) What is DDOS?

 [CICD]

• (1m) Your understanding of Agile.
• (1m) What is the concept of git commit, branch, tag?
• (3m) The experience of maven, nexus, jenkins, or any other build tool.

[Cloud Computing]

• (3m) Comparing to VM, what is the advantage that container can provide?
• (3m) Give any sample of network file system, and object storage?
• (3m) How to setup SSH key exchange?