Free Printable 7th standard foxpro

1.

Unprocessed facts and figures is called ____

a)

data

b)

information

c)

process

d)

value

2.

A collection of related records constitutes a ______

a)

file

b)

database

c)

field

d)

program

3.

Numeric data type cannot exceed __digits in length.

a)

20

b)

8

c)

4

d)

2

4.

The extension of memo file is ___

a)

.fpt

b)

.dbf

c)

.prg

d)

.idx

5.

___ stands for index file

a)

.idx

b)

.fpt

c)

.prg

d)

.dbf

6.

_____ is a logical operator which checks whether all the given conditions are True.

a)

AND

b)

OR

c)

NOT

d)

none of the above

7.

Print command in VFP is __

a)

?

b)

print

c)

@

d)

*

8.

The ______ command is used to assign a value to one or many memory variables.

a)

store

b)

let

c)

assignment

d)

?

9.

Comments in VFP start with ____.

a)

*

b)

#

c)

comments

d)

" "

10.

To assign a value to one memory variable __ is used.

a)

=

b)

assign

c)

data

d)

all the above

11.

The maximum number of fields in VFP is ____

a)

255

b)

256

c)

8

d)

20

12.

The ____ command determines the color attributes of the screen.

a)

set colour to

b)

change colour

c)

background colour

d)

bg clr

13.

_________ is a memory location in the computer.

a)

Variable

b)

constant

c)

data

d)

information

14.

Field name cannot exceed __ characters.

a)

10

b)

8

c)

255

d)

256

15.

The extension of database file is __

a)

.dbf

b)

.idx

c)

.fpt

d)

.fpt

16.

________command opens a database file.

a)

use <file name>

b)

open <file name>

c)

modify command <file name>

d)

do <file name>

17.

The special character that is used in a file name or a field name is _____

a)

underscore

b)

comma

c)

space

d)

" "

18.

_____ command displays all records in a scrolling manner.

a)

list

b)

display

c)

print

d)

?

19.

_______ command displays records page wise.

a)

display all

b)

display

c)

list

d)

?

20.

______ command is used to exit VFP.

a)

quit

b)

exit

c)

close all

d)

use

21.

_____ command removes all records permanently from the database.

a)

zap

b)

pack

c)

delete

d)

erase

22.

______ and ____ commands are used to move the record pointer.

a)

skip

b)

goto

c)

move

d)

position

23.

The _____ command is used to add up the values of a field.

a)

sum

b)

add

c)

summation

d)

plus

24.

____stands for End Of File.

a)

EOF

b)

EF

c)

END

d)

ENOF

25.

__________ command adds records to end of file.

a)

append

b)

edit

c)

add

d)

end

26.

_________ command adds record after the current record.

a)

Insert

b)

append

c)

edit

d)

add records

27.

__________command is used to change the name of an existing file.

a)

Rename

b)

change

c)

name

d)

edit

28.

__________ command duplicates a file in VFP.

a)

Copy file

b)

replicate

c)

duplicate

d)

rename

29.

Renaming and copying cannot be done on________files.

a)

open

b)

closed

c)

used

d)

new

30.

_________ is the process of rearranging records in a meaningful order.

a)

sorting

b)

arranging

c)

indexing

d)

processing

31.

_______ is faster than sorting

a)

indexing

b)

printing

c)

storing

d)

deleting

32.

The extension of a sorted file is____

a)

.dbf

b)

.idx

c)

.fpt

d)

.prg

33.

Sorting cannot be done on ______ fields.

a)

memo

b)

string

c)

text

d)

numeric

34.

_____________ command is used to activate index files.

a)

set index to

b)

set order to

c)

activate

d)

use

35.

The order of priority of index files can be changed by ___________ command.

a)

set order to

b)

set index to

c)

order

d)

index

36.

A function always returns __________

a)

one value

b)

no value

c)

two values

d)

more than 2

37.

_________________ are enclosed within parenthesis upon which the function acts.

a)

Arguments or parameters

b)

values

c)

requirements

d)

function

38.

The ___________ function returns the day number of the current date.

a)

day (date ())

b)

day()

c)

date()

d)

day(today)

39.

The ___________ function returns the current system date.

a)

date()

b)

day()

c)

date(day())

d)

date(today)

40.

The ___________ function returns a string containing blank spaces.

a)

space()

b)

blank()

c)

empty()

d)

none of the above

41.

The __________function converts numeric expression to character string.

a)

str()

b)

string()

c)

num()

d)

char()

42.

The __________ function returns the absolute value of the argument.

a)

abs()

b)

absolute()

c)

math()

d)

int()

43.

The ______________ command executes a VFP program.

a)

do<filename>

b)

use <filename>

c)

execute<filename>

d)

output<filename>

44.

_______ and _____ commands allow the user to enter data through the keyboard.

a)

accept

b)

input

c)

print

d)

enter

45.

The ___ template converts letters to uppercase.

a)

!

b)

U

c)

L

d)

@

46.

The_____ command enables the user to accept numeric data through the keyboard

a)

INPUT

b)

ACCEPT

c)

PRINT

d)

?

47.

________ is pressed to save a program file.

a)

CTRL+W

b)

CTRL+Q

c)

ESC

d)

Save

48.

The _______ function rounds off the given number.

a)

round()

b)

int()

c)

roundoff()

d)

roundto()

49.

The _________ clause is used to format data.

a)

picture

b)

@say

c)

@get

d)

input

50.

VFP allows ___ independent variables.

a)

256

b)

255

c)

8

d)

10

51.

A=5 and B= -5

?max((A+B),B)

what is the output?

a)

0

b)

-5

c)

5

d)

none of the above

52.

The result of mod (3,4) =

a)

3

b)

4

c)

0

d)

1

53.

_____________command is used to make a selection between two alternatives.

a)

If else endif

b)

do while

c)

decision

d)

selection

54.

__________ means having an if-endif statement within another if-endif statement.

a)

Nesting

b)

looping

c)

processing

d)

decision making

55.

__________is a pair of commands used to choose one set among several sets of alternatives.

a)

do case

b)

if else endif

c)

do while

d)

choose

56.

_________________ commands are used to display a block of text.

a)

Text - Endtext

b)

?

c)

print

d)

block

57.

_______________ is used to stop executing the loop and transfer the control to the beginning of the loop.

a)

Loop statement

b)

decision statement

c)

exit statement

d)

continue statement

58.

The ____________ terminates the loop based on some conditions.

a)

Exit statement

b)

loop statement

c)

continue statement

d)

quit statement

59.

Subprograms are otherwise called as ________________

a)

subroutines or called programs.

b)

calling program

c)

functions

d)

return

60.

The ____________ command is the closing statement of Subprogram

a)

return

b)

close

c)

end

d)

quit

61.

The _________ function is used to repeat a string for a given number of times.

a)

replicate()

b)

duplicate()

c)

copy()

d)

repeat()

62.

______________ are programs executed from another program.

a)

Subprograms

b)

function

c)

methods

d)

high level program

63.

?Round(6789.34,-2) =_________________

a)

6800

b)

6789.34

c)

6790

d)

6700

64.

The___________function converts the given string to uppercase.

a)

upper ()

b)

!

c)

toupper()

d)

str()

65.

? Str (8076.85)= _______

a)

8077

b)

8076

c)

8076.85

d)

error

66.

?Int(37/2)=______

a)

18

b)

18.5

c)

19

d)

1

67.

? Mod (20/4,4) = ____

a)

1

b)

4

c)

0

d)

5

68.

The ____________ is used to invoke the VFP editor.

a)

modify command < filename>

b)

edit <file name>

c)

open editor

d)

use editor

69.

The _____ function returns the specified number of rightmost characters

a)

Right()

b)

left()

c)

?

d)

rgt()

70.

The ____ function returns -1 if a negative number is given

a)

sign()

b)

int()

c)

abs()

d)

mod()

7th standard foxpro

Total questions: 70

Worksheet time: 36mins

Similar Resources on Wayground