Visual FoxPro6 0 database is going to be examed, help

1.The commands for moving the record pointer relative to each other and moving the record pointer absolutely in a table are c) skip and go, respectively

2.In the operation of the table, the command to create the index is.

c) index

3.When the system is in the full-screen state when it is in the case of creating a free table, program, etc., the correct operation is as follows.

a) Press Ctrl+W

4.After executing the following command, the value of the function eof() must be. t.is c) sum basic salary to ss while gender ='Female'

5.The database system is.

b) Relational.

6.Open a datasheet file at the same time to"Name"A single index file for keywords, requiring the lookup name to be"Zhang Wei"Teachers should use commands.

c) Find Zhang Wei.

7.After the store ctod( 03 09 94 ) to a command is executed, the type of variable a is .

a) Date type.

8.The collection of data stored inside the computer is.

b) Databases.

9.The structured query language SQL has several features: DDL, data control, and a) data query.

c) Data Manipulation.

10.Regardless of whether the index is active or not, the command to locate the same record is c) go 6

1. Multiple choice questions.

1. The data model supported by VFP is (C).

A Hierarchy B Reticular C Relationship D Tree.

2. The three basic relational operations that can be achieved in Visual FoxPro are (C).

a.Indexing, sorting, finding bDatabase building, entry, sorting cSelect, Project, Connect DDisplay, Statistics, Copying.

a number of records b a number of empty records c a record with data d an empty record.

4. When using the replace command, if the range phrase is all, the pointer pointing to (c) will be recorded after the command is executed.

a End record bFirst record cThe end of the record is followed by dThe front of the first record.

5. The file with the extension of scx is (a).

a.Form File B Database Table File C Database File D Project File.

6. The command that can terminate this cycle and start the next round of cycle execution is (a).

a．loop b．exit c．skip d．goto

7. In the following equations of VFP, the result of the operation is numerical (A).

a．len(’abcd’)-1 b．’1234’+’5678’ c．120+30=150 d．ctod(’04/05/97’)-28

2. Fill in the blanks.

1、"China"$"Lovely China"The result is .t.The function bof() value is of type l

2. VFP supports two types of index files, namely structural composite index files and single structural index files

3. The method of refreshing the form in VFP is refresh, and the command to create the data table is create

4、left("Shandong University of Technology", 8)"Shandong Institute of Technology"The way to hide a form is to hide

5. In the relational data model, the columns of a two-dimensional table are called attributes and the rows are called tuples

6. The command to create the program file in vfp is modify command, and the command to execute the program file is do

7. In visual, data tables are divided into two types: database tables and free tables.

1a 2c 3a 4b 5c 6d 7b 8a 9d 10d

Fill-in-the-blank questions. 1 Visual FoxPro has two kinds of variables: memory variables and field variables.

2 There are 6 types of memory variables: data, character, date, logic, date, and currency.

3 The menu files designed with the menu designer have the extension of mnx, and the resulting menu program files have the extension of mpx.

4 Visual FoxPro not only supports process-oriented programming, but also object-oriented programming.

5 The zap command can delete all records of the current table file.

6 The primary index field must not have duplicate values or null values.

Take a good look at the real paper test questions from the past years, and the written test is no problem.

The time to type so many words is not as good as memorizing the question bank, VFP is over level 2, you don't need to understand, just memorize the question bank.