Mathematical internal code table

1. About the description of bits, the error is _ _ _ _ d _ _ _.

Storing (memorizing) 1 bit requires the use of devices with two stable states.

The values of bit B are only "0" and "1".

C. Bits can represent numerical values, characters, images and sounds.

D. Bits have neither color nor weight, but they have size.

2. The following statement about information system is _ _ _ _ _ c _ _ _ _

Telephone is a two-way point-to-point system, the main purpose of which is information exchange.

B. the online chat room is a two-way system with the main purpose of information exchange.

C. Broadcasting is a point-to-point and two-way information interaction system.

D the internet is a global multifunctional information system.

3. The following statement about IC card is _ _ _ _ _ C _ _.

A.IC cards can be divided into memory cards and CPU cards according to the different integrated circuit chips embedded in the cards.

B. Nowadays, bus IC cards used in many cities belong to contactless IC cards.

C. only the CPU card has the ability of data encryption.

D. the SIM card used in the mobile phone is a special CPU card.

4. Add two 8-bit binary numbers 01001and 001011arithmetically and logically respectively, and the result is expressed as _ _ _ in octal form.

A. 120、 1 1 1 b . 157、 157 C. 170、 146 D. 170、 157

5. Memory capacity is one of the factors that affect PC performance. Generally, the larger the capacity, the better, but its capacity is restricted by many factors. The following factors, does not affect the memory capacity is _ _ _ _ _.

A.A.CPU Width of CPU data line B. Model of motherboard chipset

C. Type and number of memory slots on motherboard D. Width of D.CPU address line D.

6. The following memories are arranged from high to low in reading and writing speed, and the correct one is _ _ _ _ _ _ _.

A. Memory, cache, hard disk, CD-ROM

C. Memory, hard disk, cache, CD-ROM

7. Among the following factors, _ _ _ _ _ has the least influence on the microcomputer.

A. magnetic field b noise c temperature d humidity

8. The following statement about CPU is _ _ _ _ _ _ _.

A. the function of instruction counter in A.CPU is to count the number of instructions that have been executed.

The set of all instructions that the CPU can execute is called the instruction system of the CPU.

C. the central processing unit contains several registers.

D. The clock frequency determines the speed of data transmission and operation inside the CPU chip.

9. The following statement about USB interface is _ _ _ _ _ _ _.

A. the host can provide +5V power for peripherals through USB interface.

B.USB interface uses 6-wire connector.

A USB interface can connect up to 127 devices through a USB hub.

D.USB interface conforms to the plug-and-play specification, that is, devices can be plugged and unplugged without shutting down or restarting the computer.

10.I/O operation is one of the most common computer operations. The following statement about I/O operation is _ _ _ _ _ _.

A.I/O devices are various, and their performance varies greatly, and their connection modes with computer hosts are also different.

B. In order to improve the efficiency of the system, I/O operations and CPU data processing operations are usually carried out in parallel.

C.I/o the operation of I/O equipment is completed by the I/o controller.

The CPU in the D.D.PC sends a command to the I/O controller to start I/O operation by executing I/O instructions, and is responsible for controlling I/O equipment in the whole process.

1 1. It is _ _ _ _ _ _ that can directly exchange data with external memory.

A. controller b, operator c, keyboard d.ram.

12. The functions of this software do not include _ _ _ _ _ _ _.

A. Invisibility B. Vulnerability C. Wear D. Limited liability

13. The following software is _ _ _ _ _ _ _.

A.Adobe Acrobat B. BIOS C. Java compiler D. Oracle

14.I/O statement "printf ("Hello! " ); " It belongs to the _ _ _ _ _ _ _ component in high-level language.

A. transmission B. data C. operation D. control

15. Compared with the algorithm, the program may not meet the following _ _ _ _ _ _ _ features.

A every step of the operation is executable (feasible)

B. generating at least one output (including the change of parameter state)

C. Terminate after performing limited steps (limited)

D. Each step of operation must have an exact definition (certainty).

16. The famous computer scientist Nivos proposed _ _ _ _ _ _ _.

A. data structure+algorithm = program B. storage control structure

C. information entropy cybernetics

17.WAN is a computer network spanning a large geographical area. The following statement about Wan is _ _ _ _ _ _ _.

A. WAN is a public computer network, and all computers can access it unconditionally.

B. Like many LANs, WANs communicate by broadcasting.

C. WAN uses dedicated communication lines, and the data transmission rate is very high.

There is almost no limit to the number of computers that can be connected to the WAN, and computers at any distance can also be connected to each other.

18. The following statement about computer virus is _ _ _ _ _ _ _.

A. E-mail is one of the main ways for computer viruses to spread.

B. E-mail is a way of communication between individuals. Even the spread of computer viruses is individual and has little impact.

C under normal circumstances, as long as you don't open the email attachment, the system will not be infected with the virus it carries.

The ability of antivirus software to detect and remove computer viruses usually lags behind the emergence of viruses.

19. The following statement about TCP/IP protocol is _ _ _ _ _ _ _.

A. The IP protocol of the network interconnection layer unifies different physical frames at the bottom layer, making TCP/IP protocol suitable for various heterogeneous network interconnections.

B.TCP/IP protocol is widely used for wide area network interconnection, but not for local area network communication.

C. Operating systems such as C.UNIX and Windows have made communication software following TCP/IP protocol a part of their kernel.

D.TCP/IP protocol is a series of protocols, including more than 100 protocols, among which TCP and IP protocols are the most basic and important.

20. The following statement about e-mail system is _ _ _ _ _ _ _.

Email users need to install an email program to send and receive emails.

When a user sends a mail, the mail transmission program must establish a connection with the remote mail server and transmit the mail according to the SMTP protocol.

C. When a user receives an email, he/she sends a request to the email server according to the POP3 protocol, and after passing the authentication, he/she can access his/her mailbox.

D. The mail server is responsible for receiving the mail and storing it in the recipient's mailbox, as well as identifying the user's identity and performing access control, and does not implement SMTP and POP3 protocols.

2 1. The following statement about firewall is _ _ _ _ _ _ _.

A. the firewall can be implemented in hardware.

B. the firewall can be implemented in software.

C. Firewalls can prevent threats from outside the network.

D. Firewalls can prevent threats from inside the network.

22. When a router is used to connect heterogeneous networks, it has to perform many operations after receiving an IP data, and these operations do not include _ _ _ _ _ _ _ _.

A. address translation B. routing C. frame format translation D. IP datagram forwarding

23. The following statement about IP datagrams is _ _ _ _ _ _ _.

A.IP datagram is a data packet format independent of various physical networks.

B header information is mainly used to determine the route of data transmission in the network.

C The length of the data part can be changed, with a maximum of 56KB (including header information).

D.IP datagram consists of only two parts: header and data area.

24. If the contents of two adjacent bytes in the memory are all 74 5 1 in hexadecimal, it cannot be _ _ _ _ _ _ _.

A. 1 instruction component b. 1 Chinese character internal code

C. 1 16-bit integer D.2 English letter ASCII code.

Hypertext (hypermedia) consists of many nodes and hyperlinks. The following statement about nodes and hyperlinks is _ _ _ _ _.

A. It is hyperlinks that connect nodes to each other. The destination of a hyperlink can be a piece of sound or video.

C. nodes can be text or pictures. D the starting point of a hyperlink is just a sentence in the node.

26. If the uncompressed code rate of waveform sound is 64kb/s, the sampling frequency is 8kHz, and the quantization bit number is 8 bits, then its channel is _ _ _ _ _ _ _.

A. 1

27. The following statement about digital images is _ _ _ _ _ _ _.

A. The starting point of image compression is that the data in the image are highly correlated, and human vision has certain limitations.

The advantages and disadvantages of B compression coding method are mainly reflected in compression multiple, reconstructed image quality and complexity of compression algorithm.

The compression multiple of C C.JPEG images can be controlled, and most of them are lossless compression.

Images in D. GIF format can support transparent background and can be gradually displayed on the screen.

28. The following does not belong to the sound card function is _ _ _ _ _ _ _.

A. converting sound waves into electrical signals B. reconstruction of waveform sound

C.MIDI sound input d. MIDI sound synthesis

29. In the database, the correctness, rationality and compatibility (consistency) of data are called _ _ _ _ _ _ _ _ _ _.

A. Integrity B. Confidentiality C. * * * Enjoy D. Safety

30. There are two tables: students (student number, name and gender) and grades (student number, courses and grades). If you want to check the course scores of each boy, the operation that can be realized is _ _ _ _ _ _ _ _.

A. Select name, course, student achievement and student achievement set. Student number = grade. Student number and students. Gender =' Male'

B. Select name, course, student achievement and student achievement set. Student number = grade. Student ID or student ID? Gender =' Male'

C. choose name, course, student achievement and student achievement. Student number = grade. Student ID and student. Gender =' Male'

D. choose name, course, student achievement and student achievement. Student number = grade. Student ID or student ID? Gender =' Male'

3 1. If the patterns of relations R and S are the same, R has 6 tuples and S has 8 tuples, then in the following four cases, it is impossible to appear _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ respectively representing the number of tuples of relations R∪S and R ∪ S.

A.8、6 B. 10、 1 C. 1 1、3 D. 14、0

32. In Windows Explorer, after "cutting" a file, it is _ _ _ _ _ _ _.

A. delete B. temporarily store it in my document.

C. temporary storage in the clipboard.

33. In Windows, you can use the key combination _ _ _ _ _ _ _ to undo the last operation.

A.Alt+Q B.Alt+Z C.Ctrl+Q D.Ctrl+Z

34. In Windows, if you want to uninstall an application that has been installed and registered in the registry, the correct operation is _ _ _ _ _ _ _.

A. Find the corresponding program file in the resource manager and delete it directly.

B. Delete the corresponding items in the Start → Programs menu.

C. Delete by "Add/Remove Programs" in the control panel.

D, find the folder where the corresponding program is located and delete the folder.

35. The following statement about Windows file or folder search operation is _ _ _ _ _ _ _.

A. You can only search by name, modification date or file type.

B. The searched file or folder cannot be copied or deleted.

C. the search function can only be found in the start menu.

Files or folders created or modified before two specified dates can be searched.

36. The following statement about Windows shortcuts is _ _ _ _ _ _ _.

A. One object B can create multiple shortcuts, and one shortcut can point to multiple target objects.

C. Shortcuts can only be created for file objects. D. Shortcuts can only be placed on the desktop.

37. In Word 2003, you can use the "merge" function to merge multiple objects into a whole, so as to operate as one object. The following statement about combination function is _ _ _ _ _ _ _.

A. You can change the properties of all objects in a combination at the same time.

B you can flip, rotate, resize and scale the combined objects.

C. you can ungroup objects at any time.

D. After combination, you cannot select any object in the combination separately.

38. In Word 2003, the Format Brush on the Standard toolbar is a very useful typesetting function button. To copy the same format repeatedly, you should use the mouse _ _ _ _ _ _ _.

A. left-click the format brush button B. Left-click the format brush button.

C. right-click the format brush button D. right-click the format brush button.

39. In Word 2003, the content of the date field inserted in the document is _ _ _ _ _ _ _ _.

A. it varies with the actual system date. B.it's fixed.

C. change or not. D. Non-displayable domain codes are set by users according to their needs.

40. In Word 2003, click the Print button on the Standard toolbar, and then select _ _ _ _ _ _.

A. Print the selected content B. Print the current page

C. The print dialog box appears. D. Print all files.

Page 16:57:24

4 1. In Word 2003, the most efficient operation is _ _ _ _ _ _ to change all English words in the whole document to uppercase spelling, while other English words remain unchanged.

A. Execute the "Replace" command in the "Edit" menu and make corresponding settings in its dialog box.

B. Execute the font command in the format menu and make corresponding settings in its dialog box.

C. Execute the command "Change Font Case" in the Format menu and make corresponding settings in its dialog box.

D. Execute the Options command in the Tools menu and make corresponding settings in the Spelling and Grammar tab.

42. In Word 2003, A and B are two paragraphs with different formats. If some words are selected from paragraph A and copied and inserted into paragraph B, then _ _ _ _ _ _ _.

A. the text copied into paragraph b will become the same font as other texts in paragraph b.

B. the font of the text copied to paragraph b remains unchanged.

The format of paragraph C. B becomes the format of paragraph a.

The format of paragraph d.a has changed to the format of paragraph b.

43. In Word 2003, if only a few characters are selected for a scattered aligned text, and then click the "Align Right" button with the left mouse button, then _ _ _ _ _ _ _.

A. the whole document becomes right-aligned format B. The entire paragraph becomes right-aligned.

C. the whole line becomes right-aligned format D. Only the selected text becomes right-aligned.

44. In Excel 2003, you can view _ _ _ _ _ _ in the cell area of the status bar by selecting the corresponding cell area.

A. Note B. Citation C. Sum of values D. Line number

45. In Excel 2003, when sorting in ascending order, the rows with empty cells in the sorting column are _ _ _ _ _ _ _.

A. Not sorted B. Keep the original order

C, placed at the end d of the sorted data list, placed at the head of the sorted data list.

46. In Excel 2003, when creating a chart using worksheet data, the referenced data area is _ _ _ _ _ _ _ cell address area.

A. relative B. absolute C. mixed D. arbitrary

47. In Excel 2003, the operation priority order of each operator is _ _ _ _ _ _ _.

A. arithmetic operators, relational operators and logical operators

B. arithmetic operators, logical operators and relational operators

C. relational operators, arithmetic operators and logical operators

D. logical operators, arithmetic operators and relational operators

48. In Excel 2003, when the text entered by the user is larger than the width of the cell, _ _ _ _ _ _.

Even if the cell on the right is empty, only the first half of the text is displayed in this cell.

If the cell on the right is empty, it will be displayed across columns.

C if the cell on the right is not empty, "# # # #" will be displayed.

If the cell on the right is not empty, "Error!" Will be displayed.

49. In PowerPoint2003, when printing slides, a piece of A4 paper can print at most _ _ _ _ _ _ slides.

A. 1

50. In PowerPoint2003, to show from the current slide, you should execute _ _ _ _ _ _ _ _.

A. View the slide show in the menu B. View the show in the slide show menu.

C.Shift + F5 D.F5

Second, multiple-choice questions (this big question * * 10 small questions, each small question 1 point, * *1point. There are two or more correct answers in the following four options per question. Please choose the correct answer and fill in the letter number in the blank of the corresponding question number on the answer sheet. Wrong choice, less choice, more choice, this small question does not score. )

5 1. The following statement about optical fiber communication is true _ _ _ _ _ _.

A. Optical fiber will not be affected by high-voltage lines and lightning electromagnetic induction, and has strong radiation resistance.

B. optical fiber has great communication ability.

C optical fiber communication is a kind of communication mode without relay, because the optical fiber transmission loss is very small.

D. the optical fiber hardly leaks light and has strong confidentiality.

52. The interface between the hard disk and the host provides a channel between the hard disk and the host to realize high-speed data transmission. At present, the hard disk interfaces commonly used in PC are _ _ _ _ _ _ _.

A.com 1 B IDE C . RS-232D . SATA

53. On the premise of completing the same function, the program written in machine language is _ _ _ _ _ _ compared with the program written in high-level language.

A. the former is faster than the latter. B. The former is more portable than the latter.

C. The former occupies less storage space than the latter. The former is easier to write and debug than the latter.

54. The following statements about wireless LAN and wired LAN are _ _ _ _ _ _.

A. they use different transmission media.

B.they use different network cards.

C. They use different communication protocols.

D the former is more flexible than the latter in networking, network configuration and network maintenance.

55. The following statement about sound processing is _ _ _ _ _ _ _.

A. When digitizing sound, the higher the quantization accuracy, the better the fidelity of sound.

B. Digital sound is a continuous medium with a large amount of data and high requirements for storage and transmission.

The sampling frequency used in music digitization is usually higher than that used in sound digitization.

The extension is. . Medium and medium term. . Wav are all audio files in the computer.

56. The following statement about relational database is _ _ _ _ _ _ _.

Relational model is the most widely used data model in database management system at present.

B. Relationship model reflects the contents of two-dimensional table, while relationship reflects the static structure of two-dimensional table.

A relationship is a set of rows in a normalized two-dimensional table.

Common relational operations include union, intersection, difference, insertion, update, deletion, selection, projection and connection.

57. In Windows Explorer, the operations that can be performed are _ _ _ _ _ _ _.

1 Copy or move multiple files at once.

Open more than one file at a time.

3 Set multiple file attributes to read-only at a time.

4 Set multiple file attributes as system attributes at one time.

58. In Word 2003, a variety of saving methods are provided for users to choose from. The following statement about the saving mode is _ _ _ _ _ _ _.

"Background saving" means that you can continue to work while saving the document.

B "Auto-save" means that the system automatically saves files at intervals set by users.

C. "Keep backup" means that the previous version of the document can be restored after power failure or similar problems occur.

D "fast saving" means saving documents at a faster reading and writing speed.

59. If you want to enter the string "10/20" (excluding double quotation marks) in a cell in Excel 2003, you can do so by entering _ _ _ _ _ _ _ _.

A.' 10/20

B.=" 10/20"

C." 10/20"

D.= 10/20

60.PowerPoint 2003 provides _ _ _ _ _ _ _ and other master types.

A. slides

B. Overview

C. handouts

D. comments

3. Fill in the blanks (20 small questions in this big question, 65438+ 0 points for each small question, * * 20 points).

6 1. Modern information technology is based on _ _ _ _ _ _ _ _

Collection, transmission, processing, storage, display and control of line information.

62. With _ _ _ _ _ _ _ technology, transmission lines such as coaxial cable and optical can transmit thousands of signals from different sources at the same time.

63. The performance indicators of a printer mainly include printing _ _ _ _ _ _ _ _, printing speed, number of colors and printing cost.

64. The _ _ _ _ _ _ of memory refers to the time period (or the number of CPUs) from the time when the CPU gives the memory address to the time when the data is read from the memory and sent to the CPU.

According to the written memory).

65. In Windows XP, the file name of the page file used as virtual memory is _ _ _ _ _ _, which is located in the root directory of the system disk.

66. Nievos, a Swiss computer scientist, once said that computer science is the study of _ _ _ _ _.

67. In the Internet, in order to realize the communication between computers, it is usually necessary to assign an IP address to each computer and stipulate the TCP/IP protocol.

Yes, Class C addresses are used for small networks with no more than _ _ _ _ _ _ _.

68. The fourth version of the IP protocol (IPv4) has only about 3.6 billion addresses, which are estimated to have been allocated in recent years. Version 6 of the IP protocol (IPv4) has been launched.

The length of the IP address is extended to _ _ _ _ _ _ _.

69. The video acquisition card in the input analog video signal (and its sound signal) digital at the same time, the video image from _ _ _ _ _ _.

RGB color space conversion, and then superimposed with the image generated by computer graphics display card, users can watch on the display screen.

70. In the database, _ _ _ _ _ _ is just a virtual table, and its logical definition is saved in the data dictionary, not actually stored as a table.

Data.

7 1. In Windows, double-click a text document, and the system starts the _ _ _ _ _ _ _ application by default.

72. In Windows, the maximum length of a file name can reach _ _ _ _ _ _ _ characters.

73. In Word 2003, if users need to perform a certain task repeatedly, they can use _ _ _ _ _ _ to record this series of operations to.

This task will be performed automatically in the future.

74. In Word 2003, under normal circumstances, each line in a paragraph will automatically wrap according to the page width. If you need something in a paragraph.

If you force a line break at this position, but do not split the paragraph, you can insert _ _ _ _ _ _ _ _.

75. In Word 2003, if you want to see the contents on different pages of a long document at the same time, you should do it in the window menu.

_ _ _ _ _ _ command.

In Excel 2003 worksheet, there is a formula "=A 1+$B2+$C$3" in cell D4. After inserting a column before the second column, the cell

The formula of E4 is "_ _ _ _ _".

77. In the Excel 2003 worksheet, it is assumed that the values in cell A 1:C2 are all 1. If the formula "=SUM(A 1:A2) is input into cell F3,

B 1:C2) ",the display result of this cell is _ _ _ _ _ _.

In Excel 2003, if the data of a cell is the date value "20 10 April 24th", select the cell and click Delete.

"Key, and then enter the value" 1 "in this cell, and the contents of this cell will become _ _ _ _ _ _ _.

79. In PowerPoint 2003, except the first slide with a title, the default layout of any new slide inserted in the presentation is

__________。

80. In PowerPoint 2003, if you need the presentation to run automatically, you can set it in the Set Show Mode dialog box.

_ _ _ _ _ _ _ _ projection type, which can not only circulate the projection, but also prevent users from changing the projection mode.

4. True or false (this big question is ***20 small questions, each small question is 1 point, ***20 points. Mark "√" for the correct statement and "×" for the wrong statement of the following sub-questions.

. )

8 1. Computer internal data can be operated in binary, octal or hexadecimal.

82. The carrier signal is a sine wave with a much higher frequency than the transmitted signal.

83. Generally speaking, the larger the cache capacity and the more stages, the higher the execution efficiency of CPU.

84. The disk is an important external device in the computer. Without it, the computer can't run.

85. The information in the memory can be instructions or data.

86. Using USB flash drive in Windows does not need to install the corresponding driver, and other peripherals can work normally without installing the driver.

Work.

87. The page scheduling algorithm used in virtual memory is the first-in first-out (FIFO) algorithm.

88. Domain name resolution is the conversion process from domain name to IP address or from IP address to domain name.

89. A host's IP address can correspond to multiple domain names, but a domain name can only correspond to one IP address. When the host leaves the physical network

When moving to another physical network, its IP address must be changed, but the original domain name can be kept.

90. Remote file transfer (FTP) means that an authorized computer (FTP client) in the Internet can access another computer in the network (FTP service).

) file in the disk for various operations. For example: file downloading, file uploading, deleting or renaming files in FTP server, etc.

The highest resolution of a digital camera with 91.5 million pixels can reach 28 16*2 1 12.

92. In the ASCII code table, numbers and English letters are arranged in descending order of ASCII code values: numbers, uppercase letters and lowercase letters.

Mom.

93. Generally speaking, there is no redundancy in the data in the database, which is a major feature of the database.

94. In Windows, you can use Ctrl+Shift to switch between various Chinese input methods.

95. In Windows, all deleted files and folders are temporarily stored in the recycle bin, so files can be deleted from the recycle bin.

Recover.

In Word 2003, you can use the "Find and Replace" function to find all forms of an English word at once.

97.Word 2003 is a word processing software and cannot be used to make web pages.

98. In Excel 2003, if the filtering conditions involve the OR relationship of multiple fields, automatic filtering cannot be realized, and only advanced filtering can be used.

choose

99. In Excel 2003, if there are many columns in the worksheet, you often need to use the "freeze" function, just select the column to freeze.

, and then choose the Freeze Pane command on the Window menu.

100. In PowerPoint 2003, all slides of the same presentation can only use the same application design template.

I. Multiple choice questions

1- 10:DCCDA BBABD

1 1-20:DCAAC ADBBD

2 1-30:DACBD ACAAC

3 1-40:BCDCD ADBAD

4 1-50:ABBCC BABDC

Second, multiple choice questions

5 1-55:ABD BD BD ABCD ABCD