Hebei Rural Credit Cooperatives Recruited Written Examination Questions in Previous Years

Computer Examination for Recruitment Examination of Rural Credit Cooperatives in Shandong Province in 2004 (written part)

Theoretical examination questions of computer specialty

This paper is divided into two parts: the first volume (multiple choice questions) and the second volume. The first volume, pages 1 to 6, the second volume, pages 7 to 12, ***240 points. Examination time 150 minutes. At the end of the exam, return this paper together with the answer sheet.

The first volume (multiple choice questions * *100)

Precautions:

1. Candidates must scribble their name, admission ticket number, test subjects and test paper (A or B) on the answer sheet before answering paper 1.

2. After choosing the answer for each question, black the answer label of the corresponding question on the answer sheet with a pencil. If you need to correct it, clean it with an eraser, and then choose other answers, you can't answer it on the test paper.

A, multiple-choice questions (this big question ***50 small questions, each small question 2 points, *** 100 points. Only one of the options given in each small question meets the requirements of the topic, and it will not be scored if you don't choose, choose more than one, or choose wrongly).

1. In FoxBase, the value of function substr ("abcdefg ",2,3) is ().

CDE 23 BC

2. In FoxBase, the command to display the current record is ().

A.？ B. List C. Display D. Clear

3. The command to delete all records in FoxBasek is ()

A.zap B. Clear all C. Count D. Clear

4. In FoxBase, which command will generate an extension after later execution? DBF file ()

A. Index B. Count C. List D. Total

5. In the following command to modify database records, the remarks indicate that it cannot be modified. ( )

A. Replace B. EDTT C. Change D. Browse

6. In FoxBasse, the command to open the database file GZGL. DBF is ().

A. create GZGL B. open GZGLC. Come on, GZGLD Use GZGL

7. In Foxbase, the library file is indexed by the total score (n, 3), name (c, 8) and command ... () should be used.

A. Total score index+name to abc

C. Index on C.STR (total score, 3)+ name to ABCD. Total score+value index (ABC name)

8. In BASIC, the following expression is correct ().

A. Sinks +XB. SQRT(X) C.X+3+SQR(R) D.ABS│X-Y

9. in BASIC, it is known that X=4, Y=9, A=2, B=‐3, and the logical expression is X >；; B and not (x+a > The value of Y+B) is ()

A. 1B。 ‐ 1C.0 D..T.

10. The following statement is true ()

a . 10A & gt； 5 Then print "A" B. 1 02A = B = B C.10Print1,3 D. 10IFA="A"THEN80.

1 1. In BASIC, 16=3+9 is ().

A.b. relational expression C. logical expression D. character expression of arithmetic expression

12. Which of the following characters is a character () in the BASIC character set of the Basic language?

A.& lt& gtB. @ C.￥ D.л

The control symbol of 13.8086/8088 has a ().

A. 1 B.2C.3 D.4

14. Among the following different decimals, the largest number is ().

a、 1 1000 10bb . 25 c、 1 1 1 1 1 1 1B d、2FDH

15. In a general microprocessor, it is included in the CPU. ( )

A. Arithmetic and logic operation chapter B. Memory C. Logic/output setting instead of D. Hard disk

The 16.Inc directive does not affect the logo. ( )

A.OFB, see ZF

17. Internet means () in Chinese.

A. mutual customs B. local area network C. metropolitan area network code D. web page

18. Among the domain names on the Internet, China's top-level domain name is ().

D.cn chemical weapons company

The abbreviation of 19 file transfer protocol is ()

A.FTP B.TCP/IP C

20.TCP/PF Xie Yi is hierarchical. ( )

a7 b . 4 c . 2d . 6

2 1. The correct format for writing the following email address is ().

B.yanrui92 @ 163.comC.@sohu.com analog-to-digital converter

22. The abbreviation of computer local area network is ().

A. local area network, wide area network and internet

23. The world's first electronic computer ENIAC was born in. ( )

a 1964 b 1936 c 1946d 1956

24. The memory in the computer includes ()

A.ram and ROM B.RAM and hard disk B. hard disk D.Windows98

25. Which of the following soft system software ()

A. Word processing software B. Miscellaneous spreadsheets D. Widower 98

26. Which of the following devices belongs to the output device ()

A. keyboard b scanner c printer d mouse

27. The key name of keyboard Shift is ()

A. control key B. tab key C. select key D. shift key

28. Which of the following software belongs to virus software ()?

A. Kill B.KV300C Scan D.WPS2000

29. In a single-user multitasking operating system is ().

A.dos B. widower 98c.unix D. widower NT

30. In WIN98, the shortcut key of the "cut" command is ().

A.CTRL+V B . CTRL+C C CTRL+X D . CTRL+W

3 1. The ASCII code value of English capital letter B is decimal 66, and the decimal value of ASCII code of lowercase letter B is … ().

66C. 102 D.67

32. In Word2000, if you want to show or hide the common toolbar menu ().

A. Tools B. View C. Insert D. Format

33. In the Word200 document, the shortcut key to move the cursor to the end of the document is ().

A.CTRL+ENDC。 ALT+HOME D

34.EXCEL file extension is ().

A. Total number of A.EXC

35. In Excel, the average function ()

A. Average B. Sum C. Sum D. Average

36. In Excel, if you want to classify and summarize some data according to a word, you need to press this field first ... ()

A. sort B. sum C. average D. maximum value

37. An Excel workbook can contain at most worksheets. ( )

256C.255 D.65535

38. In Excel, the operator that connects two strings is ().

A.$ b+c & amp； d-

39 A.5 B.6 C.7 D 1 1

40. There are a total of 10 records for multiple refueling, among which records No.2, No.4 and No.6 are marked as deleted. When executing the PACK command, the current record is ... ().

A. 1 B.2C.6 D.8

In the number extension library structure of 4 1. FxoBase system, the widths of logical addition type, date type and remark type are defined as () respectively.

A.2，8，4 B. 1，8，8C.2，8，8D . a . 1，8， 10

42. In Kun 98 Explorer, when selecting multiple discontinuous files with the mouse, you should hold down the key () at the same time.

A.SHIFT B.ALTC.CTRL D.TAB

43. In Windows98 Explorer, the shortcut key for selecting all contents in a folder is ().

A.CTRL+S B.ALT+S

C.CTRL+A D ALT+A

44. Which of the following expressions belongs to the numerical type of FOXBASE ()

A. 123 b . 10/05/64C。 " 12" D.time()

45. In Foxbase, the data type of function type () is ().

Not necessarily.

46. Information will be lost in the calculation of power failure. ( )

A.u disk b.ramc.rom d.hard disk

47. At present, the computer memory on the market is probably ().

a . 256 MB b . 1024 MBC . 0 1 10000 1B d . 00 100 100 100 b

The compressed BCD code of 48.26 is ()

a . 00 100 1 10B . 0 1 1000 10bc . 0 1 10000 1065438d . 00 100 b

49. The recycle bin in Windows is ().

A. An area in memory, floppy disk, hard disk and network.

50. When using the screen saver, the following statement is true ()

A.you can extend the life of the picture tube. You can extend the life of the hard disk. C. You can extend the life of the CD-ROM drive. You can't use the screen saver password.

Computer Examination for Recruitment Examination of Rural Credit Cooperatives in Shandong Province in 2004 (written part)

Computer professional theory test volume 2 (non-multiple choice questions *** 140)

Note: 1. There are six big questions in this paper, and the score is *** 140. 2. All the answers are answered directly on the test paper with a pen or ballpoint pen.

Second, the vacuum problem (this is a small question entitled *** 15, with 2 points in each grid and 30 points in * * *. Please fill in the correct answer on the horizontal line of the question, and don't score if you don't fill in, fill in less or fill in the wrong one)

1. In FoxBase's employee file, "marriage" is an L-shaped field and "gender" is a C-shaped field. If you search for married lesbians, the logical expression used is.

The result of 2.2. FoxPro expression len (span (3)+"ab") is.

The value of 3.3. FoxBase expression val (" 123ab45 ") is.

4. In the computer, the arithmetic unit and the controller exist in.

5.5 segment register. Intel 18086 microprocessors include DS, CS, ES and.

6. The logical address is 2000h: 1000h, and the physical address is.

7. To view other computers connected to this computer on the local network, double-click the icon on the desktop. 8.Widwindows 98 provides two basic operation modes, namely keyboard operation.

9. At present, the commonly used 3.5-inch floppy disk capacity is.

10. At present, the language that computers can directly recognize is language.

11.139.32.57.80 is a kind of IP address.

12. Network software includes network protocol software, communication software and.

BASICG expression of 13. Yes.

14. In Word2000, first select (yes or no) discontinuous areas.

15. In EXCEL2000, the rectangular area from A 1 to D4 is as follows.

Three. True or false (this big question is 10 sub-question, and each sub-question is 1 minute, * * *1minute. Please tick "√" in brackets before the correct sub-topic and "×" in the wrong sub-topic. Those who make mistakes or don't make judgments don't score)

() 1.FoxBase, A=B=2 The function of the command is to assign 2 to internal variables A and B..

() 2. In the Word table, you can insert the table again.

( )3. 1KB= 1000B

() 4. In the digital system commonly used by computers, there are only two binary numbers, 0 and 1.

() 5. The display device refers to the monitor.

() 6.Windows98 allows the longest file name to be 250 characters.

() 7. Files in the recycle bin can be recovered.

() 8.W indows98 The default mouse setting is that users are used to using their right hand, or they can use their left hand instead.

() 9. In the BASIC source program, the number of READ and DATAA statements is the same.

() 10. The basic statement 10 DIM A(32763, 32769) is correct.

Four, according to the meaning of the known environment and problems, write the corresponding FOBASE operation command (this big topic ***5 small questions, 4 points for each small question, ***20 points).

Set the database file RSDA. The database structure of DBF of known personnel files is: name (c, 8), gender (c, 2), date of birth (d, 8), professional title (c, 6), salary (n, 6, 2), bonus (n, 6, 2), party member (l, 65433). The database is already open in the current workspace. Write the corresponding commands as needed.

1. Displays records whose names contain the word "Yan". 2. Everyone's salary plus 60 yuan.

3. Count the number of records with salary greater than 1000 and store them in the memory variable AA. 4. Sort by professional title in ascending order and gender in descending order, and save the results in the storage file SZX.DBF.

5. Copy the names of all records in the library and the contents of bonus fields to the new library XK.DBF.

Verb (abbreviation of verb) Write the running results of the following program (this big topic has 3 small problems and 5 results, each with 6 points and * * * 30 points).

1. There is no datABase file ab. DBF, with the following records:

Record # XM XB ZF

1 Zhang Mingnan 86 1

2 Sun Yuenv 1542

3 Liu Huannan 280

4 groups of English women 1880

The process is as follows:

Use AB

DO WHILE .NOT.EOF()

If XB= "female". And ... ZF