Pending Treatment (i)

1. The difference between a value type and a reference type variable. 2. 3 features for object-oriented languages. 3. Asp. NET in the page to pass the parameter several methods. 4. Writes a query statement. Querying 第31-40条 records from the database, the primary key is automatically growing for IDs, and there may be gaps in the middle. 5. The mechanism of the GUID in SQL Server is called what function is generated. 6. SQL database does not exist and connection errors often occur in debugging. Please list the possible causes of the problem that is causing this. 7. In SQL, select COUNT (*) from table, select COUNT (ID primary key) from table, select COUNT (username) from table. Analyze their efficiency differences, the kind of optimality. 8. Briefly describe the concepts of application, session, cookie, cache, ViewState, and the difference between each other. 9. Write a Fibonacci sequence (1,1,2,3,5,8,13,21, ...) with a recursive call function in C # until the 30th digit is calculated. 10. List several design patterns you are familiar with. 11. Design the problems of mice, cats, and people. The cat was asked to call, the mouse ran, and the man was awakened. Ask the cat to be called to affect the extensibility of events. 12. Brief introduction of ASP. NET Object-relational Persistence (ORP) method. 13. Write out the output of the following program, mainly to investigate the difference between the pass by value and by reference.   Specific code is not clear, mainly to investigate the problem of the method parameters. Whether a value parameter changes the value of the original variable, a beref reference parameter, and an object field parameter such as whether (by CLASS.A) A value change affects the original value. What interfaces, or methods, must a 14.foreach object implement? : Under what circumstances will you use virtual methods? How does it differ from the interface? What is the difference between q:override and overloading? Q: What is the difference between a value type and a reference type? Q: How do I understand static variables? Q: How many ways are there to send requests to the server? What is the difference between a q:datareader and a dataset? Q: If you need to pass the variable value in a B/s structure, but you can not use session, Cookie, application, you have   several methods to deal with it? Q: Using. NET to do b/s structure of the system, you are using a few layers of structure to develop, each layer of the relationship between and why so layered? Q: How many stages does the software development process generally have? The role of each stage? Q: Microsoft has launched a series of application Block,Can you tell me what you know about the application block and explain its role? Q: Please list some of the design patterns you have used and under what circumstances do you use this mode? Q: How do you feel about webservice? Q: What is your interest in programming? How to solve the problem that you don't understand at work? How do you generally improve your programming level? Q: What is the reason for your departure?   The following topics if you do not, please describe your solution in more detail Q: How to pass the Chinese parameters through hyperlinks? Q: Do you programmatically traverse all TextBox controls on the page and assign it a value of String.Empty? Q: Do you programmatically implement a bubbling sorting algorithm? 1.c# supports multiple inheritance and explains why. 2. Elaborate on the differences between cookies, viewstate, sessions, and how they work. 3. What are the general steps to programming network communication using sockets in C #? 4.int[][] myarray3=new int[3][]{new int[3]{5,6,2},new int[5]{6,9,7,8,3},new int[2]{3,2}};myarray3[2][2] is the value (). 5. You want to create an ASP. NET application to run a Web site within a company that contains 50 pages. You want to configure this application so that when an HTTP code error occurs, it can display a custom error page to the user. You want to spend the least amount of time accomplishing these goals, what should you do? 6. Do you know the URL Rewrite? Please briefly describe its rationale and how it is implemented in ASP. What are the differences between 7..net2.0 and. net1.1? 8. Write a selection sorting algorithm in C #, requiring your own programming style. < two > Intelligence Class 1, if there are 64 lattice, the first lattice is 1, the second grid is 2, the third grid is 4, then the number of the last lattice should be how much? 2, you let the workers work for you for 7 days, the return to the workers is a gold bar. Gold bars are divided into 7 connected segments, and you have to give them a piece of gold at the end of the day, and if you only have to break the gold bars two times, how do you pay your workers? 3, < three > program Development Skills 1, please write down the production process and management of the software development project in your Mind 2, write a connection to the database in C # 3, please write the data set of query database table T in the DataGrid all the code is written out to 4, Please briefly write out the FTP server and the client program 5, please use JavaScript to write the implementation of the dynamic report function code 6, please briefly write a B/s mode of C # user custom control, requirements are userLogin Window < four > database technology 1, if there is a 1000 records of the table T, the table has a, B, c three fields, write a stored procedure, according to input parameters @p (Specify page) and @s (Specify page size), query table t out of the specified page content 2, there is a table T has a field a, When each record is added, create a new table based on the value of field a, and write out the implemented code. A Blank question: 1. The three major characteristics of a class are () () () (). 2. A maximum of () tables or views can be specified in the FROM clause of the SELECT statement, separated by (), to indicate the table or view object in the available () format when the queried table is not in the current database. 3. The command to create the stored procedure is () the command to delete the table is (). 4. The function that calculates the sum of the fields is: (), the function that counts the number of items is: (). 5. In a relational database, the primary key is (). 6. The keyword that declares the abstract class is (), and the abstract class cannot (). 7.. The NET runtime supports a reference type called (), which acts like the purpose of a function pointer in C + +. 8. The full name of the XML is (). 9. All types in C # are essentially derived from the () class. 10. The keyword that declares a static variable is (), and the keyword that declares the constant is (). 11. The memory management feature in C # is (). 12. In C #, it is called () to explicitly convert a value or reference to another different type. 13. In ADO. NET, the command object is executed with the () () () method. 14. b/s commonly used structural design models are divided into () () (). 15. The three types of index types included in SQL Server are () () () ().   Two. Brief answer: 1. What is intermediate language (IL)? What is its role? 2. What are crates and unboxing? 3. Out ADO. What are the main classes that read and write databases in net? Their role? 4. What are the similarities and differences between interfaces and classes in C #? 5. Explain the ASP. NET in the Code-behind?  6. What is ASP. NET user controls? 7. In C #, string str = null and string str = "" Please try to explain the differences. 8. What is a regulated code? 9. What are the common forms of Access in C #? Their respective scopes? What is the understanding of stored procedures in SQL SERVER? What are the explanations for each of the CTS,CLS,CLR? ASP. NET and ASP's main advantages? What is the error handling mechanism for. NET? 14. Explain the Page.IsPostBack attribute? What kinds of technologies are included in the 15..net framework? 16. Triggers are divided intoWhat is the difference between pre-trigger and post-event triggering? 17. Explain the use of having in SQL SERVER2000? 18. Explain the use of group by in SQL SERVER2000? 19. Explain the overloads of the methods in C #? 20. What is a transaction? 21. Describes the next ASP. What is the difference between using the DataReader object and the DataSet object in net? 22. Analyze the similarities and differences between classes and structures? 23. Explains ADO. What is the difference between using close () and Dispose () of the connection class in net? 24. Describes ADO. NET the role of the Dataadapte class? 25. What is WebService? 26. Line following code: String strtemp = "ABCDEFG"; Int i System.Text.Encoding.Default.GetBytes (strtemp). Length;  int j = strtemp.length; Q: What is the reason for i= (); j= ()?

27.. Describe the ASP. NET of several validation controls (Equiredfieldvalidato, CompareValidator, RangeValidator, Regularexpressionvalitor, CustomValidator, ValidationSummary) and role?   Three. Programming Questions: 1. There are three tables, structured as follows: STUDENT (student ID, name, gender, date of birth) COURSE (course number, course name, instructor) SC (student ID, course number, score, instructor)   Complete the following operations with standard SQL statements 1. Check the basic situation of female students and arrange 2 in descending order of student ID number. The name of the student who has scored above 90 points is 3. Query Math Class Course number and course name (fuzzy Query, start with s) 4. Check the course number and results of the selected course, and the name and gender of the student 5. Check the average score of 6 for course No. 03. Remove the student's name from the failing grade 7. The student ID of 90876 students selected for the No. 01 course grade was changed to 80 points 2. In SQL Server servers, there are two field IDs in the given table Table1, Lastupdatedate,id represents the updated transaction number, and Lastupdatedate represents the server time when the update occurs, using an SQL statement to obtain the last updated transaction number. A Fill in the Blanks 1..NET Framework includes () () () () three Technologies 2. The operator ++x represents (), and X + + represents (). 3. Software testing methods are divided into () (). 4.. NET to achieve interoperability of objects under heterogeneous platforms by compiling the language first () and then executing it with () compiling the cost platform code for the 5. The statement that is declared in the middle of SQL SERVER is () the statement that is released is (). 6. The programming language for SQL Server is () Language 7. The keyword for the delegate declaration is (). 8. In MS SQL Server, the system stored procedure used to display database information is () 9. In the SQL language, the statement used for rollback of a transaction is (). 10. If there are m:n connections between two entities, the result of converting them to a relational model is () tables. 11. Codebehind mainly by putting () and () in different files to achieve code separation. 12. In C #, the conversion of a value type to a reference type is called (), and a reference type is converted to a value type called () 13. The three types of index types included in SQL Server are () () () (). 14. The three major documents of software engineering () () (). 15. In SQL SERVER2000Four-Medium constraint () () () () ().   Two. Brief answer 1. What is intermediate language (IL)? What is its role? 2. What are the keywords in C # that communicate with the base class? What is the role? 3. What is meta data? 4. Asp. NET and ASP's main advantages? 5. What is the difference between override and overload? 6. What is the understanding of triggers in SQL SERVER? 7. What is the difference between ref and out? 8. Probably described under ASP. NET the lifecycle of server controls? 9. What is a strongly typed system? 10. Triggers are divided into pre-trigger and post-trigger, what is the difference? 11. Talk about final, finally, finalize the difference. 12. is Appplication.exit or form.close different in. NET (C # or vb.net)? 13. What is a delegate in C #? Is the event a delegate? 14. What is the difference between a value type and a reference type? 15. Explain the overloads of the methods in C #? 16. Analyze the similarities and differences between classes and structures? 17. The difference between & and &&. 18. Describe how to differentiate between Excutenonquery and Excutescalar methods? 19. Explain why the file system has data redundancy? What are the two typical problems caused by this data redundancy? 20. What is WebService? 21. What is the difference between an interface and an abstract class? 22. Describe constructors and destructors in a class? 23. Explain the assemblies in C #? 24. There is a return statement in try {}, then the code in the finally {} immediately after this try will not be executed, when is it executed, before or after the return? 25. What are the two types of SQL Server indexes? The role of the index? What are the advantages and disadvantages of indexes? 26. Talking about the characteristics of C/s and b/s

  three. Programming Questions: 1. Has the following relationship table   supplier SUPPLIER (sno,sname,city) SNO supplier number, SNAME is the name of the supplier, City town   part parts (pno,pname,weight) PNO part number, PName part name, Weight weight   project JOB (jno,jname,city) Jno project number, Jname project name, city location   Contact SPJ (sno,pno,jno,qty) QTY for quantity 1. Find the supplier number SNO &NBSP;2 to the engineering J1 providing the part P1. Find the supplier in Beijing to Wuhan's project to provide part number 3 of the parts. Find the part name provided by the supplier S1 pname  4. Find the city value of Shanghai's project number and name 5, the project J3 to Guangzhou 6. Replace all parts weighing 20 kilograms with weight 10 kg 7. The supplier of the parts P1 to the engineering J1 will be replaced by S2  8 S1. Add the value (S3, Lingtao, Wuhan) to supplier 9. Delete data for all Shanghai projects

2. There is a table with the users as follows number (int) Name (char)  1 a  2 b  3 b  4 a  5 c  6 C requirements: When the Name column has the same, only the value on the column is reserved Small line, the result should be as follows: number (int) Name (char)  1 a  2 b  5 c Q: Implemented with the delete of the SQL statement. (Remember, is an SQL statement) one. Blank question: 1. The three major characteristics of a class are () () () (). 2. A maximum of () tables or views can be specified in the FROM clause of the SELECT statement, separated by (), to indicate the table or view object in the available () format when the queried table is not in the current database. 3. The command to create the stored procedure is () the command to delete the table is (). 4. The function that calculates the sum of the fields is: (), the function that counts the number of items is: (). 5. In a relational database, the primary key is (). 6. The keyword that declares the abstract class is (), and the abstract class cannot (). 7.. The NET runtime supports a reference type called (), which acts like the purpose of a function pointer in C + +. 8. The full name of the XML is (). 9. All types in C # are essentially derived from the () class. 10. The keyword that declares a static variable is (), and the keyword that declares the constant is (). 11. The memory management feature in C # is (). 12. In C #, it is called () to explicitly convert a value or reference to another different type. 13. In ADO. NET, the command object is executed with the () () () method. 14. b/s commonly used structural design models are divided into () () (). 15. The three types of index types included in SQL Server are () () () ().   Two. Brief answer: 1. What is intermediate language (IL)? What is its role? 2. What are crates and unboxing? 3. Out ADO. What are the main classes that read and write databases in net? Their role? 4. What are the similarities and differences between interfaces and classes in C #? 5. Explain the ASP. NET in the Code-behind?  6. What is ASP. NET user controls? 7. In C #, string str = null and string str = "" Please try to explain the differences. 8. What is a regulated code? 9. What are the common forms of Access in C #? Their respective scopes? What is the understanding of stored procedures in SQL SERVER? What are the explanations for each of the CTS,CLS,CLR? ASP. NET and ASP's main advantages? 13. What is the error handling mechanism for net? 14. Explain the Page.IsPostBack attribute? What kinds of technologies are included in the 15..net framework? 16. Triggers are divided into pre-trigger and post-trigger, what is the difference? 17. Explain the use of having in SQL SERVER2000? 18. Explain the use of group by in SQL SERVER2000? 19. Explain the overloads of the methods in C #? 20. What is a transaction? 21. Describes the next ASP. What is the difference between using the DataReader object and the DataSet object in net? 22. Analyze the similarities and differences between classes and structures? 23. Explains ADO. What is the difference between using close () and Dispose () of the connection class in net? 24. Describes ADO. NET the role of the Dataadapte class? 25. What is WebService? 26. Line following code: String strtemp = "ABCDEFG"; Int i System.Text.Encoding.Default.GetBytes (strtemp). Length;  int j = strtemp.length; Q: What is the reason for i= (); j= ()?

27.. Describe the ASP. NET of several validation controls (Equiredfieldvalidato, CompareValidator, RangeValidator, Regularexpressionvalitor, CustomValidator,  ValidationSummary) and role? Three Programming Questions: 1. There are three tables, structured as follows: STUDENT (student ID, name, gender, date of birth) COURSE (course number, course name, instructor) SC (student ID, course number, score, instructor) complete the following operations with standard SQL statements 1. Check the basic situation of female students and arrange 2 in descending order of student ID number. The name of the student who has scored above 90 points is 3. Query Math Class Course number and course name (fuzzy Query, start with s) 4. Check the course number and results of the selected course, and the name and gender of the student 5. Check the average score of 6 for course No. 03. Remove the student's name from the failing grade 7. The student ID of 90876 students selected for the No. 01 course grade was changed to 80 points 2. In SQL Server servers, there are two field IDs in the given table Table1, Lastupdatedate,id represents the updated transaction number, and Lastupdatedate represents the server time when the update occurs, using an SQL statement to obtain the last updated transaction number. 1. What is the advantage of the difference between property and attribute in C #, and what are the benefits of such a mechanism? 2. Tell me about the Web service that you understand, how well the XML is combined in the DOT NET Framework (and the concept is OK) 3. C #, Java and C + + features, what are the same places, different places, C # from C + + and Java to draw their advantages? 4. Can C # directly manipulate memory? (This is a difficult point oh?) Be careful! ) 5. Code written in Visual C + + 6.0 (unmanaged code), how to combine with other dot net component under the CLR?

6. A number of projects that have been previously made? Introduce your own programming experience. (This is not the past, the basic question will know is true) 7. What do you expect from the company? What is your salary expectation? Why learn computer? Previous work experience (this is very important)?

Q3: Maintain database integrity, consistency, do you prefer to use triggers or self-write business logic? Why Q4:ado. What are some of the major improvements in net versus ADO? Q5:asp. NET compared with ASP, what is the main progress? What are the delegates in q6:c#? Is the event a delegate? Q7: Describe the implementation of indexers in C #, and can they be indexed only by numbers? What is the implementation process for a class to support a foreach traversal in q8:c#? Q10: Write an HTML page, to achieve the following functions, left click on the page to display "Hello", right click on the display "No right button." and automatically closes the page after 2 minutes.

Q11: Do you know anything about XMLHTTP and WEBSERVICE? Simply describe its characteristics, function Q12: What is the difference between an interface and an abstract class? What is the basis of your choice to use interfaces and abstract classes? Q13: What are the similarities and differences between custom controls and general user controls? What would you choose if you were to use one of these two? Why Q14: Roughly describe the ASP. NET server control life cycle Q15:UML Q16: Object-oriented concept, main features Q17: The basis of class division. The problem of class granularity Q18: Problems in the management of things

First, to talk about final, finally, finalize the difference. Second, Anonymous Inner class (anonymous inner Class) can extends (inherit) other classes, can implements (implement) interface (interface)?  Thirdly, the Static Nested class and the Inner class are different, the more said the better (some of the questions are very general).  The difference between,& and &&. The difference between HashMap and Hashtable.

The difference between the Collection and the collections.  VII, when to use the Assert. What's the GC? Why do you have a GC? Ninth, String s = new string ("XYZ"; number of string Object created? Tenth, Math.Round (11.5) how much? Math.Round (-11.5) how much?

11th, short S1 = 1; S1 = s1 + 1; what's wrong? Short S1 = 1; S1 + = 1; what's wrong? 12th, what is the difference between sleep () and wait ()? 13th, does Java have a goto? 14th, does the array have the length () method? Does string have the length () method? 15th, the difference between overload and override. Can the overloaded method change the type of the return value?

16th, the elements in set cannot be duplicated, so what is the method used to distinguish between duplicates or not? Are you using = = or equals ()? What is the difference between them?  17th, give me one of your most common runtime exception. 18th, what is the difference between error and exception? 19th, List, Set, map inherit from collection interface? 20th, what is the difference between abstract class and interface?

21st, whether the abstract method can be static at the same time, whether it can be native at the same time, can it be synchronized? 22nd, can interfaces inherit interfaces? is an abstract class achievable (implements) interface? Does an abstract class inherit entity classes (concrete Class)? 23rd, start a thread with run () or start ()? 24th, can the constructor constructor be override? 25th, is it possible to inherit the string class?

26th, when a thread enters an synchronized method of an object, does the other thread have access to other methods of this object? 27th, there is a return statement in the try {}, then the code in the finally {} immediately after the try will not be executed, when executed, before or after the return? 28th, the programming question: the most efficient way to figure out 2 times 8 and so on? 29th, two object values are the same (x.equals (y) = = true), but can have different hash code, this sentence is not correct? 30th, when an object is passed as a parameter to a method, this method can change the properties of the object and return the changed result, so is this a value pass or a reference pass?

31st, whether the Swtich can function on a byte, whether it can function on a long, whether it can work on a string? 32nd, the programming question: Write a singleton out.

Database aspects:

1. Differences between stored procedures and functions 2. What is a transaction? 3. What is the role of cursors? How do I know that the cursor is at the end? 4. The trigger is divided into pre-trigger and post-trigger, and the two triggers have and differ from each other. What is the difference between a statement-level trigger and a row-level trigger.

1. Use C # to implement the following function a produces an int array, a length of 100, and a random insertion of 1-100 into it, and cannot be duplicated. b sort the array generated above, need to support ascending, descending order of 2. Please describe the methods used to pass parameters between pages in. NET, and say their pros and cons. 3. Please describe the error handling mechanism in. NET, and Example 4. Please say the meaning of the strong name 5. Please list the methods of several loops in C # and indicate their differences 6. Please indicate base class 7 for all types in. Net. Please indicate the meaning of the GAC 8. In SQL Srever, new data is inserted into a table, how to quickly get the current value from the Increment field

Under what circumstances do you use virtual methods? How does it differ from the interface? What is the difference between q:override and overloading? Q: What is the difference between a value type and a reference type? Q: How do I understand static variables? Q: How many ways are there to send requests to the server? What is the difference between a q:datareader and a dataset? Q: If you need to pass the variable value in a B/s structure, but you can not use session, Cookie, application, how many methods do you handle? Q: Using. NET to do b/s structure of the system, you are using a few layers of structure to develop, each layer of the relationship between and why so layered? Q: How many stages does the software development process generally have? The role of each stage? Q: Microsoft has launched a series of application blocks, please name what you know Application block and explain its role? Q: Please list some of the design patterns you have used and under what circumstances do you use this mode? Q: How do you feel about webservice? Q: What is your interest in programming? How to solve the problem that you don't understand at work? How do you generally improve your programming level? Q: What is the reason for your departure? Q: How can I pass the Chinese parameters via hyperlinks? Q: Do you programmatically traverse all TextBox controls on the page and assign it a value of String.Empty? Q: Do you programmatically implement a bubbling sorting algorithm?

1, override and overload of the difference 2,. NET error handling mechanism 3, C # interface and class similarities and differences 4, DataReader and dataset similarities and differences

1. There are several ways to implement a class to access the member functions and properties of another class, and to give a list to illustrate and analyze. 2. If you need to record the number of instances of the class, how to implement, please write a simple class to prove. 3.A class is the base class of Class B, and has its own structure, destructors, please give examples of Class B from instantiation to extinction process of construction, destructor execution process. 4. You need to implement the processing of a string, first of all, the string is removed, if there are contiguous spaces in the middle of the string, only one space is allowed, that is, allow more than one space in the middle of the string, but the number of consecutive spaces must not exceed a single.

One. The three-dimensional operator in the fill-in question 1.c# is __?:___? 2. When the integer A is assigned to an object, the integer a will be boxed (encapsulated) __? 3. Does the class member have an accessible form of _____? this.; New Class ().  Method; 4.public static const int a=1; Is this code wrong? What is it?  Const can not be modified with static 5.float f=-123.567f;  int i= (int) F; The value of I is now _____? 123

6. Is there anything wrong with operator statement and only declaring "= ="? 7. What is the keyword of the delegate declaration? Delagete 8. What are the characteristics of a class decorated with sealed? Sealed, cannot inherit 9. All custom user controls must inherit from ________ in ASP. Control 10. All serializable classes in. NET are marked as _____?

11. We don't have to worry about memory leaks in. NET managed code because of the ______?GC 12. Is there any error in the following code?  _______ copy save using System;  Class A {public virtual void F () {Console.WriteLine ("A.F");  }}} abstract class B:a {public abstract override void F ();//new public abstract void f (); }

13. When the class T only declares the private instance constructor, then outside of the program text of T, ___ can derive a new class from T, either ___ (or not), and no instance of T can be created directly by ____ (or not).  14. Is there an error in the following code?  Copy save switch (i) {case 0:casezero ();  Break  Case 1:caseone ();  Break Case 2:dufault;  Wrong Casetwo ();  Break }

15. In. NET, can a class System.Web.UI.Page be inherited? OK

Two. Brief answer

1. What is the meaning of the two keywords using and new in C #, please write the meaning you know? Using directives and statement new Create instance new hides the base class in method 4. Talk about the difference between class and structure? A class is a reference type, a struct is a value type 5. A string of length 10000 is composed of randomly extracting 10,000 characters from A-Z. Please write the main program in C # language to implement.  6. For such an enumeration type: Copy save enum Color:byte {Red, Green, Blue, Orange} string[] ss = Enum.getnames (typeof (Color)); byte[] bb = enum.getvalues (typeof (Color));

Try to write a program that shows all the symbol names defined in the enumeration type and their corresponding values. 7. Do you understand design patterns? Please list the name of the design pattern you know. 8. Design a table in SQL Server to hold an organization chart of a tree structure (assuming that only the name in the structure is required to save), what do you think if I want to query all the positions in a position and use a stored procedure to implement it? 9. What is SQL injection and how do I prevent it? Please illustrate. 10. What does the following code output?  Why?  copy save int i = 5;  int j = 5; if (Object.referenceequals (i, J)) Console.WriteLine ("Equal");  else Console.WriteLine ("Not Equal"); Not equal, because the object is compared

1. Write a method that implements the flip of a string, attaching some conditions, such as ",", ".", to the design of the test case. 2. A paper cup design test case (can be generalized cup, not necessarily a particular function of the cup) development of the concept of the language 3. What is reflection? 4. How to write design patterns with singleton What is the garbage collection mechanism in 5.c#?

6. What is Application Pool? 7. The difference between the list and the array, what are the advantages and disadvantages. 8.Remoting How is the client server implemented? 9. What is a friend function? 10. How to achieve polymorphism with standard C?

11. What is a virtual function? 12. What are abstract functions? 13. What is a memory leak, and what is the simplest way to determine which leaks are stored?

English questions

14. Introduce the project using c#/c++ in English, the main function 15. How to communicate with U.S. engineers if you want to have a conference call with US 16. What would you say if your boss thinks you're behind the technology?

Database knowledge problem

17. What is the tool used to invoke the stored procedure 18.SQL server in what form are the two indexes? The role of the index? What are the advantages and disadvantages of indexes? 19. Effects of triggers

Other knowledge questions and problems

20. What is a Web Service? 21. What is XML? How is 22.Socket implemented?

Someone's answer, please point out my mistakes.

1. What is the advantage of the difference between property and attribute in C #, and what are the benefits of such a mechanism? One is a property, a field for accessing a class, one is an attribute, an additional property used to identify a class, a method, etc.

2. Tell me about the Web service that you understand, how well the XML is combined in the dot NET Framework. (Speaking of concept is OK) no, learning

3. C #, Java and C + + features, what are the same places, different places, C # from C + + and Java to draw their advantages? The same point: all of the C-system, are object-oriented differences: java,c# are built on the virtual machine mechanism, and C + + is not

4. Can C # directly manipulate memory? (This is a difficult point oh?) Be careful! ) can be

5. Code written in Visual C + + 6.0 (unmanaged code), how to combine with other dot net component under the CLR? Compile Dll,[dllimport]

6. A number of projects that have been previously made? Introduce your own programming experience. (This is not the past, the basic question will know is true) 7. What do you expect from the company? What is your salary expectation? Why learn computer? Previous work experience (this is very important)?

Q3: Maintain database integrity, consistency, do you prefer to use triggers or self-write business logic? Why triggers, good performance, transactional

Q4:ado.  What are some of the major improvements in net versus ADO? new datasets, etc., no need to stay connected at all times, improved performance

Q5:asp. NET compared with ASP, what is the main progress? ASP explanation form, aspx compiler type, improve performance, help protect the source code

What are the delegates in q6:c#?  Is the event a delegate? A delegate is a safe function pointer, and an event is a message mechanism

Q7: Describe the implementation of indexers in C #, and can they be indexed only by numbers? No

What is the implementation process for a class to support a foreach traversal in q8:c#? Implementing an interface

Q10: Write an HTML page, to achieve the following functions, left click on the page to display "Hello", right click on the display "No right button." and automatically closes the page after 2 minutes. JS Code

Q11: Do you know anything about XMLHTTP and WEBSERVICE? Simple description of its characteristics, the role of XMLHTTP can proactively obtain remote Web code, similar to HttpWebRequest

Q12: What is the difference between an interface and an abstract class?  What is the basis of your choice to use interfaces and abstract classes? Interfaces are used for specifications, and abstract classes are used for commonalities.

Q15:UML Unified Modeling Language

Q16: Object-oriented concept, main features encapsulation, base, polymorphic

Database aspects:

1. The difference between stored procedures and functions stored procedures are compiled well stored in the database operations, the function needless to say ...

2. What is a transaction? Have atomic characteristics

3. What is the role of cursors?  How do I know that the cursor is at the end? Indicates the location of the current record, checking for null

4. The trigger is divided into pre-trigger and post-trigger, and the two triggers have and differ from each other.  What is the difference between a statement-level trigger and a row-level trigger. One is before operation, one is after operation

1.  Use C # to implement the following function a produces an int array, a length of 100, and a random insertion of 1-100 into it, and cannot be duplicated.  Copy Save int[] intarr = new int[100];  ArrayList myList = new ArrayList ();  Random rnd = new Random (); while (Mylist.count <) {int num = rnd.  Next (1, 101);  if (!mylist.contains (num)) mylist.add (num); } for (int i = 0; i < i++) intarr[i] = (int) mylist[i];

b sort the array generated above, need to support ascending, descending two order ArrayList itself can sort

2. Please describe the methods used to pass parameters between pages in. NET, and say their pros and cons. Session (viewstate) simple, but easy to lose application global cookie simple, but may not support, may be forged input ttype= "hidden" simple, may be forged URL parameters simple, displayed in the Address bar, length limited database stability Safe, but with relatively weak performance

3. Please describe the error handling mechanism in. NET, and example try catch final

4. Please say the meaning of the strong name has its own key, can be in the GAC for the public

5. Please list several methods of looping in C # and indicate their different for Wile foreach

6. Please indicate the base class of all types in. NET Object

7. Please indicate the meaning of the GAC Global Assembly cache

8. SQL srever, insert new data into a table, how to get the current value of the Increment field quickly select @ @id ... Something, forget it.

Under what circumstances do you use virtual methods?  How does it differ from the interface? It's been said before

What is the difference between q:override and overloading? One is to rewrite the parent class function, and one is the same function in several forms

Q: What is the difference between a value type and a reference type? difference between a value and a pointer

Q: How do I understand static variables? A variable that is common to all instances

Q: How many ways are there to send requests to the server? Get post

What is the difference between a q:datareader and a dataset? One is a forward-only read-only cursor, one is an in-memory table

Q: If you need to pass the variable value in a B/s structure, but you can not use session, Cookie, application, how many methods do you handle? Input type= "" URL database

Q: Using. NET to do b/s structure of the system, you are using a few layers of structure to develop, each layer of the relationship between and why so layered? Three layers, performance, logic, data, security, maintainability

Q: How many stages does the software development process generally have?  The role of each stage? Requirements analysis, architecture design, code authoring, QA, deployment

Q: Please list some of the design patterns you have used and under what circumstances do you use this mode? The famous singleton

Q: What is your interest in programming? How to solve the problem that you don't understand at work? How do you generally improve your programming level? Q: What is the reason for your departure? Q: How can I pass the Chinese parameters via hyperlinks? UrlEncode UrlDecode

Q: Do you programmatically traverse all TextBox controls on the page and assign it a value of String.Empty? Foreach

1. There are several ways to implement a class to access the member functions and properties of another class, and to give a list to illustrate and analyze. The same name control is directly, or reflected

2. If you need to record the number of instances of the class, how to implement, please write a simple class to prove.  const static int classnum=0; classnum++;

3.A class is the base class of Class B, and has its own structure, destructors, please give examples of Class B from instantiation to extinction process of construction, destructor execution process. After the formation of the father, the analysis of the reverse

4. You need to implement the processing of a string, first of all, the string is removed, if there are contiguous spaces in the middle of the string, only one space is allowed, that is, allow more than one space in the middle of the string, but the number of consecutive spaces must not exceed a single. String inputstr= "xx xx"; Inputstr=regex.replace (Inputstr.trim (), "*", "";

Two. Brief answer

1. What is the meaning of the two keywords using and new in C #, please write the meaning you know? Using directives and statement new Create instance new Hide base class method using introduce namespace or use unmanaged resource new new instance or hide parent class method

4. What is the difference between class and structure? A class is a reference type, a struct is a value type

5. A string of length 10000 that consists of randomly extracting 10,000 characters from A-Z.  Please write the main program in C # language to implement. Same as the one in front.

6. For such an enumeration type: Copy save enum Color:byte {Red, Green, Blue, Orange} string[] ss = Enum.getnames (typeof (Color)); byte[] bb = enum.getvalues (typeof (Color));

Try to write a program that shows all the symbol names defined in the enumeration type and their corresponding values. Foreach

9. What is SQL injection and how do I prevent it?  Please illustrate. Use the SQL keyword to attack a website. Filter keywords ' etc

10. What does the following code output?  Why?  copy save int i = 5;  int j = 5; if (Object.referenceequals (i, J)) Console.WriteLine ("Equal");  else Console.WriteLine ("Not Equal"); Not equal, because the object is compared

1. Write a method that implements the flip of a string, attaching some conditions, such as ",", ".", to the design of the test case. Inputstr=inputstr.tochararray (). Reverse (). ToString ();

2. A paper cup design test case (can be generalized cup, not necessarily a particular function of the cup) is too wide ...

Developing language concept Questions

3. What is reflection? Dynamically getting assembly information

4. Using singleton how to write design mode static property inside new, constructor private

What is the garbage collection mechanism in 5.c#? Three generation, check references when each generation memory is full, reclaim memory without references

6. What is Application Pool? Web application, similar to thread Pool, improves concurrency performance

7. The difference between the list and the array, what are the advantages and disadvantages. One can dynamically grow, a fixed (VB can be ReDim), performance array teaches good

8.Remoting How is the client server implemented? 9. What is a friend function? Friendly declaration, you can access the Protect level method

11. What is a virtual function? Can be rewritten

12. What are abstract functions? Must be rewritten

13. What is a memory leak, and what is the simplest way to determine which leaks are stored? C++,c forgot to release memory, memory will not be allocated again

Database knowledge questions 17. What tools are used to invoke a stored procedure in any language

What are the two types of indexes for 18.SQL server? The role of the index? What are the advantages and disadvantages of indexes? Cluster and non-cluster, speed up lookups, take up extra controls, and maintain indexing time consuming

19. Trigger action to ensure database operation changes can be notified

Other knowledge problems and questions 20. What is a Web Service? Enables applications to be called throughout the Web

21. What is XML? Extensible Markup Language, can make configuration files, can transfer data, can store data

How is 22.Socket implemented? This does not know how to say ... Student Student Information Sheet ID (primary key) name Sex Class Sch chart ID (primary key) Name Score score table ID Uid (foreign key references Student (I d) Sid (foreign key references Sch (ID)) Num A asks for the total number of classes B for 1 boys and 2 for girls in Class C for the number of students who failed in the "data type" class in each class. Use the stored procedure to write a crosstab.

Pending Treatment (i)