Saurastra University 2006 Post Graduate Diploma Computer Science & Management DBMS Using FoxPro (New ) - Question Paper
SP-9180 Seat No._
Illlllllllllllllllllll
P.G.D.C.A. (Sem. I) Examination April/May - 2006 DBMS Using FoxPro
(New Course)
[Total Marks : 100Time : 3 Hours]
1 Answer any four from the following : 20
(a) Explain field types in FoxPro
(b) Explain SORT command.
(c) Explain structured compound index file.
(d) Explain any five Date handling function.
(e) Write note on DBMS.
2 (a) Explain multiple database handling in Foxpro. 10 (b) Explain any four function from the following : 10
(i) ROUND ( )
(ii) INKEY ( )
(iii) STORE ( )
(iv) BETWEEN ( )
(v) SUBSTR ( )
3 (a) Explain SCAN - End Scan with suitable example. 10
(b) Explain any four SET command from the following : 10
(i) SET CARRY
(ii) SET FUNCTION
(iii) SET DEVICE
(iv) SET EXACT
(v) SET SAFETY
4 Answer any four from the following : 20
(a) Explain the process to create and generate report from active database file.
[Contd.
(b) Explain about any five file extension used in FoxPro.
(c) Differentiate field and memory variable.
(d) Differentiate LOCATE and SEEK command.
(e) Write a command file to create and handle simple Popup Menu using @... PROMPT command.
5 (a) Prepare a command file to display a test having 25 lines per a screen page, each line gives information about seat no, name of student, total marks and average marks from a STUDENT.DBF having following structure :
Field Name |
Type |
Width |
Seat_No |
N |
4 |
Name |
C |
25 |
P1 |
N |
3 |
P2 |
N |
3 |
P3 |
N |
3 |
(b) Explain the use of following commands :
5
(i) LIST OFF
(ii) DELETE REST
(iii) BROWSE FREEZE NAME
(iv) USE MARKS ALIAS MAIN
(v) STORE { } TO VARIABLE.
SP-9180] 2 [ 300 ]
d by dei ftp:/ .dooudei
Attachment: |
Earning: Approval pending. |