. NET software engineer interview

. NET software engineer interview question 1. Blank question:

1. The three major features of a class are (encapsulation) (inheritance) (polymorphism ).

2. A maximum of (256) tables or views can be specified in the from clause of the SELECT statement. They must be separated by commas (,). When the queried table is not in the current database, available (Database Name. owner name. table Name) format to indicate the table or view object.

3. The command for creating a stored procedure is (create proc stored procedure name) the command for deleting a table is (drop table name ).

4. The sum of calculated fields is: (SUM), and the count function is: (count ).

5. In relational databases, the primary key is (foreign key ).

6. the keywords for declaring abstract classes are abstract. abstract classes cannot be sealed ).

7. the. NET Runtime Library supports the reference type called (delegate), which is similar to the function pointer usage in C ++.

8. The full name of XML is (Extensible Markup Language ).

9. C # all types are actually derived from (object) classes.

10. The keyword for declaring static variables is (static), and the keyword for declaring constants is (const ).

11. C # processes the memory management function (managed code ).

12. In C #, it is used to explicitly convert a value or reference to another different type (unpacking ).

13. In ADO. Net, the command object is to use (excutenonquery) (excutescalar) (excutedatareader) method to execute the command.

14. The structure design models generally used by B/S are divided into (model) (View) (control ).

15. The three index types in SQL Server are (primary key index) (unique index) (clustered index ).

. NET software engineer interview question 2. Short answer:

1. What is an intermediate language (IL )? What does it do?

A: The code must be compiled into a hosted code before execution. It has nothing to do with the CPU instruction set.

Function: supports platform independence and language interoperability.

2. What is packing and unpacking?

A: The value type is converted to the reference type and the reference type is converted to the value type.

3. Output ADO. Which of the following are the main classes used to read and write databases in. Net? What are their functions?

A: Connection database connection; command executes SQL statements or stored procedures; dataadapter is used to fill in dataset and update a set of database data commands and database connections, disconnect mode; datareader, reads database information, is read-only and forward; dataset data is cached in memory.

4. What are the similarities and differences between interfaces and classes in C?

A: A class is a reference type. It can inherit classes, interfaces, and be inherited. It has default constructor, destructor, abstract and sealed, and protected modifier, new must be used for initialization.

The structure is a value type and can only inherit interfaces. It cannot be inherited. There is no default constructor, and can be created without destructor. abstract and sealed cannot be used without the protected modifier, new Initialization is not required.

How to choose a structure or a class:

1. The stack space is limited. For a large number of logical objects, creating classes is better than creating structures.

2. structure indicates lightweight objects such as dots, rectangles, and colors. For example, if an array containing 1000 vertex objects is declared, additional memory will be allocated to each referenced object. In this case, the structure cost is low.

3. Classes are the best choice for presentation of abstract and multi-level object Layers

4. In most cases, the structure is the best choice when this type is only some data.

5. Explain ASP. Net code-behind?

A: The code is hidden. The code that shows the logic is separated from the code of the processing logic.

6. What is asp. Net user control?

A: Controls created by Asp.net code can be reused on multiple ASP. NET pages just like controls created on standard ASP. NET web pages.

7. in C #, specify the differences between string STR = NULL and string STR =.

A: String STR = NULL: no space is allocated. String STR = "": space is allocated.

8. What is regulated code?

A: The Code managed by the public language runtime environment is mainly responsible for memory management. The code running on the. NET platform is controlled code.

9 C # common access forms? Their respective scopes?

A: Unrestricted public access.

Private can only be accessed in this class

Protected this class and access from its inherited class

Internel indicates that it can be used in the same application or library.

10. What are the stored procedures in SQL Server?

A: The stored procedure is a pre-compiled set of SQL statements and optional control flow statements. It is stored in a name and processed as a unit. Stored procedures are stored in a database and can be executed by an application through a single call. They also allow users to declare variables, conditional executions, and other powerful programming functions.

11. What are the explanations of CTS, CLS, and CLR?

A: CTS: Public-type systems are mainly used for standardization between languages.

CLS: The minimum standard group that ensures code access in any language

CLR: when running in a common language, it mainly manages code, processes, loads code, and Code of all services.

12. asp. Net and ASP?

A: Advantages of ASP. NET:

ASP. net is free from the disadvantages of ASP's scripting language. Theoretically, any programming language, including C ++, VB, and JS, can be used. Of course, the most suitable programming language is ms. net frmaework specifically released C (read C sharp), it can be seen as a mix of VC and Java, although Ms speak C # kernel more like VC, but I still think it is more like Java. First, it is an object-oriented programming language, rather than a script, so it has all the features of object-oriented programming language, such as encapsulation, inheritance, polymorphism, etc, this solves the vulnerabilities of ASP just mentioned. Encapsulation makes the code logic clear, easy to manage, and applied to ASP. net can separate the business logic from the HTML page, so no matter how the page prototype changes, the business logic Code does not need to be modified. Inheritance and polymorphism greatly improve the reusability of the Code, you can inherit existing objects to maximize your previous investment. C # provides a complete debugging/error correction system like C ++ and Java.

13. What is the error handling mechanism of. Net?

A: Try {code that may cause errors}

Catch {handling of caught errors}

Finally {execution is required no matter whether the Code has an error or not}

14. What are the page. ispostback attributes?

A: When a user browses this webpage for the first time, page. ispostback will return false, not true when the user browses this webpage for the first time.

Which technologies does 15..net framework contain?

A: Application Framework, domain framework

16. What is the difference between trigger triggering beforehand and trigger afterwards?

A: The trigger runs before the trigger event occurs, and the trigger runs after the trigger event occurs. The trigger can obtain the new field values before the event.

17. Explain the usage of having in SQL Server2000?]

A: filter data in a group.

18. How to Use group by in SQL Server2000?

Answer: Group

19. What is the heavy load of methods in C?

Answer: The overload method uses the same method name, but specifies different parameters (number and type ).

20. What is a transaction?

A: In many large and critical applications, computers execute a large number of tasks every second. More often than not, these tasks are combined to complete a Business Requirement, called transactions. When a task fails, it is restored to the specified recovery point, which is called rollback.

21. Describe ASP. What is the difference between a datareader object and a DataSet object in net?

A: DataSet is the data structure for data storage. In the disconnected mode, datareader is not responsible for data storage. You need to manually close the connection to the database. It is only responsible for reading data from the data source to the local machine, it is read-only forward. It is not a data structure, but a high-level encapsulation of network communication components.

22. What are the similarities and differences between analysis classes and structures?

A: A class is a reference type. It can inherit classes, interfaces, and be inherited. It has default constructor, destructor, abstract and sealed, and protected modifier, new must be used for initialization.

The structure is a value type and can only inherit interfaces. It cannot be inherited. There is no default constructor, and can be created without destructor. abstract and sealed cannot be used without the protected modifier, new Initialization is not required.

How to choose a structure or a class:

1. The stack space is limited. For a large number of logical objects, creating classes is better than creating structures.

2. structure indicates lightweight objects such as dots, rectangles, and colors. For example, if an array containing 1000 vertex objects is declared, additional memory will be allocated to each referenced object. In this case, the structure cost is low.

3. Classes are the best choice for presentation of abstract and multi-level object Layers

4. In most cases, the structure is the best choice when this type is only some data.

23. Explain ADO. What is the difference between the close () and dispose () of the connection class in net?

A: Close is only disabled, and dispose is used to release resources.

24. Description of ADO. What is the role of the dataadapte class in net?

A: connect to the database in disconnected mode and fill in dataset.

25. What is WebService?

A: Web services use soap (Simple Object Access Protocol, Simple Object Access Protocol) to execute remote method calls over HTTP, you can also use the Web Service Description Language (WSDL) to completely describe the Web service based on the XML standard.

26. After the following line of code:

String strtemp = "abcdefg ";

Int I system. Text. encoding. Default. getbytes (strtemp). length;

Int J = strtemp. length;

Q: I = (14); j = (11)

Why?

A: Chinese characters occupy 2 bytes, So I = 14

27. Describe ASP. . Net validation controls (equiredfieldvalidato, comparevalidator, rangevalidator, regularexpressionvalitor, customvalidator, validationsummary) and their functions?

A:

A) requiredfieldvalidator (field verification is required );

B) comparevalidator (comparison verification );

C) rangevalidator (range verification );

D) regularexpresionvalidator (Regular Expression );

E) validationsummary (Verification summary );

F) customvalidator (custom verification)

. NET software engineer interview question 3. Programming question:

1. There are three tables with the following structure:

Student (student ID number, name, gender, date of birth)

Course (course number, course name, instructor)

SC (student ID number, course number, score, instructor)

Use standard SQL statements to complete the following operations

1. query the basic information about girls and sort them by student ID number in descending order.

A: Select * from student where gender = 'femal' order by student ID number DESC

2. query the names of students whose scores are over 90.

Answer: Select name from student, SC where student. Student ID = SC. Student ID and SC. score> 90

3. query the course number and name of a mathematics course (fuzzy query, starting with S)

A: select course No. Course name from course where Course name like's %'

4. query the course number and score of the selected course, and the name and gender of the student.

Answer: select course number, score, name, gender from SC, student, Course

Where SC. Student ID = student. Student ID

And course. course No. = SC. course No. Group by student ID

5. query the average score of course 03

Answer: Select AVG (score) from SC where course No. = '03'

6. Delete the name of the student whose score fails.

Answer: delete from student where student ID number in (select student ID number from SC where score <60 );

Delete from SC where score <60;

Note: The order of deletion cannot be reversed.

7. Change the score of course 01 selected by the student ID card number 90876 to 80.

A: Update SC set score = '80' where student ID = '000000' and course number = '01'

2. in the sqlserver server, the given table Table1 contains two field IDs and lastupdatedate. ID indicates the updated transaction number, and lastupdatedate indicates the server time when the update is performed, use an SQL statement to obtain the last updated transaction number. (10)

A: Select ID from Table1 where lastupdatedate = (select max (lastupdatedate) from Table1)

The above interview Materials. NET software engineer interview question highlightsAfter a period of work experience, it can become a senior software engineer, Algorithm Application Development engineer, and demand engineer, however, it requires a wealth of software development experience and technical background for relevant work. If you want to become a technical elite and project manager, you also need to have strong management and organizational skills.

Original article address