1. What is XML? What is the difference with HTML?
Answer: XML stands for Extensible Markup Language. Full name of HTML: HyperText Markup Language, HyperText Markup Language. The differences are as follows:
XML is a supplement to HTML. The HTML display data is concentrated on the appearance. XML describes the data and integrates with the data content.
XML is similar to HTML and does not perform any operations. It is just a description.
Different from HTML, XML architecture is defined by the author without restrictions. HTML is predefined and can only be marked as supported by the HTML standard.
2. Use C # To Implement Bubble sorting.
Answer:
Code
Private static void Sort (int [] arr)
{
Int I, j, n = 0, temp = 0;
N = arr. length;
Bool f = true;
For (I = 0; I <n-1; I ++)
{
F = true;
For (j = n-1; j> I; j --)
{
If (arr [j] <arr [j-1]);
{
Temp = arr [j];
Arr [j] = arr [j-1];
Arr [j-1] = temp;
F = false;
}
}
If (f = true)
{Break ;}
}
}
3. The table contains three fields: Student ID, class, and score. The highest score of each class is queried;
Answer: select classid, max (score) from score group by classid;
4. What is MFC?
Answer: MFC = Microsoft Foundation Classes, Microsoft basic class
5. Briefly describe the features of SQL;
Answer:
1. integrated and unified: DDL: Data Definition Language; DML: Data Control Language; DCL: Data Control language;
2. Highly procedural: you only need to point out what to do and do not need to specify how to do it;
3. Set-oriented operations: Set Operations are adopted. Not only can the search result be a set of tuples;
4. The same syntax structure provides two usage methods: self-contained language and embedded language;
5. The language is concise, easy to learn, and easy to use;
6. What is the difference between DELETE and truncate table in SQL?
Answer: it is the same as the DELETE statement without the WHERE clause. It is faster and has fewer system resources and system logs;