Home > Net >  The interview C#.NET technology and database technology problem what?
The interview C#.NET technology and database technology problem what?

Time:10-01

A c #. NET technology

1, ASP.NET MVC control permissions?

2, the CTS in C#.NET, CLS and the CLR?

3, what is a multi-threaded, how to create and how to use? Please write a multi-threaded singleton pattern?

4, what is the singleton pattern?

5, could you please tell me about what you know about design patterns?

6, please draw the flow chart of the abstract factory?

7, what is the Lambda expressions?

8, what is a Linq expression?

9, what is asynchronous, what is a delegate?

10, what is the MVC, why want to use the MVC, it is how to control, what is a routing?

11, the request of the MVC is how to get the controller?

12, how does a browser requests to the server?

13, what is a single sign-on (sso)?

14, could you please tell me something about the principle of the Session, life cycle, how to set up, if the login is not use Session with what?

15, what is the workflow?

16, would you please introduce a WCF, why want to use WCF, the difference between the WCF and Web Service?

17, would you please introduce a Web API, why use WebAPI?

18, would you please tell me something about the ASP.NET page lifecycle?

19, would you please tell me about an abstract class?

20, would you please tell me something about the packing and unpacking?



The database technology

1, when the table data, how to optimize the query, how to improve the data table?

2, what is the difference between SQL Server and Oracle?

3, data storage, fault tolerance and performance optimization?

4, in a project you how to design the database, data table, how to optimize?

5, what is the index, why want to use the index, how to create an index, index of classification and differences (the only index, aggregation index, etc... . )?

6, what is a stored procedure, why use a stored procedure, how to create a stored procedure?

7, what is the trigger, when to use the trigger, and how to create a trigger?

8, what is a cursor, how to create a cursor, cursor is how to use?

9, what a deadlock?
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Rich sharp group welcomes you!!!!!
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Copyright statement: this article to CSDN blogger (pan_junbiao) of the original articles, follow BY CC 4.0 - SA the copyright agreement, reproduced and this statement, please attach the original source link
The original link: https://blog.csdn.net/pan_junbiao/article/details/53053941

CodePudding user response:

CodePudding user response:

Not to say that the

Interview rocket, screw work


Many companies are the existence of the loading force, or not enough to reflect on their tall

CodePudding user response:

1. You can inherit AuthorizeAttribute MVC permissions control, override AuthorizeCore method
2. CLS..net language specification, CTS language rules, the CLR language runtime
3. The thread can be understood as a process that executes a unit of
4. The singleton, no matter how many object instantiated, he will always be the one in the initialization
5. Design patterns is essential for object-oriented programmers build solution architecture
6. An abstract class - "inherited abstract classes - & gt; & & & The abstract factory class to create inherited abstract class
7. Lambma are actually simplified method
8. Linq is combined with the characteristics of SQL.net syntactic sugar
9. Is don't have to wait for the execution of the asynchronous execution, entrust method is actually instantiate
10. MVC is the front end of the three layer UI layers, MVC is clear separation of the front end and data manipulation, manipulation of the view by the controller returns
11. The processrequest - & gt; Walker set - "get routing controller with the same name class -" instantiate the class - "method is called
12. Through httpmodule pipeline model and an httphandler distribution page and message
13. You just need to visit once, you can log in all the trust system
14. Maintain server to store the data of a technical session, life cycle, the session in access server is to create the first time, failure time can set sessin timeout parameter
15. The workflow, as the name suggests, work management processes of a process or a technical thinking
16. The WCF is essentially webservices encapsulation, a service framework,
17. Webapi implements resulful specification, can be very good side before and after the separation, collaborative
The inadequacy of abstract classes to solve specific problems, the abstract into a method, abstract class must have an abstract method, abstract methods there can be no method body, cannot be instantiated
20. Packing, value type to a reference type, split open a case is, in turn,

Database technology
1. The large amount of data can be indexed, can be operated by a table, can build a distributed database etc.
2. Oracle cross-platform, SQL can only Windows, storage model, structure model, security, openness, and so on are different
3. The data capacity of disaster need to listen to each other and the return of the state of different database, fault tolerance need to roll back the results and data analysis process, such as performance optimization, such as answer 1
4. The design of database and data table large capacity, logging, error correction, disaster, distributed, fusing mechanisms such as the need to create additional database in advance, optimization, such as answer 1
5. Index can greatly improve the query speed, a single index can query one column, aggregation index can query more columns
6. The stored procedure is essentially the combination of a series of SQL statements, stored procedure can solve a large number of SQL statements need to be repeated or cumbersome process, create proc create
7. The trigger is essentially an action to complete or start trigger another action to perform, typically in a data change another use when also need to change, the create tigger create a trigger
8. A CURSOR, is the removal of the specified data to the specified location, DECLARE cursor_name CURSOR to create a CURSOR
9. The deadlock, two processes or threads competing for resources is stagnant or collapse caused by program,
  • Related