1. Home
  2. Chapters
  3. Computer Science
Class - 11 :: Chapter 5

ਡਾਟਾਬੇਸ ਮੈਨੇਜਮੈਂਟ ਸਿਸਟਮ

Start Presentation
ਸਹੀ ਗਲਤ

1) v~K-v~K ividAwrQIAW dy sbMiDq irkwrf dy iek~T ƒ fwtwbys mMinAw jw skdw hY[

au`qr : shI

2) fwtwbys fwtw ƒ muV pRwpq krn (retireve) sMimilq krn (insert) Aqy imtwaux leI (delete) vriqAw jWdw hY[

au`qr : shI

3) fI.bI.AYm.AYs ie~k kMipaUtrweIzf irkwrf kIipMg isstm hY[

au`qr : shI

4) fwtwbys mYnyjmYNt isstm ie~k hwrfvyAr hY[

au`qr : Zlq

5) fwtwbys mYnyjmYNt isstm fwtwbys ƒ mYnyj krn leI iesqymwl kIqw jWdw hY[

au`qr : shI
ਬਹੁਤ ਛੋਟੇ ਪ੍ਰਸ਼ਨ

1) iksy ivSyS AweItm dI sMbMiDq jwxkwrI ƒ kI ikhw jw skdw hY?

au`qr : irkwrf

2) PweIlW jW tybls dy BMfwr ƒ kI ikhw jWdw hY?

au`qr : fwtwbys

3) fI.bI.AYm.AYs. dw kI ArQ hY?

au`qr : fwtwbys mYnyjmYNt isstm

4) jo Asl iv~c fwtwbys dy ifzweIinMg ih~sy qy kMm krdy hn, auhnW lokW dy smUh ƒ kI ikhw jWdw hY?

au`qr : fwtwbys ifzweInr

5) DBMS ƒ kwiem r~Kx Aqy fwtwbys dy pRbMDn krn leI iks dI ijMmyvwrI huMdI hY?

au`qr : fwtwbys AYfmInIstRytr
ਛੋਟੇ ਪ੍ਰਸ਼ਨ

1) fI.bI.AYm.AYs. (DBMS) vrikMg bwry dso[

au`qr : DBMS dw pUrw nW fwtwbys mYnyjmYNt isstm hY[ ieh Asl iv~c iek kMipautrweIzf irkwrf r~Kx vwlw isstm huMdw hY[ ie~k DBMS fwtw ƒ ies qrIky nwl stor krdw hY ijs nwl jwxkwrI pRwpq krnw, fwtw ivc qbdIlI krnw Aqy sUcnw iqAwr krnw sOKw hovy[ ie~k DBMS dy keI v~Kry-v~Kry XUzrs huMdy hn Aqy iehnW XUzr dy fwtwbys aupr kMm krn dy AiDkwr vI v~Kry-v~Kry ho skdy hn[ ieh v~K-v~K XUzrz fwtwbys ƒ v~K v~K audySW leI vrqdy hn[ audwhrx leI: ku~J XUzrs fwtw pRwpq krdy hn Aqy kuJ iesdw bY`k-Ap lYNdy hn[

2) AYNf XUzr (END USERS) qoN quhwfw kI Bwv hY?

au`qr : ie~k DBMS dy keI v~Kry-v~Kry XUzrs huMdy hn Aqy iehnW XUzr dy fwtwbys aupr kMm krn dy AiDkwr vI v~Kry-v~Kry ho skdy hn[ AYNf XUzr (END USERS) DBMS dy XUzrs dI hI iek iksm huMdI hY[ ies ivc auh XUzrs Swml huMdy hn jo Asl iv~c DBMS dy lwB pRwpq krdy hn[ AYNf XUzr swDwrx drSkW qoN lY ky kwrobwrI ivSlySk vrgy sUJvwn XUzrs ho skdy hn[

3) fI.bI.AYm.AYs. ivc 2-twier fI.bI.AYm.AYs. AwrkItYkcr bwry dso[

au`qr : DBMS v~K iksmW dIAW AwrkItYkcrW vwly huMdy hn: ijvy ik 1-twier AwrkItYkcr, 2-tweIr AYrkItYkct, 3-tweIr AwrkItYkcr Awid[ DBMS dI 2-twier AwrkItYkcr iv~c XUzrs Aqy DBMS dy ivckwr ie~k AYplIkySn lyAr Swml kIqI jWdI hY[ ieh lyAr XUzrs dI bynqI (request) ƒ fwtwbys mYnyjmYNt isstm ƒ Byjx leI izMmyvwr huMdI hY Aqy iPr DBMS qoN imly jvwb (response) ƒ XUzrs q~k phuMcwaux dw kMm krdI hY[

4) klwauf fwtwbys kI huMdw hY?

au`qr : klwauf fwtwbys auh fwtwbys hY jo Awm qOr 'qy klwauf kMipaUitMg plytPwrm' qy cldw hY[ klwaUf fwtwbys ƒ vrqx leI ieMtrnYt dI vrqoN kIqI jWdI hY[ klwauf fwtwbys srivs do qrIikAW duAwrw pRwpq kIqI jw skdI hY:
  1. pihlI ivDI iv~c, ie~k sMsQw klwauf srivs pRovweIfr qoN vrcuAl mSIn spys (Virtual Machine Space) KrIddw hY, Aqy fytwbys klwauf qy stor krdw hY[ sMsQw duAwrw fytwbys ƒ kMtrol krn leI IT stwP dI vrqoN krdI hY[ ies isstm ivc sMsQw hI fwtwbys dI ingrwnI Aqy pRbMDn leI izMmyvwr huMdI hY[
  2. dUsrI ivDI ivc, sMsQw klwaUf srivs pRovweIfr nwl PIs ADwirq iek iekrwrnwmw krdI hY[ ies ivc fytwbys klwauf-srvr aupr hI stor rihMdw hY prMqU klwauf srivs pRovweIfr v~loN fwtwbys ƒ iek srivs dy qor (Database as a service-DBaaS) qy vrqx dI AwigAw idqI jWdI hY[
ਵੱਡੇ ਪ੍ਰਸ਼ਨ

1) fwtwbys mYnyjmYNt isstm dIAW ivSySqwvW dI ivAwiKAw kro[

au`qr : fwtwbys mYnyjmYNt isstm dIAW mu~K ivSySqwvW dw vrnx ies pRkwr hY:

  1. fwty dI irfMfYNsI ƒ Gtwauxw: fwtw dI irfMfYNsI qoN Bwv hY fwtw dI fUplIkysI[ iek PweIl-ADwrq isstm iv~c ieko PweIl dIAW keI kwpIAW fwtw dI fuplIkysI v~l lY jWdIAW hn[ DBMS nwl iesdI rokQwm kIqI jw skdI hY[
  2. fwtw ƒ SyAr krnw: fwtwbys dy v~Ko-v~Kry XUzrs Awps iv~c fwtw SyAr kr skdy hW[
  3. fwtw ivc ie~kswrqw: iesdw ArQ hY ik fwtwbys ivc fwtw shI Aqy ie~kswr hY[ fwtw dI iekswrqw aus smyN Kqry ivc huMdI hY jdoN fwtw ivc fuplIkysI mojUd hovy[ DBMS fwty dI fuplIkysI ƒ dUr krdI hY ijs kwrn fwtw iekswr rihMdw hY[
  4. fwtw sur~iKAw: isrP AiDkwrq XUzrs (authoirzed users) hI fwtwbys q~k phuMc kr skdy hn[ iehnW XUzrs dI pCwx XUzrs nym (username) Aqy pwsvrf dI vrqoN nwl pRmwixq huMdI hY[
  5. pRweIvysI: fwtwbys isstm ivc ie~k XUzrs isrP aus fwtw ƒ hI dyK/vrq skdw hY ijsdI ausƒ iejwzq huMdI hY[
  6. bYk-Ap Aqy irkvrI: fwtwbys isstm smyN-smyN qy Awpxy Awp fwtw dw bYkAp Aqy irkvrI dw kMm krdw rihMdw hY[

2) fwtwbys mYnyjmYNt isstm dIAW kmIAW bwry dso[

au`qr : fwtwbys mYnyjmYNt isstm dIAW mu~K kmIAW hyT ilKy Anuswr hn:
  1. sY~tAp kImq: DBMS leI loVINdy hwrfvyAr Aqy swPtvyAr leI BwrI mwqrw iv~c invyS dI loV huMdI hY[
  2. fwtwbys jitlqw: fwtwbys isstm dw ifzwien krnw guMJldwr, muSkl Aqy bhuq smW lYx vwlw kMm hY[
  3. qknIkI stwP dI jrUrq: fwtwbys dI vrqoN leI qknIkI stwP dI jrUrq pYNdI hY[fwtwbys dIAW jitlqwvW ƒ sMBwlx leI ifvYlpr, ifzweInr, DBA Aqy AYNf XUzr kol pUrI muhwrq hoxI cwhIdI hY
  4. fwtwbys PylIAr: fwtwbys isstm dI AsPlqw kImqI fwtw dy nukswn dw kwrn bx skdI hY[
  5. pRPwrmYNs (kwrz kuSlqw): Coty sMgTnW leI rvwieqI PweIlW dw isstm bhuq vDIAw sI ikauNik auh Swndwr pRPwrmYNs idMdy hn[ pr DBMS Coty p~Dr dIAW PrmW leI mwVI pRPwrmYNs idMdw hY ikauNik ieh holI kMm krdw hY[

3) fI.bI.AYm.AYs. dy AwrkItYkcr dI ivAwiKAw kro[

au`qr : fwtwbys mYnyjmYNt isstm bhuq swry AMqr-sbMiDq ih~isAW nwl bixAw hY[ DBMS dI AwrkItYkcr ivc ieh inrDwirq kIqw jWdw hY ik iks qrHW iehnW ih~isAW ƒ sMgiTq kIqw jwvy[ ie~k DBMS dw AwrkItYkcr Centralized (swrw fwtw ie~k sQwn qy stor krnw), Decentralized (v~Ko v~Kry sQwnW qy fwtwbys dIAW keI kw~pIAW) jW Hierarchical AwrkItYkcr qy ADwirq ho skdw hY[ AwrkItYkcr dw audyS XUzr-AYplIkySnW Aqy BOiqk-fwtwbys ƒ v~K krnw huMdw hY[ fwtwbys AwrkItYkcr dIAW hyT ilKIAW kuJ iksmW huMdIAW hn:
  1.  1-twier DBMS AwrkItYkcr : ies iv~c fwtwbys XUzrs ƒ fwtw stor krn leI is~Dy qOr 'qy aupl~bD huMdw hY[
  2.  2-twier DBMS AwrkItYkcr : ies AwrkItYkcr iv~c XUzrs Aqy DBMS dy ivckwr ie~k AYplIkySn lyAr Swml kIqI jWdI hY[ ieh lyAr XUzrs dI bynqI (request) ƒ fwtwbys mYnyjmYNt isstm ƒ Byjx leI izMmyvwr huMdI hY Aqy iPr DBMS qoN imly jvwb (response) ƒ XUzrs q~k phuMcwaux dw kMm krdI hY[
  3.  3-twier DBMS AwrkItYkcr : ies AwrkItYkr dI vrqoN Awm qor qy vY~b AYplIkySnW leI kIqI jWdI hY[ 3-twier ArkItYkcr iv~c ie~k vwDU pRYzntySn lyAr Swml kIqI jWdI hY, jo ik AYNf XUzr ƒ DBMS nwl sMprk krn leI ie~k gRwPIkl XUzr ieMtrPys (GUI) pRdwn krdw hY[

4) fwtw bys lweIP sweIkl bwry ivsQwr nwl dso[

au`qr : ie~k swPtvyAr/isstm ifvYlpmYNt lweIP sweIkl mwfl (SDLC) v~K-v~K kwrjW dw ie~k smUh huMdw hY jo ie~k swPtvyAr AYplIkySn ivkisq krn dy kMm ƒ pUrw krn leI pRBwiSq huMdw hY[ iksy vI swPtvyAr/isstm ƒ ivkisq krn dIAW keI pRikirAwvW huMdIAW hn:

  1.  XojnwbMdI (Planning): sm~isAw dw ivSlySn krnw Aqy ausƒ pirBwiSq krnw
  2.  zrUrqW (Requirements): XUzrs dIAW jrUrqW ƒ jwnxw
  3.  ifzwien (Design): fwtwbys dw lwjIkl Aqy PIjIkl ifzweIn iqAwr krnw
  4.  ivkws (Development): ifzweIn Anuswr fwtwbys iqAwr krnw
  5.  lwgU krn (Implementation): fwtwbys isstm ƒ XUzr dy kMipaUtr isstmW ivc ieMstwl krnw
  6.  tYsitMg (Testing): fwtwbys ivc fwtw Br ky ausdI jWc krnw
  7.  ieMstwlySn Aqy dyK-Bwl (Installation and Maintenance): fwtwbys isstm ivc Aw rhIAW sm~isAwvW dy h~l leI jW fwtwbys ivc suDwr krn leI aus ivc bdlwv krnw[

5) fwtwbys dI hweIrwrkI dw cwrt bxwE[

au`qr : s