2014 network administrator-exam exercise Questions and answers (5)

51cto college specially sorted out "2014 network administrator-exam exercise Questions and Answers" in the soft exam preparation season to help schools pass smoothly! For more software proficiency test counseling and questions, please pay attention to the 51cto college-soft exam classification!

View summary:Exercise questions and answers for the 2014 soft exam Network Administrator examination [summary]650) This. width = 650; "alt =" popular article "src =" http://www.exam8.com/images/hot.gif "style =" padding: 0px; margin: 0px; Vertical-align: middle; Border: 0px; "/>

　　I. Single-choice questions(Each space corresponds to a sequence number, which has four options: A, B, C, and D. select the most appropriate option for the answer ).

1st in Windows, you can ensure that you do not know which program to use to create a document long ago __________.

[Correct answer]: c

[Reference]: in windows, use the "Search" command in the "Start" menu to find this document, double-click it to open a document that was created a long time ago and cannot be remembered.

2nd lan network software mainly includes network database management system, network application software and __________.

[Correct answer]: c

[Reference]: lan network software mainly includes network database management system, network application software and network operating system.

Question 3rd: Anti-Virus is a regular task. Which of the following is not the key factor __________.

[Correct answer]: B

[Reference]: This question examines the knowledge of computer viruses.

The key to anti-virus work is to strengthen the management of computer systems and pay attention to preventive measures for virus intrusion. For a computer floppy disk, a series of methods can be used to prevent computer viruses from spreading. For example, you can keep enough copies of the floppy disk and add write protection to minimize the objects and ranges of floppy disk exchanges, strengthen inspection and testing of programs with viruses.

Answer the following questions ~ 8 questions

A relational database is a set of (1), which is defined by one or more relational modes. The data definition function in SQL includes the definition of databases, basic tables, (2), and (3.

Student (student ID, name, age, gender, Department name). If you want to query a name that contains at least five letters, the SELECT statement is as follows:

Select student ID, name, Department name

From students

Where (4) Like (5 );

Select (1) the best answer for question 4th.

[Correct answer]:

[Reference Analysis]: relational databases use relational models as the data organization mode. In relational models, tables are used to express the relationships between object sets and object sets.

The data definition function of SQL, the most common relational database language, includes the definition of databases, basic tables, indexes, and views.

In SQL, the most common operation on strings is to use the like operator for pattern matching. Two special characters are used to describe the mode: "%" matches any string, and "_" matches any character. The mode is case sensitive.

Select (2) the best answer for question 5th.

[Correct answer]: B

[Reference Analysis]: relational databases use relational models as the data organization mode. In relational models, tables are used to express the relationships between object sets and object sets.

The data definition function of SQL, the most common relational database language, includes the definition of databases, basic tables, indexes, and views.

In SQL, the most common operation on strings is to use the like operator for pattern matching. Two special characters are used to describe the mode: "%" matches any string, and "_" matches any character. The mode is case sensitive.

　I. Single-choice questions(Each space corresponds to a sequence number, which has four options: A, B, C, and D. select the most appropriate option for the answer ).

1st the software programmer accepts the tasks of an enterprise and independently develops and designs an application. Which of the following is the copyright of the software __________.

[Correct answer]: B

[Reference]: software programmers accept enterprise tasks and independently develop and design an application software. The software copyright belongs to the Enterprise. Article 13th of the regulations on computer software protection clearly stipulates that, if the software developed by a citizen during his or her tenure is the result of executing his or her own work, that is, the copyright of the Software belongs to the enterprise if it is developed based on the Development Goals explicitly specified in the current job, or the result foreseeable for the activities of the current job or the natural result; if the software is mainly used for the development of materials and technical conditions such as the organization's funds, special equipment, and undisclosed special information, and is the responsibility of the legal person or other organizations, the copyright of the software is also owned by the Organization.

Question 3: artificial intelligence is introduced into network fault management __________.

[Correct answer]: d

[Reference]: the artificial intelligence technology provides effective methods and means for network management. The introduction of the network fault management technology can help network administrators quickly analyze the causes of faults and eliminate faults.

The Asynchronous Transfer Mode (ATM) of the Digital Network for Broadband Integrated Services is a new Information Transfer Mode Based on.

[Correct answer]: c

[Reference]: Asynchronous Transfer Mode (ATM) is a new Information Transfer Mode Based on Asynchronous time division multiplexing.

4th question: the ATM network uses a fixed-length source to transmit data. The cell length is __________.

[Correct answer]: B

[Reference]: asynchronous transmission mode ATM is a connection-oriented technology. It uses small, fixed-length data transmission units (cells, cells) with a length of 53B.

5th if you cannot access the Internet Service After configuring the network, Ping 127.0.0.1 is successful, and Ping gateway fails. Which of the following statements is incorrect __________.

[Correct answer]:

[Reference resolution]: if you cannot access the Internet Service After configuring the network, Ping 127.0.0.1 is successful and Ping gateway fails. It indicates that the TCP/IP protocol of the local machine is correctly installed, and the gateway is not correctly configured or enabled.

Recommended high-quality articles:

Preparing for the 2014 soft exam! Recommendation of high-quality video tutorials (Comprehensive review + experience sharing + pre-test Sprint)

Testing Questions of the soft exam over the years (Network Management + programmers + Information Technology + expert prediction questions)

Soft exam intermediate exam self-testing over the years and the latest video summary (network workers + software + database + expert prediction questions)

Knowledge points of Network Management in 2014 computer soft examination [summary]

For online soft test video tutorials, click:

Http://edu.51cto.com/course/courseList/id-44.html

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M02/3D/9F/wKioL1PE_n3z629yAACXIHScsJM092.jpg "alt =" wkiol1pe_n3z629yaacxihscsjm092.jpg "style =" padding: 0px; margin: 0px; Vertical-align: Top; Border: none; "/>

This article is from the "51cto college official blog" blog, please be sure to keep this source http://51edu.blog.51cto.com/8899635/1539347