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 : 100

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 :

(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: saurastra-university-2006-post-graduate-diploma-computer-science--amp--management-25917-1.pdf

Earning:   Approval pending.