VFP练习2(国外英文资料).doc

VFP练习2(国外英文资料) VFP exercise 2 Full marks: 73 Name: ________ 1, individual choice questions (subject to 36 points) 1, with a table called test, there are 2 date type field: to participate in the work date (field name cjgzrq) and the date of birth (field name csrq). We want to create an index, according to the requirements of the first to participate in the work of the date sorting, the same date to work according to the date of birth order, the index expression should be ________. () A, cjgzrq+csrq B, DTOC (cjgzrq), +DTOC (csrq) C, DTOC (cjgzrq, 1) +DTOC (csrq, 1) D, cjgzrq - csrq 2, in the commands associated with table operations, some commands can only operate on tables in the current workspace, and some commands can operate on tables in the non current workspace. In the following order, can only operate on the current workspace table command is ________. () A, REPLACE B, GOTO C, SKIP D, DELETE 3, with a teacher table, JS contains a character field XB (indicating the teachers gender). The following command syntax is correct ________. () A, DELETE, FROM, JS, WHERE, xb=, men B, DELETE, TABLE, JS, WHERE, xb=, men C, DELETE, FROM, JS, FOR, xb=, men D, DELETE, TABLE, JS, FOR, xb=, men 4, for the VFP in the free list, the index type may not create the ________. () A, master index B, candidate index C and unique bow D, general index 5, with a free table rsda, the table has a field called ZC field. If the field name changed to ZC Zhicheng, you can use the following command of ________. () A, ALTER, TABLE, rsda, RENAME, COLUMN, ZC, TO, Zhicheng B, ALTER, TABLE, rsda, RENAME, FIELD, ZC, TO, Zhicheng C, ALtER, TABLE, rsda, COLUMN, RENAME, zC, T0, Zhicheng D, ALTER, TABLE, rsda, FIELD, ZC, RENAME, TO, Zhicheng 6, if you want to create a free table RB contains only one field, the field name is Rb, a field type of character, the field width is 20, you can use the following command to create ________. () A, CREATE, TABIE, Rb, Rb, C (20) B, CREATE, TABLE, Rb (RB, C (20)) C, CREAF