FOXPRO
I. FILL IN THE BLANKS:
1. To add more record at the end of any database file use the command ……………. Append
2. In FoxPro the field name must begin with a ………………….. Character
3. The ……………..command is used to exit from FoxPro to DOS. Quit
4. The list command list …………..records on screen. All
5. ? MOD (1965,100) returns ………………….. 65
6. The …………………..command is used to close the database file in use. Close database
7. You can move the command window to any where on the screen press the key ………….. Ctrl+F7
8. The ………………….command can be used to search for data in a database file. Locate
9. To modify the structure of a database file ………………..command is used. Modify structure
10. To define the page length for a report ,select page layout from ……….menu Report
11. The command to modify a report file is ……………. Modify Report
12. The …………….function converts a numeric data to a character string. STR()
13. The …………….command clears all data from the screen. clear
14. The ? command displays data in the next row whereas ?? display it in the …………..row.
Current or same
15. ? Round (1234.6, -2) returns …………………………. 1200
16. The ……..command routes the output of ?/?? Command to printer.
Set printer on
17. Regardless of the setting of SET PRINTER ,…………….sends data to the printer.
???
18. SECOND() and …………………are identical commands.
SYS(2)
19. The ……………..function returns the name of month from a date expression.
CMONTH()
20. CTOD is the reverse of the …………..function.
DTOC
21. The ……..function returns the name of year from a date expression. Year()
22. The default date style is ………………… mm/dd/yy
23. ?LEN(SALESMAN) returns ………………………… 8
24. If VALUE contains 10,500,STR (VALUE, 3) returns………… Asterisks
25. ………………command to assign CREATE to F9 SET FUNCTION F9 TO “CREATE:”
26. Name of the file that holds the default macro set is …………………. DEFAULT.fky
27. ………………command create empty character variable Space()
28. ………………command create memory variable. =
29. ………………..command display yesterday’s date. ?DATE()-1
30. ?MIN(3,12,11) returns ……………………… 3
31. ? Ceiling (189.89) returns …………….. 190
32. The default file extension name used with program file is ……………. .PRG
33. A comment line in a program beings with …………….or …………… * or NOTE
34. The …………removes blank spaces at the end of a character expression. TRIM()
35. An EGA monitor can display ………or ……………….. 25,43
36. The ……………………returns .T. if the specified file is in use. USED()
37. FUNCTION”!” USED WITH @…….GET converts the entered characters to …………… upper-case
38. To disable a bar use the ………………character as the first character of the prompt. \
39. To use a particular letter of a pad or bar as the hot key, prefix…………..before that letter. \<
40. To save all window definitions in the SAMPLE file, use the command …………. SAVE WINDOWS ALL TO SAMPLE
41. The …………………..function returns the current record number RECNO()
42. Accept creates a …………….type variables. Character
43. check= I have a nice house, stuff (check,10,4,”Beautiful”)
I have a beautiful house
44. ? CHR (65) returns………………… A
45. ? ISALPHA (“123,TNAGAR”) returns ………………….. .F.
46. To activate a menu created with @……….PROMPT command ,use the …………. Command. MENU TO
47. When a popup bar is selected, the ……………….. function returns the bar number.
BAR ()
48. The ………………..Function rounds off a numeric expression. Round()
49. ………………….removes all records from the current database file. ZAP
50. The ………………function checks if value of an expression lies between values of two specified expression. Between()
51. …………………command allow you to execute any DOS command without quitting FoxPro. RUN
52. DATE () returns …………………….. System date
53. Append record is in …………………..menu Browse
54. To delete a record in BROWSE window press ……………..Key. Ctrl+T
55. …………….command removing records permanently . PACK
56. To resize the command window press………………keys. Ctrl+F8
57. The default width of memo field is ……………… 10
58. DEL command is same as …………………….. DELETE
59. ………………..Command is used to link multiple databases. SET RELATION
60. ……………Transfers record from one database file to another. APPEND FROM
II. TRUE OR FALSE
1. BROWSE can prohibit deletion of records. True
2. FoxPro menu system has no option to deletion of records. False
3. BROWSE has facility to turn off the vertical grid lines. True
4. The field widths in the browse window can be changed. True
5. The browse window can be divided in two horizontal windows. False
6. The edit windows can berepositioned anywhere on the screen. True
7. RECALL undeletes records deleted from the database with PACK. False
8. DISPLAY NEXT 3 TO PRINTER FOR PIN=”110003”FIELDS NAME, PIN is invalid. False
9. A database file can be sorted on a combination of fields. The combination can include a maximum of three fields. False
10. One can use FoxPro function with SORT and INDEX. False
11. ? PROPER (“NEW DELHI is a nice city”) displays “New Delhi Is A Nice City”. True
12. Normally, the size of the sort file is the same as the original database file. However, it can be less in some cases. True
13. One can index a database file in the descending order in all cases. False
14. If a database file contains 4 fields, its structural compound index file can have up to 4 tags. False
15. Structural compound index fields do not face the problem of corrupted index. True
16. When you open a database file that has a structural compound index file, the first index tags becomes the controlling index tag. False
17. Compact.idx files cannot be used with FoxPro version 1.0. True
18. The independent compound index file of a database is opened automatically by FoxPro whenever required. False
19. One can create an index tag while defining the structure, but not while modifying the structure of a database file. False
20. The report window is divided into three parts. True
21. To preview a report while designing it, Press ^P. False
22. REPORT FROM SAMPLE SCREEN displays the report on the screen. False
23. The RECORD () function returns the current record number. False
24. A report can include up to a maximum of 7 page header lines. False
25. The PAGE () function returns the current page number. False
26. FoxPro for DOS cannot show bold letters while previewing a report. True
27. One can enclose the report title within a box, but not a field in the detail line. False
28. A field from the database cannot be included in pageheader. False
29. A report can be grouped up to maximum of 2 levels. False
30. The TOTAL command consolidates the report totals. False
31. A report cannot use more than 4 detail lines. False
32. REPORT FROM SALES DOUBLE displays the report in double spacing. False
33. A one-dimensional array cannot be resized. False
34. A two-dimensional array cannot be resized. False
35. Only one array variable can be created with one DECLARE command. False
36. A one-dimensional array cannot be converted to two-dimensional one. False
37. Only one type of data can be stored in one array. False
38. Data stored in an element of an array cannot be modified. False
39. Element of a two dimensional array is referred to by a row, column subscript. False
40. Condition and scope can be used with SCATTER. False
41. The Min () function can use a maximum of three expressions. False
42. Only numeric and character expression can be used with MIN() False
43. The SUM command sums up the specified numeric variables. False
44. If one enters COUNT after opening a database file, FoxPro displays the number of records in the database file. True
45. FLOOR(189.89) returns 190. False
46. CEILING (189.89) returns 190. True
47. MOD (1200,100) returns 12. False
48. ROUND (X, Y) is invalid if both X and Y are negative. False
49. CALCULATE MIN () is similar to the MIN () function. False
50. The use of OTHERWISE with DO CASE-ENDCASE is optional. True
51. The use of ELSE with IF-ENDIF is optional. True
52. ALLTRIM () is not supported in FoxPro. False
53. DO WHILE .T. and DO WHILE .NOT. EOF () are similar. False
54. A scope cannot be used with SCAN-ENDSCAN. False
55. The maximum number of CASE statements in a DO CASE-ENDCASE structure is 32. False
56. When a program calls another program file, the called program must have the RETURN command at the end. False
57. A macro variable begins with && False
58. The nesting of program files can be done to a depth of 16 levels. False
59. The WAIT command displays “Wait” on the screen. False
60. The key pressed in response to WAIT WINDOW is stored in a special variable. False
III. SHORT NOTES:
1. Explain what is a database File, Record & Filed?
2. Browse can prohibits deletion of records
3. Writes a program to check number of words in a sentence?
4. FoxPro menu system has no option to delete records.
5. Explain the difference between the following
a) EDIT and CHANGE
b) DELETE and PACK
6. What is the procedure to edit the third record in a database file?
7. Explain sorting?
8. Write a program to display Floyd triangle.
9. Explain Indexing.
10. Explain the difference between the following
a) LIST and DISPLAY ALL
b) EDIT and PACK
11. Explain the use of SEARCH and LOCATE commands in FoxPro.
12. Explain COPY FILE command RENAME command?
13. Explain the features of FoxPro report?
14. Explain the difference between SORTING and INDEXING
15. Write a program to receive a word and display it in reverse order.
16. How will you join two tables? Write the steps?
17. Differentiate data processing and data management.
18. What are the advantages of relational database?
19. Writes a program to check whether the number is palindrome or not?
20. Explain the difference between the following
a) APPEND and APPEND BLANK
b) DOW() and CDOW()
21. Explain any five BROWSE options.
22. Write a program in FoxPro to print N fibonacci numbers.
23. Explain the difference between ACCEPT and INPUT.
24. Explain IF-ENDIF and DO CASE –END CASE.
25. Writes a program to check whether the data starts with alphabet or digit?
26. Write the advantages and drawbacks of DBMS.
27. How to create Index file on multiple fields.
28. Writes a program to display the multiplication table of 7.
29. How to create compound index file with the index dialogbox.
30. Explain how to create it and how entering data in memo field.
31. How to display and print labels in FoxPro.
32. Writes a program to check whether the number is Armstrong or not?
33. How to create Array Memory Variables.
34. Explain SCATTER and GATHER command.
35. Explain COPY TO ARRAY and APPEND FROM ARRAY.
36. Explain Macro?
37. How we record and Editing Macros.
38. Explain DBMS?
39. Explain what is a program file? How we are creating a program file?
40. Explain RTRIM (), LTRIM () and ALLTRIM () with suitable example?
41. Explain advanced features of @……………SAY command.
42. How to create a check box in FoxPro.
43. How to create a push button in FoxPro.
44. Explain different file manipulation functions in FoxPro
45. Explain the difference between LOCATE and SEEK
46. Writes a program to check whether the number is Prime or not?
47. Explain different types of fields in FoxPro.
48. Write a program to sort ‘N’ names in alphabetical order.
49. Writes a program to check whether the number is odd or even.
50. Explain how to set a function in a key.
IV. ESSAYS:
1. Explain different field types in FoxPro.
2. What is Rushmore technology? How does it increase the search speed with commands that use the FOR clause.
3. Explain date and time functions in FoxPro.
4. Explain the usage of @ command.
5. What is a memory variable? How to create and using memory variables?
6. Write a program to create a simple calculator.
7. Explain the use of Memo field in FoxPro?
8. Explain various Error conditions in FoxPro
9. Explain the different looping statements in FoxPro.
10. Explain how to create a report?
11. Explain different mathematical functions in FoxPro.
12. How will you add records to an existing table?
13. Explain different mathematical commands in FoxPro.
14. What is indexing? What are Independent Compound Index File and Structure Compound Index File?
15. Write a menu driven program that adds, deletes and find records of the database “Foxpro.dbf’”.
I. FILL IN THE BLANKS:
1. To add more record at the end of any database file use the command ……………. Append
2. In FoxPro the field name must begin with a ………………….. Character
3. The ……………..command is used to exit from FoxPro to DOS. Quit
4. The list command list …………..records on screen. All
5. ? MOD (1965,100) returns ………………….. 65
6. The …………………..command is used to close the database file in use. Close database
7. You can move the command window to any where on the screen press the key ………….. Ctrl+F7
8. The ………………….command can be used to search for data in a database file. Locate
9. To modify the structure of a database file ………………..command is used. Modify structure
10. To define the page length for a report ,select page layout from ……….menu Report
11. The command to modify a report file is ……………. Modify Report
12. The …………….function converts a numeric data to a character string. STR()
13. The …………….command clears all data from the screen. clear
14. The ? command displays data in the next row whereas ?? display it in the …………..row.
Current or same
15. ? Round (1234.6, -2) returns …………………………. 1200
16. The ……..command routes the output of ?/?? Command to printer.
Set printer on
17. Regardless of the setting of SET PRINTER ,…………….sends data to the printer.
???
18. SECOND() and …………………are identical commands.
SYS(2)
19. The ……………..function returns the name of month from a date expression.
CMONTH()
20. CTOD is the reverse of the …………..function.
DTOC
21. The ……..function returns the name of year from a date expression. Year()
22. The default date style is ………………… mm/dd/yy
23. ?LEN(SALESMAN) returns ………………………… 8
24. If VALUE contains 10,500,STR (VALUE, 3) returns………… Asterisks
25. ………………command to assign CREATE to F9 SET FUNCTION F9 TO “CREATE:”
26. Name of the file that holds the default macro set is …………………. DEFAULT.fky
27. ………………command create empty character variable Space()
28. ………………command create memory variable. =
29. ………………..command display yesterday’s date. ?DATE()-1
30. ?MIN(3,12,11) returns ……………………… 3
31. ? Ceiling (189.89) returns …………….. 190
32. The default file extension name used with program file is ……………. .PRG
33. A comment line in a program beings with …………….or …………… * or NOTE
34. The …………removes blank spaces at the end of a character expression. TRIM()
35. An EGA monitor can display ………or ……………….. 25,43
36. The ……………………returns .T. if the specified file is in use. USED()
37. FUNCTION”!” USED WITH @…….GET converts the entered characters to …………… upper-case
38. To disable a bar use the ………………character as the first character of the prompt. \
39. To use a particular letter of a pad or bar as the hot key, prefix…………..before that letter. \<
40. To save all window definitions in the SAMPLE file, use the command …………. SAVE WINDOWS ALL TO SAMPLE
41. The …………………..function returns the current record number RECNO()
42. Accept creates a …………….type variables. Character
43. check= I have a nice house, stuff (check,10,4,”Beautiful”)
I have a beautiful house
44. ? CHR (65) returns………………… A
45. ? ISALPHA (“123,TNAGAR”) returns ………………….. .F.
46. To activate a menu created with @……….PROMPT command ,use the …………. Command. MENU TO
47. When a popup bar is selected, the ……………….. function returns the bar number.
BAR ()
48. The ………………..Function rounds off a numeric expression. Round()
49. ………………….removes all records from the current database file. ZAP
50. The ………………function checks if value of an expression lies between values of two specified expression. Between()
51. …………………command allow you to execute any DOS command without quitting FoxPro. RUN
52. DATE () returns …………………….. System date
53. Append record is in …………………..menu Browse
54. To delete a record in BROWSE window press ……………..Key. Ctrl+T
55. …………….command removing records permanently . PACK
56. To resize the command window press………………keys. Ctrl+F8
57. The default width of memo field is ……………… 10
58. DEL command is same as …………………….. DELETE
59. ………………..Command is used to link multiple databases. SET RELATION
60. ……………Transfers record from one database file to another. APPEND FROM
II. TRUE OR FALSE
1. BROWSE can prohibit deletion of records. True
2. FoxPro menu system has no option to deletion of records. False
3. BROWSE has facility to turn off the vertical grid lines. True
4. The field widths in the browse window can be changed. True
5. The browse window can be divided in two horizontal windows. False
6. The edit windows can berepositioned anywhere on the screen. True
7. RECALL undeletes records deleted from the database with PACK. False
8. DISPLAY NEXT 3 TO PRINTER FOR PIN=”110003”FIELDS NAME, PIN is invalid. False
9. A database file can be sorted on a combination of fields. The combination can include a maximum of three fields. False
10. One can use FoxPro function with SORT and INDEX. False
11. ? PROPER (“NEW DELHI is a nice city”) displays “New Delhi Is A Nice City”. True
12. Normally, the size of the sort file is the same as the original database file. However, it can be less in some cases. True
13. One can index a database file in the descending order in all cases. False
14. If a database file contains 4 fields, its structural compound index file can have up to 4 tags. False
15. Structural compound index fields do not face the problem of corrupted index. True
16. When you open a database file that has a structural compound index file, the first index tags becomes the controlling index tag. False
17. Compact.idx files cannot be used with FoxPro version 1.0. True
18. The independent compound index file of a database is opened automatically by FoxPro whenever required. False
19. One can create an index tag while defining the structure, but not while modifying the structure of a database file. False
20. The report window is divided into three parts. True
21. To preview a report while designing it, Press ^P. False
22. REPORT FROM SAMPLE SCREEN displays the report on the screen. False
23. The RECORD () function returns the current record number. False
24. A report can include up to a maximum of 7 page header lines. False
25. The PAGE () function returns the current page number. False
26. FoxPro for DOS cannot show bold letters while previewing a report. True
27. One can enclose the report title within a box, but not a field in the detail line. False
28. A field from the database cannot be included in pageheader. False
29. A report can be grouped up to maximum of 2 levels. False
30. The TOTAL command consolidates the report totals. False
31. A report cannot use more than 4 detail lines. False
32. REPORT FROM SALES DOUBLE displays the report in double spacing. False
33. A one-dimensional array cannot be resized. False
34. A two-dimensional array cannot be resized. False
35. Only one array variable can be created with one DECLARE command. False
36. A one-dimensional array cannot be converted to two-dimensional one. False
37. Only one type of data can be stored in one array. False
38. Data stored in an element of an array cannot be modified. False
39. Element of a two dimensional array is referred to by a row, column subscript. False
40. Condition and scope can be used with SCATTER. False
41. The Min () function can use a maximum of three expressions. False
42. Only numeric and character expression can be used with MIN() False
43. The SUM command sums up the specified numeric variables. False
44. If one enters COUNT after opening a database file, FoxPro displays the number of records in the database file. True
45. FLOOR(189.89) returns 190. False
46. CEILING (189.89) returns 190. True
47. MOD (1200,100) returns 12. False
48. ROUND (X, Y) is invalid if both X and Y are negative. False
49. CALCULATE MIN () is similar to the MIN () function. False
50. The use of OTHERWISE with DO CASE-ENDCASE is optional. True
51. The use of ELSE with IF-ENDIF is optional. True
52. ALLTRIM () is not supported in FoxPro. False
53. DO WHILE .T. and DO WHILE .NOT. EOF () are similar. False
54. A scope cannot be used with SCAN-ENDSCAN. False
55. The maximum number of CASE statements in a DO CASE-ENDCASE structure is 32. False
56. When a program calls another program file, the called program must have the RETURN command at the end. False
57. A macro variable begins with && False
58. The nesting of program files can be done to a depth of 16 levels. False
59. The WAIT command displays “Wait” on the screen. False
60. The key pressed in response to WAIT WINDOW is stored in a special variable. False
III. SHORT NOTES:
1. Explain what is a database File, Record & Filed?
2. Browse can prohibits deletion of records
3. Writes a program to check number of words in a sentence?
4. FoxPro menu system has no option to delete records.
5. Explain the difference between the following
a) EDIT and CHANGE
b) DELETE and PACK
6. What is the procedure to edit the third record in a database file?
7. Explain sorting?
8. Write a program to display Floyd triangle.
9. Explain Indexing.
10. Explain the difference between the following
a) LIST and DISPLAY ALL
b) EDIT and PACK
11. Explain the use of SEARCH and LOCATE commands in FoxPro.
12. Explain COPY FILE command RENAME command?
13. Explain the features of FoxPro report?
14. Explain the difference between SORTING and INDEXING
15. Write a program to receive a word and display it in reverse order.
16. How will you join two tables? Write the steps?
17. Differentiate data processing and data management.
18. What are the advantages of relational database?
19. Writes a program to check whether the number is palindrome or not?
20. Explain the difference between the following
a) APPEND and APPEND BLANK
b) DOW() and CDOW()
21. Explain any five BROWSE options.
22. Write a program in FoxPro to print N fibonacci numbers.
23. Explain the difference between ACCEPT and INPUT.
24. Explain IF-ENDIF and DO CASE –END CASE.
25. Writes a program to check whether the data starts with alphabet or digit?
26. Write the advantages and drawbacks of DBMS.
27. How to create Index file on multiple fields.
28. Writes a program to display the multiplication table of 7.
29. How to create compound index file with the index dialogbox.
30. Explain how to create it and how entering data in memo field.
31. How to display and print labels in FoxPro.
32. Writes a program to check whether the number is Armstrong or not?
33. How to create Array Memory Variables.
34. Explain SCATTER and GATHER command.
35. Explain COPY TO ARRAY and APPEND FROM ARRAY.
36. Explain Macro?
37. How we record and Editing Macros.
38. Explain DBMS?
39. Explain what is a program file? How we are creating a program file?
40. Explain RTRIM (), LTRIM () and ALLTRIM () with suitable example?
41. Explain advanced features of @……………SAY command.
42. How to create a check box in FoxPro.
43. How to create a push button in FoxPro.
44. Explain different file manipulation functions in FoxPro
45. Explain the difference between LOCATE and SEEK
46. Writes a program to check whether the number is Prime or not?
47. Explain different types of fields in FoxPro.
48. Write a program to sort ‘N’ names in alphabetical order.
49. Writes a program to check whether the number is odd or even.
50. Explain how to set a function in a key.
IV. ESSAYS:
1. Explain different field types in FoxPro.
2. What is Rushmore technology? How does it increase the search speed with commands that use the FOR clause.
3. Explain date and time functions in FoxPro.
4. Explain the usage of @ command.
5. What is a memory variable? How to create and using memory variables?
6. Write a program to create a simple calculator.
7. Explain the use of Memo field in FoxPro?
8. Explain various Error conditions in FoxPro
9. Explain the different looping statements in FoxPro.
10. Explain how to create a report?
11. Explain different mathematical functions in FoxPro.
12. How will you add records to an existing table?
13. Explain different mathematical commands in FoxPro.
14. What is indexing? What are Independent Compound Index File and Structure Compound Index File?
15. Write a menu driven program that adds, deletes and find records of the database “Foxpro.dbf’”.
No comments:
Post a Comment