NET part interview summary (with answer), more than a large amount of pen test works

Some of the problems encountered in this interview are very basic, some of which I have not heard of. Depending on the experience or the position and the company, the interview problem must be different. I am a female programmer, 2.5 net development experience, this is my year after the application of ASP. NET engineer encountered problems, carried out some simple collation and summary, I think with the online large length of the topic is more useful, issued for your reference, hope not to spit groove, there are any problems the great God can guide me. The first time to write a blog, I hope someone support .....

1, JS traversal: each (), For,foreach
2. MCV detail View: @Html. Action, @Html. Partial (without controller), html.renderaction,html.renderpartial
3, DataReader each time only in memory load a piece of data, DataReader is only in, read the first article can not read the first.
A DataSet is a one-time load of data into memory, discarding database connections.

The 4, three-tier architecture and MVC are clearly different, and MVC should be a presentation pattern (three adds up to the UI layer in the three-tier architecture). , MVC splits the UI layer in the three-tier architecture into a controller, a view, a three-part entity

5. SQL declaration variable: DECLARE, Assignment: Set, select
6. The stored procedure returns the result: return
7, the override must inherit, the overload does not have, the overridden method name, the parameter number is the same, the parameter type is compatible, the heavy L loads the method name the same, the parameter list is different; must be overridden in the same class, in different classes;

8. Data concurrency Processing

Pessimistic concurrency control (thing Lock): After the data has been removed from the database, it is locked until the data has been updated before the user can take the data out. This way can be passed. NET provides a transaction mechanism to implement, provided that the data source needs to support transactions. This type of control is very much used for performance and resources, and because only one user can have access to the data at the same time, it may affect the process of other users in normal business.
Development concurrency control: Data can be used by other users before it is updated, and records are locked only when updated. For this kind of control method, the developer through the business logic of the program itself to achieve. The disadvantage is that this update may not be completed because other users may have updated the data. The last update takes effect: This is the same way, only when the data is updated, other users are not available, but the update does not check whether it is consistent with the start data, and directly update it. The disadvantage is the possibility of triggering inconsistencies in the data before and after. This approach is suitable for use in business scenarios that can meet this requirement.

9. SOA service-oriented architecture is a component model that links different functional units (called services) of an application through well-defined interfaces and contracts between these services.

10. SaaS Software as a service it is a mode of providing software over the Internet. For many small businesses, SaaS is the best way to adopt advanced technologies that eliminate the need for businesses to purchase, build, and maintain infrastructure and applications.

11, ADO and the difference: Because ADO uses COM technology, this requires that the data type used must conform to the COM specification, and ADO based on XML format, the data type is richer and does not need to do COM orchestration caused by the data type conversion, thereby improving the overall performance.

12. WPF, WCF, WF, WCS (WPF) is the next-generation display system that generates a WINDOWS client application that brings a stunning visual experience to the user.
(WCF) is a runtime and a set of APIs for creating systems that send messages between services and clients. ABC: three-factor address, communication, contract
WCF simplifies the development of affiliate applications through a new service-oriented programming model.
(WF) is an extensible framework for developing a workflow solution on a Windows platform.
WCS is a new generation of unified authentication solutions.

13, HTTP Protocol Hypertext Transfer Protocol. Hosted on the TCP/IP protocol. Defines how file transfers are communicated between the server side and the client. HTTP is an object-oriented protocol belonging to the application layer, which is suitable for distributed hypermedia information System because of its simple and fast way. No state protocol, no memory for transmitting things

14. The core technologies of the. NET Framework are: Common Language runtime (Clr:common Language Runtime), class library, ASP. NET and ADO

15, IL intermediate language of the advantages of two points, one is to achieve platform-independent, not related to the specific CPU, the second is to just put. NET Framework to be compiled into IL code, the implementation of a language. The interaction between languages in the NET Framework.

16, Heap: arbitrarily randomly assigned class reference type

Stack: Advanced back-out system provides variable value type

17, query the top three of each class, can sentence:
SELECT * FROM
(select Row_number () (Partition by class ORDER by score desc) rank, * from SC) t
Where ranking <=3 order by class Asc,score desc

Row_number (), over,partition by is the focus

Of course, these are only part of the interview questions, their own interview summary of some of the experience, recorded, so that everyone reference, they can also strengthen the memory, next time with = =

Here is a friend of the public number of technical categories, interested in the attention. Access to relevant resources or other questions can be in the public number of messages. If you have excellent original technical articles can also contribute to share to earn the Bounty yo!

Sweep for more development resources:

NET part interview summary (with answer), more than a large amount of pen test works