Shulou(Shulou.com)06/01 Report--

Ali interview

In 2010, Ali was very popular.

BAT was not as famous that year as it is now. When seeking employment, many graduates still choose foreign enterprises such as HP, IBM, EMC, SONY, ORACLE,Microsoft and so on. In the eyes of graduates, these foreign enterprises represent famous brands, authority, and freedom, yes, freedom is very important, Nice environment, harmonious team, no 996 survival pressure.

However, the gap occurs inadvertently.

With Ali DBA team's vigorous technology sharing speeches, more and more Ali people have published their understanding of technology on blogs and forums. In particular, the application of Oracle technology, the rise of itpub, simply pushed Oracle to the altar. In particular, Fenng this pen, both Oracle master, but also with a particularly excellent influence, so that everyone playing with the database has a special favor for Oracle, people do not know Oracle, even if called DBA is also in vain.

When the Empire State Building was built, it naturally created a group of craftsmen.

Now, the late business is close to the maintenance period, and then go to Ali to engage in Oracle, the time tuyere is no longer. So BAT is no longer a good place for technical people to grow up in the next few years, but those small start-ups may at least have room for your technology to take off.

Of course, if you are engaged in AI, BAT is still the first choice.

In 2010, I also had a touch of admiration. After all, I have been playing Oracle for 2 years, and I am going to try Ali. Ali recruiting new students is also a big scene. The Hongqiao Exhibition Hall is covered with three floors, and the first floor is used to welcome the guests. The written exam passed quickly, and the basic questions are still multiple-choice questions. As long as you have read Oracle Concepts carefully, it should not be a big problem. On the one hand, HR, ask some personal wishes and views on technology, not too arrogant technical people, will not be stuck at this level. In the end, it is an old technology, which is asked in great detail.

As far as I can remember, time passes very slowly, and the whole interview process lasts about one and a half hours. The mineral water given by the interview was almost drunk before it stopped.

The SQL problem that is thousands of miles away.

I think all the interviews will have two parts.

The first part is a review of theoretical knowledge, such as tablespaces, partitions, statistics, log processing, backup and recovery, RAC, OGG and so on. This basic knowledge is covered in Oracle Concepts, Tom's "Oracle Architecture" and "Oracle programming Art". Even if you have only read a few chapters, you can still get by by blowing water. Just like the traveling doctor who secretly practiced the knife skills of the Hu family in Flying Fox of Snowy Mountain, he also dominated the side.

The second part of the actual combat problem is really to examine the foundation. What I remember most is this question, until now, when I interview candidates as an interviewer, I will also use this question, because only this question can examine the candidate's understanding of DB, so as not to fail the DB with a Update/Insert!

The title is as follows:

There is an aggregation table with ID as the main keyword, and the amount of data in the table is 200 million. To merge another table with the same structure, the amount of data in the table is 60 million into the first table.

Please design an update process. The first table may or may not contain some of the data from the second table. Those that do not have to join, and those that match should be updated.

As you might expect, my answer was the same as most of the interviewees I met, and insert/update/merge was over. It all turned out to be negative.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.