Visual Foxpro Report. Nanjing University of Science & Technology. January 10, 2017. Visual Foxpro. 1. Multiple Choices. For this section, circle the BEST answer for each question. For each question, I may ask the basic principle and theory related to

Visual Foxpro Report

Student ID:	9165802E111
Student Name:	Ai Min艾敏
Department	International Trade

Nanjing University of Science & Technology

January 10, 2017

Visual Foxpro

1. Multiple Choices. For this section, circle the BEST answer for each question. For each question, I may ask the basic principle and theory related to it.

(1) Among the following expressions, __C__ returns. F.

AT(″ A″, ″ BCD″ ) B. ″ Information″ $ ″ Information System″

ISNULL(″ ″ ) D. SUBSTR(″ Computer Science″, 3, 2)

Note: I might ask the answers of the other functions.

(2) Among the following functions, _D__ returns the result of Character data type.

A. Dow() B. At() C. Val() D. Chr()

Note: I might ask the data type of the other functions and what these functions do.

(3) The data type of the expression {＾ 2005-10-03}-{＾ 2005-09-25} is _A__

Integer B. Date C. DateTime D. Character

(4) What is the result of the command LEN(DTOC(DATE(), 1))?

A. 6 B. 8 C. 10 D. 12

Note: I may ask what’s the result of DATE()? DTOC(DATE(), 1)? What’s the function of parameter “1” here?

(5) What’s the result of the command“ ? 4*6%5^3+1 ”?

25 　　　　 B. 65 　　　 C. 12 　　　　　 D. 5

Note: tell me how to calculate.

(6) What’s the result of the command “ ? IIF(12< 13， ‘WANG1’， 23=34. 6) ”?

23 　　 B. . F. 　　　 C. WANG1 　　　　 D. 34. 6

Note: tell me how to calculate.

(7) Open a blank table (without any records) and do not move the record pointer. What are the results of RECNO(), BOF() and EOF()?

A． 0, . T. and. T. B. 0, . T. and. F. C. 1, . T. and. F. D. 1, . T. and. T.

(8) What’s the function of “ select 0 ”?

A. the min number of current used work areas B. the current work area

C. the min number of current unused work areas

D. the max number of current unused work areas

(9) Which of the following commands returns . F. value?

A. ? AT(“A”, “BCD”) B. ? “贸易 ” $ “国际贸易管理 ”

C. ? Between('0', 'A', 'a') D. ? SUBSTR(“computer science”, 3, 2)

Note: tell me the results of the other commands and the function of each command.

(10) Run the following commands. What’s the result of the last one?

DIMENSION M（ 2, 2）

M(1, 1)=10

M(1, 2)=20

M(2, 1)=30

M(2, 2)=40

? M(2)

A. undefined variable B. 10 C. 20 D. . F.

Note: tell my why.

(11) What is the result of “ 9%-7 ”?

2 B. -2 C. -5 D. 5

Note: tell me how to calculate.

(12) What is the result of {^1990/04/17}+30+DATE()?

a new date B. a new time C. a new date & time D. invalid expression

(13) What are the results of the following commands?

set collate to " machine"

? 'A'< 'B', 'a'< 'A', ' '< 'A'(with a space in the left expression)

T, F, T B. T, F, F C. F, T, F D. F, F, T

Note: Tell my why. Tell me the ASCII code of “A”, “B”, and space.

(14) What is the result of “ ? round(2345. 6799, -4) ”?

0 B. 2345. 6799 C. 2346 D. 2345