Central Asia Network interview Summary

Central Asia Network interview Summary

Time: 2011/11/2

1. jquery selector?

The interview Summary of Vince has been summarized.

2. What do you think about Ajax?

1> about its definition, Ajax (Asynchronous JavaScript and XML) Is a technology that updates a part of a webpage without loading the entire webpage.

2> advantages:

A> good user experience.

B> reduce the pressure on the server.

3. What are the differences between classes and structures?

1> A class is a reference type, while a structure is a value type.

2> structures are implicitly sealed, so they cannot be derived.

4. What is the difference between a sequence table and a chain table in the data structure?

To be improved.

Answers found on the website:

Sequence Table: static storage. Static memory space is allocated based on the data size.

Chain table: dynamic storage. I don't know how much data there is, so I need to dynamically allocate memory space.

5. Database paging?

The interview Summary of Vince has been summarized.

6. database design, tree-structured database, designed on a table?

To be improved.

7. Table join?

Inner join)

ExampleCode:

Select fnumber, fprice from tb_order inner join tb_customer on fcustomerid = FID where tb_customer.fname = 'Tom ';

8. subquery?

Select top 10 * From tb_student not in (select top 20 * From tb_student );

9. What are the parameters and descriptions of the POST method in jquery?

$. Post (URL, [data], [callback], [type]);

URL: the URL of the requested HTML page.

[Data]: The key/value pair sent to the server will be appended to the request URL as querystring.

[Callback]: callback function. The callback function automatically passes the request result and status to the method only when the load is successful.

[Type]: the format of the data returned by the server. Including XML, HTML, and text.