Saurastra University 2006 Post Graduate Diploma Computer Science & Management S/SC–2256 : DBMS-FOXPRO For Windows - Question Paper

SQ-2256    Seat No._

iii iiii iiiiii ii iiiiiii iiii

*SQ-2256*

P. G. D. C. A. (Sem. I) Examination April/May - 2006 S/SC-2256 : DBMS-FOXPRO For Windows

[Total Marks : 100

Instructions: (1) All questions are to be attempted.

(2) Each section should be answered in separate main sheets.

SECTION -1

(a)    Differentiate between : (any three)    15

(1)    Procedure and Function

(2)    Locate and Seek

(3)    Recall and Replace

(4)    Edit and Change

(b)    Write a program to generate the following output,    5 for any number inputted :

1

1    2

1    2 3

1    2 3 4

1 2 3 4 5 6 ... n

(n is the number inputted by the user.)

2 (a) Answer the following : (any two)    12

(1)    What is sorting ? Explain with the help of an example.

(2)    Explain, with an example the concept of indexing.

(3)    Explain scatter-gather with an example.

(b) What are reports ? Write steps to generate reports 8 in Foxpro.

SQ-2256]    1    [Contd...

3 Explain the concept of array in Foxpro. Write a program 10 to sort an array of 10 numbers.

SECTION - II

4 (a) Explain the following : (any three)    15

(1) Scan .... Endscan (2) Do...case

(3) Select and List (4) Use

(b) What is DBMS ? Discuss the advantages of storing 7 data in a database instead of a file.

5 Attempt any one : (Assume suitable database)    12

(1) Write a menu-driven program to add and delete records to a table with the following structure :

Team	C	30
Matches	N	3
Won	N	3
Lost	N	3
Tie	N	3
Points	N	3

(2) Write a program to update the data of the above table. Updation should be done based on the following conditions :

Points calculated :

for every game won, points = 4

for every game in a tie, points = 2

Use provide proper validation for the team field while

entering the data, in such a way that the user should

not enter the same team name more than once.

6 Explain the following functions with example : (any eight) 16

All trim ( ) right ( ) lower ( ) floor ( )

[100]

SQ-2256]    2

d by dei    ftp:/    .dooudei

Attachment: saurastra-university-2006-post-graduate-diploma-computer-science--amp--management-25913-1.pdf

Earning:   Approval pending.