(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?
浙公网安备 33010602011771号