《vfp程序设计》模拟试卷六及答案（VFP program design six simulation papers and answers）

1、vfp程序设计模拟试卷六及答案（VFP program design six simulation papers and answers）2006 secondary occupation school examinationVISUAL FOXPRO paper BFirst, fill in the blanks (50 points, 2 points each)1, create a report method.2, Visual FoxPro 6 is a database management system.In 3, VFP index is divided into four

2、kinds, and.In 4, Visual in FoxPro, the array subscript is from the beginning.5, the field values are not allowed to repeat, and only one table to create an index index.The program structure of 6 in VFP, 3, respectively,.In 7, Visual FoxPro 6, the data table is divided into two kinds and.8, in VFP, a

3、 reference to object references and references two.9, using VFP in absolute and relative mobile command move command can move the pointer in the table.10, Visual FoxPro, to create a database table file should be selected in the designer.11, the object is the object can perform its action or behavior

4、.12, by a number of local data table to create the view, should be called.13, query and update data in a data table.14, the query designer field tab, select control.15, view and query can be operated on the table.16, in SQL, create unique index to use reserved words.The object of Myforml form 17, in

5、 the program to show what has been created, should use the command.Two, choice (a total of 30 points, 2 points for each item)(1) no matter whether the force index, positioning to the same record command is ().A GO TOP B) GO) BOTTOM C) GO D) SKIP 6(2) may be accompanied by a table and open automatica

6、lly open index ().A) single index file (IDX) B) composite index file (CDX)C) structured composite index file D) unstructured composite index file(3) to increase the wages of 100 yuan should use the command for the current table (staff).A +100 CHANGE WITH) pay wagesB +100 REPLACE WITH) pay wagesC +10

7、0 CHANGE ALL WITH) pay wagesD +100 REPLACE ALL WITH) pay wages(4) Visual FoxPro referential integrity rules (not included).A) update rule B) query rule C) delete rule D) insertion rules(5) in the database designer, to establish the relation between the two tables is achieved by the following index.(

8、)A) a party table of the main index or candidate index, multi table indexB) the main index one table, many table index or candidate indexC) general index one table, from the table of the main index or candidate indexD) a common index table,Many candidate index table or index(6) if you want to see th

9、e results directly on the screen, check the whereabouts of should choose ().A) B) C) screen browse temporary table or browse or screen screen D)(7) using the menu operation method to open an already exists in the current directory query file after zgjk.qpr in the command window command is generated

10、().A OPEN QUERY zgjk.qpr) B MODIEY QUERY zgjk.qpr)C DO QUERY zgjk.qpr) D CREATE QUERY zgjk.qpr)(8) described below about Visual FoxPro array, the error is ().A) with DIMENSION and DECLARE can define an arrayB) only one-dimensional array and two-dimensional array Visual FoxProC) all the array element

11、s in an array must be of the same type of dataD) each array element initial new definition for.F.(9) in the following function, function of numerical value is ().A (AT) people, Peoples Republic of China)(B) CTOD 01/01/96)C (BOF)D (SUBSTR) (DTOC) (DATE), 7)(10) in Visual FoxPro, general field G and M

12、 memo fields in the table width is ().A) 2 bytes of B 4 bytes) C) 8 bytes of D 10 bytes)(11) of referential integrity is set in Visual FoxPro, to set a: when changing the parent key field for the primary key field or in the candidate list, automatically change all the values in the corresponding rec

13、ord table. Should choose ().A) (Restrict) B) ignore the limit (Ignore)C (Cascade) D) cascade cascade (Cascade) or Limited (Restrict)(12) in the Visual FoxPro data window, use the SET RELATION command to establish the connection between the two tables, this association is ().A) permanent association

14、B) permanent or temporary Association AssociationC) temporary association D) permanent and temporary Association Association(13) to clear the main window screen command is ().A) CLEAR B) CLEAR ALLC CLEAR SCREEN D CLEAR WINDOWS)(14) in the creation of quick report, basic zone (including).A) title, de

15、tails and summary B), details page header and page footerC) group header, details and group D) footnote to the report title, details and pages of footnotes(15) save Visual FoxPro report files in.FRX (is).A) print preview B format) to print the report itselfC) report format and data D) define a repor

16、t format designThree, determine the title (20 points)1, can use the quick report function to add more than one table in the field to the report designer. ()2, report design, undo function can undo several times in front of the operation.()3, open the file, the Visual FoxPro index file will automatic

17、ally open the table. ()4, report data sources can be a table, but not the view. ()5, all data output statements are stored in the report file. ()6, the array must be defined at first, after the assignment. ()7, use MODIFY COMMAND to create the program file is a text file. ()8, open the table, the cu

18、rrent record is the first record. ()9, in the multi branch selection structure provides a choice, and there is only one option is executed. ()10, data information, information and data. ()In 11, the cycle structure of the program, the body of the statement is executed at least once. ()12, the use of

19、 DOWITH parameter table is variable parameters can only transfer. ()13, the menu is defined with storage form file. ()Have a value and a data type 14, a memory variable at any one time only. ()15, when the query is run, the system default query results are displayed on the screen. ()16, the query and view can output data in the browse window. ()17, query two tables of data, between the two tables can not establish a connection. ()18, the new query query designer, only to save the query, to run the query. ()19, free table and database cannot be transformed into each other. ()20, a databas