Saurastra University 2006 B.C.A Computer Application DBMS USING FOXPRO (Old ) - Question Paper
Illllllllllllllllllllllllll
*SB-1884*
SB-1884 Seat No._B. C. A. (Sem. I) Examination March/April - 2006 DBMS USING FOXPRO
(Old Course)
Time : 3 Hours] [Total Marks : 100
1 Attempt Any Four [20]
(1) What is DBMS? Explain its advantages over manual database.
(2) List out FoxPro Data Types And Give Rules For Fields Naming.
(3) Explain List Command And Give The Difference Between List And Display All.
(4) List various Record Movable Command And Explain Any Two.
(5) Explain Locate Command.
2 Attempt Any Four [20]
(1) List various deletion operation Command And Explain Any Two.
(2) Explain Do Case...End Case Statement.
(3) Explain Browse Command.
(4) Discuss various scope option with example.
(5) What is Indexing? Explain Single Index file.
3 (A) Explain The Following Function (Any Four) [10]
(1) RoundO (2) Str() (3) FloorQ
(4) Deleted()(5) Substr()
(B) Explain The Following Command (Any Four) [10]
(1) Set Filter ' (2) Set Relation To (3) Set Clock
(4) Set Alternate (5) Set MemoWidth
4 Attempt Any Four [20]
(1) Explain Scatter And Gather Command with example.
(2) Explain @...Say Commands.
(3) Write a short note on UDF.
(4) What is POP-UP? Explain With All Syntaxes.
(5) List out Window commands and explain any two.
(2) Write A program to input a sentence from keyboard. Print the total alphabet character in sentence, total word in sentence and print the Reverse sentence.
Input : Believe In God.
Output:
Total alphabet character : 12 Total Word : 3
Reverse Sentence : .doG ni eveileB
(3) Following database file has been created.
Result.dbf
Num Numeric 3
Name Character 20
Result Character 15 (FIRST, SECOND,PASS)
Write a program to read records of above database file and generate following result.
First Class
Name
Number
Second Class
Name
Number
Pass Class
Name
Number
SB-1884] 2 [ 100 ]
Attachment: |
Earning: Approval pending. |