Saurastra University 2006 B.C.A Computer Application DBMS using Foxpro - Question Paper
SP-9414 Seat No._
iiiiiiiiiiii iii ii iiiiii iiii
*SP-9414*
B. C. A. (Sem. - II) Examination April/May - 2006 DBMS using Foxpro
Time : 3 Hours] [Total Marks : 100
Q.1. Attempt any five [20]
1. What is DBMS, RDBMS? Explain database file, field & record.
2. Write syntax and example of DO CASE... .ENDCASE
3. What is an ARRAY? Explain with a suitable example.
4. Explain scope options of list command with example.
5. Explain data types available in FoxPro.
6. Discuss set relation command with example.
Q.2 A. Explain following Functions. [Any five] [10]
[1]Round [2] Inlist [3] Stuff [4] Eof [5] Val [6] iif
Q.2 B. Explain following SET commands [Any five] [10]
[1] Alternate [2] Carry [3] Order [4] Device [5] Default [6] Color
Q.3 Attempt the following [Any four] [20]
(1) B BO BOO BOOK
(2) Take 10 values from keyboard and sort in descending order, Print values before sorting and after sorting.
(3) Write a program to enter a number and check whether the number is prime or not.
(4) Write a program to generate following series 1,2,5,10,17,.......Up to n terms.
(5) Write a program to input a string and display each word in next line.
Q.4 Attempt any two programs [20]
1.Write a program to delete a record from student.dbf (structure -> sno,sname,m1,m2,tot, per)
2.Write a program to add a record in BKMASTER and book number should be unique. (Bkno, Title, Author, Edition, Price, Qty)
3.Write a program to generate a statement as follows using 2 databases.
Custmast.DBF Custtran.DBF
CNO N 3 0 CNO N 3 0
NAME C 15 DEP N 8 2
OP_DT D 8 WTH N 8 2
BAL N 8 2 Index the required field. The output should be as under
A.B.C BANK. _
BAL
OP DT
WTH
CNO NAME
Q.5 Attempt any five [20]
1. Explain While loop with example.
2. Write note on Picture Clause.
3. Explain scatter & gather command.
4. Explain differences between INDEX & SORT.
5. Discuss Procedures with example.
6. Write a note on Define Window.
SP-9414] 2 [31-27/1200]
Attachment: |
Earning: Approval pending. |