Current location - Quotes Website - Signature design - Computer professional knowledge in civil service examination
Computer professional knowledge in civil service examination
1. Multiple choice questions: (* * 60 points, 1-30 questions, 1 points, 3 1-45 questions, 2 points)

1. In a microcomputer, transferring data to a floppy disk is called

A. write disk b, read disk c, and enter d or above.

2. The logic device used by the fourth generation computer is

A. relay b electron tube

C. Small and medium-sized integrated circuits D. Large-scale and ultra-large-scale integrated circuits

3. Which of the following statements is correct?

A. The bigger the computer, the more powerful it is.

B In the microscopic performance index, the higher the main frequency of CPU, the faster its running speed.

C if two monitors have the same screen size, their resolutions must also be the same.

The more pins a dot matrix printer has, the more Chinese fonts it can print.

4. Microcomputer can be divided into 8-bit computer, 16-bit computer, 32-bit computer and 64-bit computer according to word length. The so-called 32-bit computer refers to the CPU used by the computer.

A.it can handle 32-bit binary at the same time. It has a 32-bit register.

C. Stored program and automatic control D. There are 32 registers

5. The main working characteristics of electronic digital computer are

A. high speed B. high precision C. stored program and automatic control D. strong memory

6. In the performance index of microcomputer, the memory capacity available to users usually refers to

A.ROM capacity B RAM capacity c ROM and RAM capacity d optical disk capacity

7. Which of the following devices can only be used as output devices?

a mouse

8. In a microcomputer, the smallest unit used to represent information is

A bit b byte c word d double word

9. The correct attitude towards computer software is

A. computer software does not need maintenance.

B. You don't need to buy computer software as long as it can be copied.

Computer software protected by law cannot be copied casually.

D. computer software does not need to be backed up.

10. Luo Kai refers to

A. memory specification B. random access memory C. read-only memory D. memory memory

1 1. When did Microsoft launch WINDOWS95?

a 1983 B 1987 C 1992D 1995

12.WINDOWS95 is a multitasking operating system, which means

A window can be used by multiple users at the same time.

WINDOWS can run a variety of applications.

WINDOWS can run multiple applications at the same time.

WINDOWS can manage multiple resources at the same time.

13. On the WINDOWS95 desktop, you can't open the browser.

A. Right-click the My Computer icon and select Explorer from the pop-up menu.

B click the start button with the right mouse button, and then select explorer from the pop-up menu.

Click the Start button with the left mouse button first, and then select Explorer from the system menu.

D first click the "My Computer" icon with the left mouse button, and then select the "Explorer" icon from the window.

14 on the desktop. Windows 95, the operation without opening "My Computer" is

A. select "my computer" in the browser.

B. Double-click the "My Computer" icon with the left mouse button.

C Click the "My Computer" icon with the right mouse button first, and then select "Open" in the shortcut menu that pops up.

D Click the "Start" button with the left mouse button first, and then select "My Computer" in the system menu.

On 15. "Taskbar" Storage of Windows 95

A. All programs running in the system B. All programs saved in the system

C. Programs running in the foreground of the system

16.Word has the function of grading. The following statement about grading is correct.

A. there can be up to 4 columns. B. the width of each column must be the same.

C. the width of each column can be different. The spacing between columns D is fixed.

17. In the following operations, WORD97 cannot be closed.

A. double-click the "w" on the left side of the title bar. B. Click Close on the File menu.

C. Click "╳" on the right side of the title bar. Click Exit on the File menu.

18. The header and footer can be displayed in the following ways.

A. Normal view B. Page view

C, outline view d, full screen view

19. In the following menu, the commands containing font settings are

A. editing b, format c, tool d and view

20. To copy part of the text content in a document to another place, the first operation is

A. paste b, copy c, select d, and cut.

2 1. To set some text content in bold, first,

A. click the "b" button, and then click the "u" button.

C. select d and click the "a" button.

22. Open the WORD document generally refers to

A. read the document content from memory and display it.

B. Open a new empty document window for the specified file.

C. Load the contents of the file from the disk into the memory and display it.

D. display and print out the contents of the specified file.

23. The file name displayed at the bottom of the file drop-down menu is

A. the file name being used b, the file name being printed.

C, file name d with extension. File names that DOC and WORD have recently processed.

24. After deleting a paragraph marker, the two paragraphs before and after will be merged into one paragraph. The format of the original paragraph content is

A. Format of mark decision before deletion B. Format of paragraph after original text

C, the format has not changed. D, regardless of the format of the next paragraph.

25. The current insertion point is located in the last cell of a row in the table, and then click.

A. The row where the insertion point is located is widened by b, and the column where the insertion point is located is widened.

C, adding a line D next to the insertion point has no effect on the table.

26. In FOXPRO environment, use menu design window to create menu. If a designed menu item is selected to generate a submenu, the result column should be selected.

A. insert B. delete C. or D. add ...

27. For an open database file, to establish a combined query of or conditions in the RQBE window, an or line must be added between the conditions. The button that generates the or line is

A. insert b, delete c or add d

28. What software is FoxPro?

A.CAD B CAI C DB D CASE

29. The main menu of FoxPro 2.5 system is as follows.

The system file editing database record window runs.

The function of item 2 is

A. library operation b recording operation c program management d file management

30. In FoxPro 2.5, the function keys of F 10 are used to

A. activate menu B. Select the object.

C. choose help D. Select the next control item.

3 1.FoxPro 2.5 < CTRL >; The function of +Enter key is

A. activate menu B. Select the default project.

C. choose help D. Select the next control item.

32. The functions of FoxPro 2.5< ESC> bonds are

A. activate menu B. Select the object.

C. Select Cancel D. Select the next control item.

33.FOXPRO2.5 F 1 function keys are used to

A. activate menu B. Select the object.

C. choose help D. Select the next control item.

34. In FoxPro, the < TAB> function key is used to

A. activate the menu B. select the object C. select help D. select the next control item.

35..FOXPRO

A. activate the menu B. select the object C. select help D. select the next control item.

36. Du Can, a computer disease, caused the machine to malfunction.

A) computer equipment b) computer chip

C) computer component d) computer program

37. If the floppy disk seals the write-protected port, then

B) Non-infectious and infectious.

38. The methods to prevent computer infectious diseases are

A) Don't use CD with du; B) Don't let people with infectious diseases operate it.

C) Improve the stability of computer power supply d) Run online.

39. The dangers of computers are as follows

A) It will lead to permanent failure of computer equipment; B) It can affect the execution of programs and destroy user data and programs.

C) It will not affect the running speed of the computer; D) It will affect the calculation results of the computer, and no measures are needed.

40. The following statement about computer diseases is correct.

A) du is a MIS program.

B) Computer sickness is an infectious disease harmful to human body.

C) Computer disease du is a kind of calculation, which can be infected by self-replication and play a destructive role.

D) computer disease du is a program, but it is harmless to computers.

4 1. Computer diseases

A) It will not affect the running speed of the computer; B) It will lead to the permanent failure of computer equipment.

C) It does not affect the calculation results of the computer; D) Affect the execution of programs and destroy user data and programs.

42. Computer diseases For people who operate computers.

A) only infection, no disease; B) infection and disease.

C) it won't be infected d) it will be unlucky.

43. A computer virus is a set of computer programs with the following functions.

Infectious, hidden and harmful

44. The main hazards caused by computer diseases are

A) word processing and database management software b) operating system and database management system

C) programs and data d) system software and application software

45. The following measures cannot prevent computer diseases.

A) The floppy disk is not write-protected.

B) Select du software to check whether files copied from other people's machines have du.

C) Don't use disks of unknown origin.

D) Pay attention to the version upgrade of du software used for disease prevention at any time, and try to obtain the highest version of antivirus software.

II. Fill in the blanks: (***40 points)

1. Microcomputer bus generally consists of data bus, address bus and () bus.

2. At present, the most commonly used input devices for microcomputers are () and ().

3. 1MB storage space can store () Chinese characters.

4. Microcomputer can be configured with different display systems. In CGA, EGA and VGA standards, the best display performance is ().

5. To install or remove applications, you must open the () window, and then use the Add or Remove Programs function.

6. To install or uninstall Chinese input method, you should start the control panel before using the () function.

7. To start FoxPro, please click () in the program menu of WINDOWS.

8. In FoxPro system, the command used to count the number of records in the database is ().

9. The most commonly used LAN is _ _ _ _ _ _ _ _ _ _ _.

10. The information superhighway mainly uses _ _ _ _ _ _ _ _ _ as the communication medium.

Question 4: Answers and grading criteria

1. Multiple choice questions: (* * 60 points, 1-30 questions, 1 points, 3 1-45 questions, 2 points)

1、A 2、D 3、B 4、A 5、C 6、C 7、C 8、A 9、C 10、C

1 1、D 12、B 13、D 14、D 15、A 16、C 17、B 18、B 19、B 20、B

2 1、C 22、C 23、D 24、C 25、C 26、D 27、D 28、C 29、D 30、A

3 1、D 32、C 33、C 34、D 35、B 36、D 37、D 38、A 39、B 40、C

4 1、D 42、C 43、D 44、C 45、A

Two. Fill in the blanks: (***40 points, 4 points for each question)

1, control 2, keyboard, mouse 3,5124, VGA 5, control panel 6, input method.

7.FOXPRO FOR WINDOWS 8, COUNT 9, Ethernet 10, telephone line.

note:

1. This volume is divided into objective questions and subjective questions, with a total score of 100 and an examination time of 2 hours;

2. When answering objective questions, you must first scribble your name, admission ticket number and test paper code (2) in the corresponding position on the answer sheet. The answer must be filled in the answer sheet with 2B pencil, and the answer on the test paper is invalid;

3. When answering subjective questions, first write your name and admission ticket number in the designated position of the test paper, and then answer directly on the test paper with a blue (black) pen or ballpoint pen.

Objective questions (questions 1, 2 and 3)

1. Multiple choice questions (Only one of the alternative answers to the following questions is the best answer, please choose.

And black the letters behind the corresponding question number on the answer sheet. 65438+ 0 points for each small question, ***40 points)

1. The waterfall model of software life cycle typically describes the stage division of software life cycle, which breeds software.

Life cycle is divided into eight stages, which are summarized into three periods. The following is the normal development order.

A. Development period, operation period and planning period B. Planning period, development period and operation period

C. Development period, planning period and operation period D. Planning period, operation period and development period

2. The information stored in the memory can be data or instructions, depending on:

A, most significant bit is 0 or1; B, the address of the storage unit.

C.CPU executes program judgment d. ascii code table judgment.

3. The clipboard in 3.Windows XP is:

A. an area on the hard disk. An area in a floppy disk.

C. an area in the cache.

4. In Excel 2000, set column E to store total wages, column F to store tax adjustment, and column G to store paid wages. Among them, when the total salary is 850, the tax adjustment = (total salary -850)* tax rate; When the total salary is less than 850, individual tax adjustment = (salary -850)* tax rate; When the total salary is less than = 850, the tax payment is adjusted to 0. Set tax rate > 0.05. Then according to the formula, the F column can be realized. Where the formula of F2 should be:

A.=IF("E2>850 ",(E2-850)*0.05,0)

B.=IF(E2>850,0,(E2-850)*0.05)

C.=IF(E2>850,(E2-850)*0.5,0)

D.=IF("E2>850 ",0,(E2-850)*0.05)

5. In Windows XP, pressing three keys at the same time can open the Close Program dialog box and close those unnecessary or unresponsive applications.

A.Ctrl + Shift + Del B. Alt + Shift + Del

C.Alt + Shift + Enter D

6. In various views of PowerPoint 2000, slides can be moved, deleted, added, copied and animated, but the specific contents of slides cannot be edited.

A. Slide view B. Slide browse view

C. Slide show view D. Outline view

7.DBA is an important part of database system and has many responsibilities. The DBA is not responsible for the following options:

A. define the storage structure and access policy of the database.

B. Define the structure of the database

C. Reorganize and rebuild the database regularly.

D, designing and writing the program module of the application system.

8. The following statements about the database data model are wrong:

A. any two-dimensional table represents a relationship.

B. the structure of the hierarchical model is a directed tree.

C. the hierarchical model is a special case of the grid model.

D in the object-oriented model, each object has a unique identifier.

9. Information table of known students' course selection: sc(sno, cno, grade). The SQL statement for querying "student number and course number of students who have attended at least one course but have no academic achievements" is:

A. select sno, cno from sc with empty grade.

B. Select sno, cno from sc with grade "".

C. select sno, cno from sc with empty grade.

D.SELECT sno,cno FROM sc WHERE grade= ' '

10. One of the advantages of the top-down development method is:

A. Short development cycle B. Low development cost

C. low requirements for system analysts. D. can support the integration of information systems.

1 1. Standardized documents should be generated at all stages of the software structured development process. The following documents should be made in the design stage.

A. Feasibility analysis report B. Statement of software requirements

C. Software design specification D. Software test report

12. The operating system supporting SQL Server is:

A.UNIX B. Windows NT C. DOS D. Linux

13. For websites with a large amount of data, the database that should be selected is:

A.DB2 B. DBASE C. MySQL D. ACCESS

14. The data transmitted by EDI network is:

A. free file B. flat file C. customer format D. EDI standard message

The computer network includes:

A. transmission media and communication equipment B. communication subnet and resource subnet

C. User computers and terminals D. Host computer and communication processor

16. Which of the following types of attack programs is the global flood network (TFN) in network attack activities?

A. denial of service B. dictionary attack C. network monitoring D. pathological du program

17. In online commodity intermediary transactions, the two institutions that have no direct business contact are:

A. Trading centers and banks B. Certification centers and distribution departments

C. Suppliers and demanders D. Trading centers and certification centers

18. In C language, which of the following statements defining data is incorrect?

A.int S_ 1〔5〕,S _ 2〔4〕3〔b . float x,a〔4〕5〕;

C.char string〔33k〕; D. int x= 10,y;

19. Read the following c program segment:

Master ()

{ int x;

Missing ("%d", & ampx);

if(x -