Madurai Kamraj University (MKU) 2007 B.Sc Mathematics DMS - Question Paper
DMS
6257/M3C october 2007
Paper XII DATABASE MANAGEMENT SYSTEM
(For those who joined in July 2003 and after)
Time : Three hours Maximum : 100 marks
SECTION A (5 x 8 = 40 marks)
Answer any EIGHT questions.
1. asueb 6)ffiUjrr(G(5Lb QLDiTLlffiejoerr oSldjiflffia.
Explain data Manipulation languages.
2. uujjilana) )L>u6idu QanwrL, s>a;6U6b Qrr@uq
LDrrliflemiu aSl6uifl.
Explain the hierarchical database model.
3. (<>|) <55561160 QUIT0GTT
(cj,) <ffi6Ub 2_pUL| - 6lSl6TTffig.
Explain :
(a) Data item.
(b) Data element.
4. (=sO Qrruirq 6U60 Qrri_iTL)
() aaisb $6mi> - aSlojifl.
Explain:
(a) Relational database
(b) Data field.
5. 6U6U Q(T0uq c3H65)inuiSl05i uujctstt otstst?
What are the uses of database management packages?
6. uiuyru(5lglib 6ul$1 Gn'ijQa) Sierra.
Explain Access path selection.
7. SQL uiusmj earmisrr iSIsji gmpira iSlaDOTrffiffiuuili_ SlamrffiffiaociT
Explain nested queries using SQL.
8. SSrLj5lliJIT<95(6T5ffiir6BT LlL_l)-liJ65)6l) UJfTIT QffUJ LDfrjpib U[TITD&JuSll_d) ufbfgluj l Ull)-&J6!S) a_ilugl.
Create an Employee table and apply the concept of
view.
9. SQL -aSla) jraaftssGrflarr 6uss>ffiffias>6TT erQpgjs.
Write the types of reports in SQL.
10. CREATE L_L_6B)6fTuSl65T UUJ65!UireD6n Write the uses of CREATE command.
11. uiuaffili_fr6rT65)i7 a-p$0ijugj6U - fSlenaa.
Explain authenticating users.
12. Qrr@<*uugj65)60 urbjfj) SIots.
Explain Clustering.
SECTION B (6 x 10 = 60 marks)
Answer any SIX questions.
13. g5ffi6U0) Qir@ui_| LDirliflffieiflasi 6U65>s6&)gtt eSl&Jiflss. Discuss the different types of database models.
14. 6ud> Qrr@utSla) g-jbuL. ah.uj.iu Qffuja>$)iLi_ l5l5rffil65>65Tffi6B6IT Slajlflffiffi.
Explain the database design problems.
15. <56ucb Q[r@uiSl65r ffifl turret (LpoofDuSla) C@a>6b Lonjptb
ujbjfjluj S065)d5 S)6Ulfl.
Explain the concept of EXACT searching and sorting the database.
16. 6uii]$ (SffiiluL) r$rr (gevx_(xpen> Qffiu6buir(5i6ifl65T
6ul1ujldul| Grrui51B6BT6r(Lpi<5.
Write a program file for savings Bank account transaction.
17. ORACLE -a) 2_6ttctt <56U6b eueiDsswm Sl6fT<s@ CHARACTER, NUMBER, DATE.
Explain the data types CHARACTER, NUMBER, DATE in ORACLE.
18. U60 GrrU6V)U UjDjfi) 6fi)eTT@<5.
Explain multiple data files.
19. G&truL] upiDifluL] irijbpib Q&\ug> fSlDipCSeufbjDib uiprft
TTfe .
Explain file maintenance and performance.
20. 5<K<oU6U Qir@Ul3fbn'5T UL_l.UJ6IS)0 UJfriT QffUJO) LDjbpih ceiiprGffT soji) QDffiiurrtcijii) QLorrySlaeiT, SQL 6)S)0jrfr.K<$6TT LDrppLD unri'65)Qju9i_b Ufbf5l 6iSleurfl.
Create a table and applying the concept of DML queries, select, view in SQL.
21. <$Ub QfrgjULSlerr rf3iTQjrr<f)<5ffi an. U|_UJ <06filu965T Explain the types of Database Administration
tools.
22. Clustering Gr5rr<Ka0D a_rfluj s_nijs5rii_0yT oSlcuifl.
Explain the purpose of clustering with suitable example.
|
Attachment: |
| Earning: Approval pending. |
