Asp. NET Programmer interview Questions

Name: _______________________

A logical part (10 points)

1, you ask a worker for you to work for seven days, you pay him a gold bar, gold bars have been evenly divided into seven segments, at the end of each day you have to pay workers a section, this gold bar can only be broken two times, how to pay? (6 points)

2, (4 points)

The following is a group of numbers, please? "The place should be ()

1, 4, 10, 、?、...... ......

Binary ASP (15 points)

1, (2 points) in IIS, the default ASP. NET scripting language is __________ _________________.

2, (2 points) Form submission usually there are two ways to submit: Get and post, ask request from the form to receive parameters

The code is ___ __,__ __ respectively.

3, (2 points) if you need to read and write to the file, the component object that is typically usedin ASP. __ __ ___.

4, (6 points) as a set of numbers, use code to write out statements in the ASP.

7, 3, 6, 1, 2, 5, 8, 4, 9

5. Describe the main difference between Server.Transfer () and Response.Redirect (). (3 points)

Three. NET part (40 points)

1, according to the following conditions to answer questions

Condition: A.

Known database server IP is 192.168.1.100, login user Name System, password system, database name test

Condition: B.

Known table Tb_user

ID userName Password

1 System System

2 Admin Admin

Question 1: Write out the statement of the database connection? (3 points)

For:

Question 2: Please query all the records in the table Tb_user and show on the foreground page? (7 points)

For:

2, (5 points)

Class Class1

{

public static int Count = 0;

Static Class1 ()

{

count++;

}

Public Class1 ()

{

count++;

}

}

Class1 O1 = new Class1 ();

Class1 O2 = new Class1 ();

Excuse me, what is the value of Class1.count? ()

A. 1 B. 2 c. 3 D.4

3, (10 points)

Abstract class BaseClass

{

public virtual void MethodA ()

{

Console.WriteLine ("BaseClass");

}

public virtual void MethodB ()

{

}

}

Class Class1:baseclass

{

public void MethodA ()

{

Console.WriteLine ("Class1");

}

public override void MethodB ()

{

}

}

Class Class2:class1

{

newpublic void MethodB ()

{

}

}

Class MainClass

{

public static void Main (string[] args)

{

Class2 o = new Class2 ();

O.methoda ();

}

}

Excuse me, this program output is ()

　　　

A. BaseClass B.bassclass Class1 c.class1 d. Class1 Bassclass

4, (5 points) The following answer is ()

public static void Main (String[]args)

{

int i = 2000;

Object o = i;

i = 2001;

int j = (int) o;

Console.WriteLine ("I={0},o={1},j={2}", i,o,j);

}

1.i=2001,o=2000,j=2000 2. i=2001,o=2001,,j=2001

3.i=2000,o=2001,,j=2000 4. i=2001,o=2000,j=2001

5, (10 points) talk about some of the core objects of the database processing in ADO and explain its role?

Quad JavaScript section (10 points)

1, (6 points) please use JavaScript to write the following test txt1 cannot be empty and must be a number of judgment statement.

<form id= "Form1" Name= "Form1" >

<input type= "text" id= "txt1" name= "Txt1" >

</form>

2, (4 points) when Arg1 is 3,arg2 is 7 the value of the function is ()

function MyFunction (arg1, arg2)

{

var R;

var n = 5;

r = arg1 * ARG2;

return (n);

}

Five Database section (25 points)

1. The Newspaper Sales database table of a newspaper company is as follows:

Table: Tb_paper

(Newspaper type table)

ID Paperid Papername

(int)                      (varchar) (varchar)

1 P0001 Enterprise Daily

2 P0002 Enterprise Evening News

3 P0003 Jiangnan Business Daily

4 P0004 Technical Daily

5 P0005 Market Herald

Table: Tb_sale

(Sales table)

ID Paperid sale_date sale_ Amount

(int)                      (varchar)                            (datatime) (int)

1                           p0001                           2007-2-8                               8960

2                           p0002                           2007-2-8                               5812

3                           p0003                           2007-2-8                               8753

4                           p0004                           2007-2-8                               8753

5                           p0005                           2007-2-8                               9846

6                           p0003                           2007-2-9                               4568

7                           p0002                           2007-2-9                               2456

8 P0005 2007-2-9 9854

Question 1, (5 points) write a newspaper with an SQL statement that averages more than 5200 sales by newspaper type?

For:

Question 2, (5 points) Use the SQL statement to write out the top three newspapers for the February 8, 2007 sale. If the third place has n, it should be queried.

For:

Question 3, (5 points) to achieve the increase in newspaper type function, please use the stored procedure write to determine the existence of a newspaper type? Returns 1 if present, and returns 0 instead.

Stored Procedure name: Usp_querypapertype

Parameters: Paperid and Papername

For:

2, (10 points) please write a 1 to 100 program statement with the SQL statement?

For:

The data for the known table is as follows:

Id Uname UNo

1 a 1

1 B 2

1 C 3

2 I 1

2 am 2

2 a 3

2 Student 4

Id UName

1 ABC

2 Iam a student

Write a SQL statement to implement the transformation.

Answer:

Asp. NET Programmer interview Questions