. NET Written Exam questions

. NET questions

1. Enumeration of several ways to pass values between ASP.

2. Please write the difference between override and overload

3, please program to implement a bubble sorting algorithm

4. What is packing and unpacking

5. What are the commonly used objects in ADO? Describe separately

6. Brief description of access rights of private, protected, public, internal modifiers

—————————————————————————————————————————————————————————

SQL questions

1. Use a SQL statement to query the names of students who have more than 80 points in the haunted door course.

Name	Kecheng	Fengshu
Tom	Chinese	81
Tom	Mathematical	75
John doe	Chinese	76
John doe	Mathematical	90
Harry	Chinese	81
Harry	Mathematical	100
Harry	English	90

2, the query table A in the presence of ID repeat more than three records, complete query statements

3, use the SQL statement to achieve: from the TestDB data table, the occurrence of all the months is greater than the 101 accounts of the corresponding month of the account. Please note: There are many subjects in the TestDB, there are 1-December occurrence amount

Accid: Account code, OCCMONTB: The amount of the month, Debitoccur: The amount of the occurrence

Database name: Jcyaudit, Data set: SELECT * FROM TestDB

4, using the statement to implement the replication table (copy structure only [source table name: A, new table name: b])

5, with the statement to achieve the schedule five minutes early reminder

6, two related tables, delete the main table (A) already in the Sub-table (B) is not in the information (both Table association fields are ProjId)

7, the table has a B C three columns, with the SQL statement: When column A is greater than column B, select column B otherwise select column B when column B is greater than column C, select column C otherwise

8, the original table:

CourseID	Coursename	Score
1	Java	70
2	Oracle	90
3	Xml	40
4	Jsp	30
5	Servlet	80

For readability, the results after querying this table are explicitly as follows (passing score is 60), please write out the SQL implementation statement

CourseID	Coursename	Score	Mark
1	Java	70	Pass
2	Oracle	90	Pass
3	Xml	40	Fail
4	Jsp	30	Fail
5	Servlet	80	Pass

9, write a stored procedure, enter the school number, from the "Teaching score Table View" Display the student's name, course name, score

10, the ID of a table has multiple records, the record of all this ID, and show the total number of records

. NET Written Exam questions