Basic knowledge and FOXBASE programming

(Examination time 120 minutes, full mark 100)

A, multiple-choice questions (1)-(40) each option 1, (4 1)-(50), ***60) each option 2.

Only one of the following questions (a), (b), (c) and (d) is correct.

(1) Generally speaking, the host mainly includes

A)CPU B)CPU and memory

C)CPU, memory and external memory D)CPU, memory and hard disk.

(2) In the microcomputer system, the BIOS of the basic input/output module is stored in

A) in A)RAM b) in B)ROM c) on the hard disk d) in the register.

(3) The number of bytes of Chinese font information in the 24× 24 lattice is

A)2 B)24 C)32 D)72

(4) bit representation

A) word b) word length c) byte d) binary bit

(5) the school's salary management procedures belong to

A) system program b) application program

C) tool software d) word processing software

(6) The decimal number equivalent to the hexadecimal number BB is

a) 187 B) 188 C) 185D) 186

(7) The measures to set the floppy disk infected with virus are as follows

A) Delete all files on the floppy disk b) Format the floppy disk.

C) Delete all executable files on the floppy disk c) Delete all batch files on the floppy disk.

(8) The capacity of a 3.5-inch double-sided high-density floppy disk is

a)360 kb B)720 kb C) 1.44 MB D) 1.2 MB

(9) Hexadecimal decimal is equivalent to binary decimal 0. 1 Yes

A)0. 1 B)0.2 C)0.4 D)0.8

(10) The difference between a warm start and a cold start of a DOS system lies in the warm start.

A) The keyboard, interface and memory are not detected; B) The user is not prompted to enter the date and time.

C) You do not need to load this command. COM file d) cannot be started from floppy disk.

(1 1) In order to connect the files K 1, K2 and K3 on the disk to the back of the file K4, you should use the command.

A) copy K 1+K2+K3 K4 B) copy K 1+K2+K3+K4.

C) copy K 1+K2+K3+K4 K4 D) copy K4+K 1+K2+K3.

(12) The following file names can be used as batch file names.

A)AUTOEXEC。 C B)AUTOEXEC

ATX。 Bat d) automatic. Textfile (textfile)

(13) To print out a list of all files and subdirectories under the current disk root directory, you should use the command.

A) directory \ >PRN B) type \ & gtPRN

C) directory > PRN C)TYPE & gt；; PRN

(14) The data required by ABC.EXE, the executable file, which should have been entered by the keyboard, has been stored in the file according to the format.

XYZ, and requires that the execution result be placed behind the input data in XYZ file. The following command is correct.

Indeed

A) ABC <。 XYZ & gt； XYZ B)ABC & gt； XYZ

C) ABC <。 & ltXYZ & gt； XYZ

(15) Let a directory path in the current disk be \A\B\C, and the current directory be \A. What is definitely wrong in the following command is

A)MD \A\C B) CD..D) MD \A\B

(16) Set the directory structure of disk A as follows:

root directory

│

┌—————┬┴——┬———┬———┬————┐

│ │ │ │ │ │

ABC D 1 subdirectory DX. D2 subdirectory A.FOR

│ │

┌————┬—┴——┬———┐ ┌———┬———┐

│ │ │ │ │ │ │

B. pass D3 subdirectory Y.BAS A.C A 1. D4 subdirectory XYZ. C

│

┌————┬————┬————┐

│ │ │ │

QR。 C NA。 business English

If the current disk is disk C and the current directory of disk A is \D2, the specification of file QR is as follows. The location of c on disk a.

Legally,

A)\D2\D4\QR。 D4。 C

A: D4. D2\D4\QR。 C

(17) There is an error in the following DOS command.

A) sign a)AAB. FOR & gtCON B) type? AB。 for

C) copy *. Copy PRN

(18) Set the current disk to disk A to connect the file AB 1. TXT to the root directory of drive C.

At the back of the file is XYZ. TXT, the correct command is

A) copy C:\XYZ. TXT+AB 1。 Textfile (textfile)

B) copy AB 1. TXT>& gt c: XYZ. Textfile (textfile)

C)ab 1 TXT> c: XYZ. Textfile (textfile)

D)AB 1。 TXT+C:\XYZ。 TXT> c: XYZ. Textfile (textfile)

(19) The following command is legal.

A) disk copy A: A: B) disk copy A: C:

C)DISKCOPY C: A: D)DISKCOPY C: D:

(20) Let a directory path in the current disk be \A\B\C\D\XU, and the current directory be \A. Extended root directory.

Copy all files with. C to the current directory and change the extension to. Because. You should use the command.

A) copy \ *. C *。 For b) copy *. C \A\*。 for

C) copy *. For \ *. C D) copy \A\*C *. for

(21) The data model of Foxbase database management system is

A) structural type b) relational type

C) network type d) hierarchical type

(22) The basic form of storing and managing data in a relational database management system is

A) relational tree b) two-dimensional table

C) node path d) text file

(23) In relational operations, the operation of finding tuples that meet certain conditions is called

A) copy b) select

C) projection d) connection

There are four memo fields in the FoxBASE database file. The number of memo files in the database is

A) 1 B) 4

C) 7 D) 10

(25) In FoxBASE, if an expression includes numerical operation, relational operation, logical operation and function,

The priority of the operation is

A) numerical operation, relational operation, logical operation and function

B) numerical operation, logical operation, relational operation and function

C) Functions, numerical operations, relational operations and logical operations

D) Function, numerical operation, relational operation and numerical operation

(26) A database file has 10 records, and the serial number of the current record is 6. Execute the command SKIP 10 first, and then

Execute orders? EOF (). The result displayed after executing the last command is

A) error message B) 1 1

t . D . f。

(27) define the array q with the dimension q (2,3) command, and then assign a value to each array element: Q( 1, 1)= 1,

Q ( 1，2) = 2，Q ( 1，3) = 3，Q (2 1)= 4，Q (2，2) = 5，Q(2，3) = 6。 And execute the order? So, Q(2)

The display result is

A) Prompt for undefined variables B) 4

c)2d)f。

(28) In a relationship, an attribute or combination of attributes that can uniquely determine a tuple is called.

A) index code b) keyword

C) field d) classification code

(29) Assume that n, c and l are numbers, characters and logical storage variables respectively. Error in the following expression.

The wrong expression is

A)3 * N B)C-“A”

C)N= 10。 Or. L D)C>；; 10

(30) After using the DIMENSION command to define the array, the data type of each array element before assignment is

A) character type b) number type

C) logical type d) undefined

(3 1) Without opening the index file, the additional command is functionally equivalent to the command group.

A) Skip the bottom b) Go to the bottom

Insert before inserting the bottom

C) go to EOF D) go to the bottom.

Insert plug-in

(32) The width of the numeric field is defined as 6 and the number of decimal places is 2. What is the minimum value that can be stored in this field?

A)0℃) -999.9℃) -99.99℃) -9999.99℃

(33) Perform the following procedures:

ST="FOXBASE "

? UPPER(SIBSTR(ST， 1， 1))+LOWER(SUBSTR(ST，2))

The display result of the screen is

Hu base Hu base Hu base Hu base

(34) Suppose students. The DBF database file * * * has 8 records. When the value of the e of () function is logically true, it will be executed.

Command? The output of RECNO () is

1 B)7 C)8 D)9

(35) Assume that the date field is a date type and the date format is day/month/year. Each of the following four groups of commands

A) list of a)SUBSTR(DTOC, 4,2) = "97"

Year list = 1997

List the FOB price of "97" $ DTOC (date of birth)

List of SUBSTR (DTOC (date of birth), 7,2) = "97"

Year list = 1997

The list is "97" $ dtoc (date of birth)

List of SUBSTR (DTOC (date of birth), 1, 2) = "97 "

Year list = "1997"

The list is "97" $ dtoc (date of birth)

D) list of d)SUBSTR(DTOC, 7,2) = "97"

Year list = 1997

List the year of birth of "97"

(36) After opening a database containing multiple records, to add an empty record after the first record, you should use

order

A) Attach blank b) Insert blank

C) insert d) insert before blank.

(37) In the following expression, the result is a character type.

a)" 125 "-" 100 " B)" ABC "+" XYZ " = " ABC XYZ "

c)CTOD(" 07/0 1/97 ")； D)DTOC (date ()) & gt"07/0 1/97 "

(38) The database has been opened, in which the date field is of date type and the age field is of numerical type. Calculate every today.

The age of the year and fill in its value in the age field, you should use the command.

A) replace all ages with year (date ())-year (date of birth)

B) Replace all ages with date ()-date of birth.

C) replace all ages with dtoc (date ())-dtoc (date of birth)

D) all ages are replaced by val (subs (dtoc (date ()), 7,2)-subs (dtoc (year of birth)).

Month), July, 2))

(39) In FoxBASE, when COPYing the database file with the copy command and the COPY FILE command respectively, the database file is used.

What is wrong in the following statement is

A) When using the COPY command, you must first open the database.

B) When using the copy file command, the database must be closed.

Copyfile command can copy annotation files at the same time.

D) The copy command can copy the annotation file at the same time.

(40) In the book database file, the book number field is of character type, and all books whose book numbers begin with the letter D are required.

Mark the record for deletion and use the command.

A) delete "d" $ book number

B) Delete SUBSTR (ISBN, 1, 1) = "d "

C) delete ISBN = =D *

D) Delete (ISBN, 1) = "d "to the right.

(4 1) There is a Name field in the opened database file, which defines a memory variable Name.

To transfer the value of the memory variable name to the name field of the current record, use the command.

A) name = m-> (full name)

B) name of RAPLACE with m- > (full name)

C) store m-> Name versus name

D) from m->; Name, field, name

(42) At the dot prompt, copy STD. Copy the PRG file in the root directory of disk A to the \DB directory of disk C,

You should use the command.

A) copy A:\STD. PRG C:\DB

B) copy the file A:\STD. PRG to C:\DB\STD. PRG

C) copy A:\STD. PRG to C:\DB\STD. PRG

D) copy to C:\DB\STD. PRG

(43) Suppose there are 100 records among the students. DBF database, and execute the following command sequence:

Use students

Go to 10

Show all

? Record number ()

After the last command is executed, the value displayed on the screen is

a) 1 B) 10 C) 100D) 10 1

(44) There are the following program segments:

@ 5 10 said, "Please enter 1-4".

read

CX="PG"+ANS+"。 PRG "

DO & ampCX

Its function is to execute one of subroutines PG 1, PG2, PG3 and PG4 according to the number input by the user. But this process

There are obvious errors in the preface, which should be revised as follows.

A) Add store ""as the first command to ANS.

B) Change @ 5, 10 saying "Please enter 1-4" to an ans command to accept "Please enter 1-4" as an ans.

C) Delete "+". The PRG part comes from CX="PG"+ANS+ ". PRG "command.

d)put do &； & CX command; get rid of

(45) There are the following program segments:

Stop the conversation

clear

@ 2,20 says "Please choose a menu item"

@ 4 15 prompts "1- modify"

@ 5 15 prompts "2- query"

@ 6 15 prompts "Three Reports"

@ 7 15 prompts "0- exit"

ANS menu

? anji and kerr

After executing this program segment, if the "0- Exit" item is selected by moving the optical tape, the value of the storage variable ANS should be

A)4 B)"0" C)0 D)"4 "

(46) The existing database files of Project Hope donations are as follows:

Record # Name Donation Amount Donation Date

1 Ouyang Hui 300.00 07/ 12/89

Li Ming1February 24, 990

3 Yang Xia 80.0011/05/91

4 Li Ming 170.00 02/24/92

5 Yang Xia 400.00 1 1/05/92.

6 Ouyang Hui 200.00 07/ 12/93

7 Li Ming137.00002/24/94

8 Yang Xia 215.0011/05/95.

Ouyang Hui 3 13.00 07/ 12/96

The donation amount field is a number. Assuming that the library file and index file established by name have been opened, it is

To count the total donations of donors, you should use the command.

A) pay the donation amount to JK.

B) include the donation amount in JK.

C) average donation to JK

D) the total amount donated to JK FIELDS by individuals.

(47) The database file has been opened, in which the date of birth field is a date type, and the result in the following expression is not a date.

Type is

a)CTOD(" 09/ 18/97 ")； B) Date of birth +5.

C)DTOC (date of birth) d) date () -2

(48) execute the following command sequence

SELEC 1

Use students

catalogue

Record # Student ID Surname Gender Major

1 980 1 Ouyang Hui female computer

2 9802 Li Mingnan Applied Mathematics

3 9803 Yang Xia Female Electronic Engineering

4 9804 Guo Haonan Computer

5 9805 He Nan Electronic Engineering

Option 2

Use SC alias w

catalogue

Record # Student Number Course Number

1 980 1 C 1

2 980 1 C2

C2 39802

No.9803 C2 Road

5 9803 C2 Street

6 9804 C 1

No.79804 C4 Road

Select 1

For student number = b- > student number, connect to LK with w. And. b- > course number = "="C 1 "fields.

Student ID, name and major.

Use LK

List name

The names displayed in the last LIST command are

A) Ouyang Hui, Li Ming B) Ouyang Hui, Guo Hao

C) Ouyang Hui, Guo Hao, He D) Li Ming, Yang Xia, Guo Hao

(49) execute the following command sequence

Use students

catalogue

Record # Last name, gender, admission score

1 Wang Zhongyi male 470.0

2 Li Huinv 424.0

3 Cheng Kainan 487.0

4 Chen Jiawei male 389.0

5 Liu Guangtian Male 579.0

6 Zhang Xiaomin female 446.0

Sort by gender /D and entrance score

Use ST

List name

The last LIST command shows the order of names.

A) Willy, Zhang Xiaomin, Chen Jiawei, Wang Zhongyi, Cheng Kai and Liu Guangtian.

B) Wang Zhongyi, Cheng Kai, Chen Jiawei, Liu Guangtian, Willy, Zhang Xiaomin.

C) Wool, Zhang Xiaomin, Wang Zhongyi, Cheng Kai, Chen Jiawei and Liu Guangtian.

D) Zhang Xiaomin, Willy, Liu Guangtian, Cheng Kai, Wang Zhongyi, Chen Jiawei.

(50) Perform the following procedures

Stop the conversation

S=0

I= 1

Enter "N=?" To n

DO WHILE S & lt=N

S=S+I

I=I+ 1

Endor

? S

Start a conversation

If the input value of n is 5, the display value of the last s is

1 B)3 C)5 D)6

II. Fill in the blanks (2 points for each blank, ***40 points)

(1) The automatic batch file is named _ _ (1).

(2)DOS command is divided into internal command and external command, and COMP command belongs to ____(2) command.

(3) Set the current disk to disk C, and now use a DOS command to output all extensions in the current directory of disk A on the printer.

The contents of a file named DAT. This DOS command should be _ _ _ _ (3).

(4) All file names with extensions. BAK in the subdirectory XYZ under the current directory of the current disk should be changed to the extension.

For, the DOS command to be used is ____(4).

(5) Assume that the PATH where the DOS external command file is located has been opened with the PATH command. Now, it is necessary to set the current disk in the current directory.

File WST. TXT is set to read-only, and the DOS command to be used is ____(5).

(6) Output the command design report in format @ SAY format. If you need to print out, you should use the settings.

Order _ _ _ (6). If you want to output on the screen, you should use the setting command ____(7).

(7) In the point state of FoxBASE, call a process ZZ in the process file ABC. PRG, you must use it first.

____(8) command to open this process file; Then run it with the _ _ (9) command.

(8) There is an employee database file with the following contents:

Number. Name Department Salary and Bonus

100 1 changshengfang 850 200

1002 Wang Yang workshop 700 200

1003 land workshop 680 200

200 1 Forest Design Section 900 150

2002 Chenlu Design Section 1200 150

3004 Sun Hai Finance Section 900 100

3006 Liyang Finance Department 1300 100

30 10 Zhang Hu Finance Department 1 100 100

Please fill in the execution results of the following procedures or commands in turn:

Use employees

Total of temporary departments

usage temperature

Sort by salary to temporary salary 1

Use TEMP 1

Display department, salary and bonus.

The displayed result is: _ _ _ _ _ _ _( 10/0)

Use employees

Department = Average salary of "Finance Department"

The value of variable a is _ _ _ _ (1 1).

Wage index idx 1

Go 1

? Number, name

The display result is: _ _ _ _ _ _ (12)

Seek 900

Skip 3

? Salary+bonus

The display result is: _ _ _ _ _ _ (13)

Positioning salary = 900

continue

? (full name)

The display result is: _ _ _ _ _ _ (14)

Reward all the SUBSTR (No.:1, 1) = "1" to B.

(9) In the student database, the age field is N type and the symbol field is L type. Please fill in the blanks:

Use students

Age index of idx2

To position the record pointer on the first record with the age of 20, you should use the command _ _ _ (16).

To display the records of all 20-year-old students, you should use the command display all _ _ _ (17).

Execute the following command

Set the index to

Go to 1 1

After that, set the flag field from the record number 1 1 to the last record as logical true, and use the command:

Replace the logo with. T. _ _ _ _ _ _ (18)

(10) There are two data: employee (number, name, title and basic salary) and salary (number, …, paid salary).

Library file, the following program shows the serial number, name, title, basic salary and actual salary of all employees by association method.

Please fill in the following data in the blank:

Select 1

Use salary alias GZ

Number index of idx3

Option 2

Use employees

Set the relationship on _ _ _ _ (19)

Table number, name, title, basic salary, _ _ _ _ _ (20) actual salary.