1.17, people's bank interview
The graduate students have a lot, and there are several doctors. And I am just an undergraduate student of a second-class school, because the relationship between the four levels, the degree can not be a problem.
Because of his own sitting, I didn't hear my name when I first reported my name, and the result was squeezed to the seventh time.
Interview
First of all, the examiner let me introduce myself for three minutes. I roughly said my own situation, I actually forgot to say parents, or the examiner reminded, sweat.
Then, let me talk about the understanding of the People's Bank. I said that I know that the People's Bank is China's highest financial management agency, exercising central banking functions, now, some functions have been exercised by the SFC and the Bank of China.
Then, I took me two major questions: 1. Simple talking about how the stored procedure is going, what is used; 2. Resolve RIP and OSPF, and the advantages and disadvantages. Khan, I only know that the stored procedure is used in the database. It is for security or efficiency. If you choose to give up; RIP and OSPF, Khan, know that OSPF is used in the router. Routing protocol.
Finally, I asked me some of my social practice experience. Simply said, then flee it.
Failure is destined. But not afraid, there is no failure, which is successful.
Through this interview, I found that my knowledge is still very shallow.
. Oh, learn the sea, continue to continue. . .
Attachment:
Store procedure:
The stored procedure is a program written by using the TRANACT-SQL language provided by SQL Server. The TRANACT-SQL language is SQL Server provides a language designed to design a database application, which is the primary programming interface between the application and the SQL Server database. It is better than the Informix-4GL language that Pro-SQL and Informix in the Oracle database system. Such languages mainly provide the following functions, allowing users to design programs that meet the reference requirements:
1), variable description
2), ANSI compatible SQL commands (such as SELECT, UPDATE ....)
3) General flow control command (if ... else ..., while ....)
4), internal functions
Rip & OSPF:
RIP (Routing Information Protocols, Routing Information Protocol) is the most wide range of distance vector protocols, which is developed by Xerox in the 1970s. At that time, RIP was part of the XNS (Xerox Network Service, Xerox Network Services) protocol cluster. The TCP / IP version of RIP is an improvement version of the Xerox Agreement. The biggest feature of RIP is that regardless of the principle or configuration method, it is very simple. RIP is based on hop calculation routing and sends update messages to neighbor routers.
The OSPF protocol was developed in the 1980s. In the 1990s, it became an industrial standard, which is a typical link state protocol. The main features of OSPF include: supporting VLSM (shielding long subnet), fast convergence, low bandwidth usage, and the like. The OSPF protocol exchanges link status information between neighbors so that the router establishes a link state database (LSD). After that, the router uses SPF (Shortest Path First, shortest path priority) algorithm based on the information in the database, and selects the route. The main basis is bandwidth.
