1What do you think is your greatest achievement??
2What is the difference between Bandwidth and bandwidth?
Bandwidth is the transmission rate, which refers to the maximum number of bytes transmitted per second (MB/S), that is, the number of megabytes processed per second. high bandwidth means the high processing capability of the system. Broadband: refers to the use of special technologies or devices on the same transmission medium. Different channels can be used for multiple (parallel) transmission at a rate above kbps, the speed above is counted as broadband, and there is no international standard. In short, Broadband refers to the access method, and bandwidth refers to the network traffic.
3Frequent database backup in order to prevent accidental backup, what are the backup methods of SQL Server? What should I pay attention to during backup?
SQL Server supports two backup methods: one is to use backup database to back up database files, and the other is to directly copy database files MDF and log files LDF. Normally, we need to back up a database. First, we need to disconnect the database from the running data server, or stop the entire database server, and then copy the file.
4How should I delete two associated tables in the database?
(1) Delete all records in the associated sub-table and then the primary table. (2) cascade deletion.
5What is object-oriented language and What features does it have?
Object-oriented language (object-oriented language) is a type of programming language that uses objects as the basic program structure units, objects are the basic components of the runtime. The language provides classes, inheritance, and other components. Object-oriented language depicts objective systems more naturally and facilitates software expansion and reuse. There are four main features: (1) recognition, the basic components in the system can be recognized as a group of identifiable discrete objects; (2) classification, all objects with the same data structure and behavior in the system can constitute one class; (3) polymorphism, the object has a unique static type and multiple possible dynamic types; (4) Inheritance, share data and operations in different types of basic hierarchies.
6.What are UDP and TCP?
TCP-the transmission control protocol provides connection-oriented and reliable byte stream services. Before the customer and the server exchange data with each other, a TCP connection must be established between the two parties before data can be transmitted. TCP provides timeout resend, discard duplicate data, test data, traffic control, and other functions to ensure data can be transferred from one end to the other.
UDP-the User Datagram Protocol is a simple datagram-oriented transport layer protocol. UDP does not provide reliability. It only sends the data from the application to the IP layer, but it cannot guarantee that the data can reach the destination. Because UDP does not need to establish a connection between the client and the server before transmitting the datagram, and there is no timeout and re-transmission mechanism, the transmission speed is very fast.
7What is a deadlock? What are the solutions?
An ignorant waiting state caused by multiple processes competing for resources. Without external force, these processes will never be able to move forward.
Solution: prevent deadlocks, avoid deadlocks, detect deadlocks, and remove deadlocks.
8What is information asymmetry?
Information Asymmetry refers to the difference in the quantity and quality of the information held by both parties. That is, one party has a large amount of information and a high level of quality, while the other party has the opposite.
9What is white box testing and black box testing??
Black box testing: the functional design specifications of products are known. You can perform tests to verify that each implemented function meets the requirements. White-box testing: it is known that the internal working process of the product can be tested to verify whether each internal operation meets the design specifications and whether all internal components are inspected. The software black box testing means that the testing should be performed at the software interface. In this way, the test object is regarded as a black box. The tester does not consider the logical structure and internal characteristics of the program, but only according to the specification of the program, check whether the function of the program complies with its function description. Therefore, black box testing is also called function testing or data-driven testing. White box testing is a detailed inspection of the procedural details of the software. In this way, the test object is regarded as an open box, which allows the tester to design or select a test case to test all the logical paths of the program using the logical structure and related information in the program. Check the program status at different points to check whether the actual status is consistent with the expected status. Therefore, a white-box test is also called a structure test or a logic-driven test.
10How much do you know about GIS?
Geographic Information System (GIS) is a computer-based tool that can map and analyze things and events that exist on the earth. GIS technology integrates the unique visual effects and geographic analysis functions of maps with general database operations (such as query and statistical analysis. This capability distinguishes GIS from other information systems, so that it has practical value in explaining events, forecast results, and planning strategies in a wide range of public and individual enterprises.