Saurastra University 2006 Diploma Computer Engineering Database Management System - Question Paper
SP-5363 Seat No._
*SP-5363*
D. C. S. Examination April / May - 2006 Database Management System
Time : 3 Hours] [Total Marks :
100
10
10
1 () FOXPRO fil [|<fi'l 'ilfl l. [|<fi filH [fi>HL I
Ai
() fil' L : (dHiH)
(1) Foxpro fit Scopes
(2) ifii Risa Ghmml
(/) Hll B>l 'fll : (H d 'i)
(1) Numeric _ ifil ifll ii .
(2) Foxpro fil HimHfil MW <Hlfi__iw
.
(3) _ l>/fll 4MM.fi <> mfil flilS fi/fl m .
' / ' NO Cn no
(4) _ i'flafl llilflfil im iR .
(5) _ iHl al/{Hl Hli fl flilfi. HflHfl delete
(5) fll'ia $ifl<2 lfil fil< am Risa @HaLHfi m .
(7) 1@fl #>l< _ -ill lfli lSl/Sd 'fl
NO* N N
ittHl W'ldfl ifl .
/ \ N N N *\
2 () d 'i <la aiHl dld l'l :
10
(i) Upper ( ) fi ISUPPER ( )
(ii) Clear fi Clear all ( )
(iii) Delete all fi Zap
(iv) Floor ( ) fi Ceiling ( )
(v) Public fi Private (f) Find fi Seek
(e) Goto fi Skip (/) filfil 'il IH d / WAL 10
(i) SORT iHWfil H>laL
(ii) >L> GklflHl Set relation comand inls
(iii) RDBMS fiL
3 () filfil l>/fll HmL (oiH d 'i) 10
(i) SOUNDEX ( )
(ii) SUBSTR ( )
(iii) ROUND ( )
(iv) CMONTH ( )
(v) MOD ( )
(vi) DELETED ( )
(vii) CDOW ( )
(/) IH d 'ifil W/ l'L 10
(i) @....GET iHlid /'lflHl L.
(ii) fi [Ifi dlAd l'L.
(iii) APPEND fi Insert iHW ae ?j. dlAd ?
(iv) EDIT fi Replace iHW ae <a> ?j. dlAd ?
(v) mfil l/{ /' iflAlfil IH d / '[dL TOlAL.
(vi) @.....Prompt HIlM GaflHl l'L.
(vii) HAL dlfll VAW'fil Hlfedl Hlfil l[Hl[di '[0>lL.
4 () filfii His FOXPRO iHiLi <aifi . (ih d 'i) 10
(1) w. 5000 pay dmi HlfllLfii name fi pay y&Rid flm his
(2) Delete His Hli fl dHlH flili 5.Hd flmi His
(3) F3 il His QUIT + carriage return (3'MPl s iflmi His
(4) City dHlH SURAT fil Wifi MUMBAI mi His
(5) 2500 4500fil flLHi pay L> dmi dHlH HlfllLfil Pay &<s$Hl 25% m'lfl flq.l His
(6) MYADD.LBX $l<Hfii &5>Lll [H-s flm <is
(7) mfil siz{ $l<HHi MYFILE.DBF $l<HHi DESIG &SHi clerk L> dm dHlH append flmi His
(1) LOCATE, CONTINUE fi FOUND ( )
(2) Procedure fi Parameter
(3) Define Window.
5 () fil HW vs@fl 'flimdl MARK.DBF $l<HHi Append 10
s o A *\
iflmi His iHlL $lH d>lfl flL.
| ||||||||||||||||||||
SEAT_NO <is [Makifi nil. |
mi
(Digits) <H0l lfi (352 5.Hd iflmi HisfiL 5'LllH ..
SP-5363] 3 [Contd...
(/) filAfii Hil m< d / 'mn 10 (1) ' fil <w visa's yRid fli <ia | ||||||||||||||||||||||||||||||||||||||||||
|
(2)
(3) L-alfl d'a fli dfii dHIH L-alfl '.[&d fli <ia. a.d. fi'a - 24
C\
iSa'a - 1 2 3 4 6 8 12 24
C\
1 (a) Explain field types available in FOXPRO. Write rules 10
to naming a field.
OR
(a) Write notes : (all)
(i) Scopes in Foxpro.
(ii) Default use of ten function keys.
(b) Fill in the blanks : (any five) 10
(i) A numeric field stores maximum_digits.
(ii) A comment line in Foxpro program begins with _symbols.
(iii) The value of_library function is current
record number.
(iv) _sign is modulus operator.
(v) _ command actually deletes marked
records from a database.
(vi) The default extension name used with report format file is__
(vii) The use of_ symbol in a picture string
convert lowercase alphabaet uppercase.
2 (a) Differentiate any five briefly : 10
(i) Upper ( ) and ISUPPER ( )
(ii) Clear and Clear all ( )
(iii) Delete all and Zap-
(iv) Floor ( ) and Ceiling ( )
(v) Public and Private
(f) Find and Seek
(e) Goto and Skip
(b) Explain any two from following : 10
(i) Limitations of a SORT command.
(ii) Set relation comand with suitable example
(iii) Concept of RDBMS.
3 (a) Explain following library functions. 10
(i) SOUNDEX
(ii) SUBSTR
(iii) ROUND
(iv) CMONTH
(v) MOD
(vi) DELETED
(vii) CDOW
(i) Write the syntax of @....GET command.
(ii) Differentiate variable and field.
(iii) What is difference between APPEND and INSERT commands ?
(iv) What is main different between EDIT and REPLACE command.
(v) Mention any two methods to close current database.
(vi) Give an example of @.....Prompt command.
(vii) Explain : Arithmetic of data type data.
4 (a) Write FOXPRO command lines for following : (any five) 10
(1) To display NAMES and PAY of all employees, whose pay is greater than Rs. 5000
(2) To display all marked records for deletion.
(3) To set the use of F3 function key for QUIT + carriage return.
(4) To write SURAT in the city field at the place of all MUMBAI.
(5) To increase 25% pay in pay field of all employes, having pay in the range of 2500 to 4500.
(6) To print labels using MYADD.LBX file.
(7) Append all records from MYFILE.DBF to current database file having clerk in DESIG field.
(1) LOCATE, CONTINUE and FOUND ( )
(2) PROCEDURE and PARAMETER
(3) DEFINE WINDOW.
5 (a) Prepare a command file to append records in MARK. 10
DBF having following structure.
Field name |
Type |
Width |
Remark |
SEAT_NO |
N |
4 | |
NAME |
C |
20 |
Only in uppercase |
MRK |
N |
3 |
Range 0 to 100 |
SEX |
C |
1 |
I-1 O |
Put duplication check for SEAT_NO field.
(a) Write a program to input ten characters and display all 10 alphabates and digits from them on separate line.
(b) Write any two programs from following : 10
(i) To display following output using loop structure
Aa
Bb Cc
Dd Ee Ff
Gg Hh Ii Jj
Kk Ll Mm Nn Oo
Pp Qq Rr Ss Tt Uu
(ii) Write a meaningful program having DO CASE-OTHERWISE-ENDCASE
(iii) To input any integer and find it's all integer dividers. i.e. input - 24
Output - 1 2 3 4 6 8 12 24
SP-5363] 7 [2000 /51-47]
Attachment: |
Earning: Approval pending. |