MCIS 6203 � Midterm
Page 1
1 Dr. Raj Si n gh Fal l , 2015 M CIS 6203 – M i d t e r m Y our Name NOT ES : At t a c h addi t ional pag e s w i t h y our name in t he upp e r r i ght corn e r, if n ee d e d. Pro v ide y our ans w e r for e a c h qu e st i on in t he spa c e pro v ided. M u l t ip l e c h oice q u e st i o n s. Ea c h q u e st i on i s w or t h 2 poi n ts. S e le c t corr ec t a n s w e r. 1. W h a t i s true a bout D a tab a s e s? a ) L ar g e r e posito r y of d a t a b) S h a r e d r e so u r c e , u s e d b y ma n y d e p a rtme n ts and a ppl i ca t i ons c ) Contains sev e r a l d i f f e r e n t r ec o r d t y p e s d) “ knows” a bout r e lationships i n d a ta e ) All of the a bov e . 2. W ho is r e spons i ble f or man a g i n g D a tab a s e s? a ) D a tab a ses a re s e lf m a n a ging b) P ro g r a m m e r c ) D a tab a se a dm i nis t r a tor d) V e ndor 3. Ev e r y D B MS uses a d a ta subl a n g u a g e , whi c h h a s two p a rts a ) C a nd C++ b) S Q L a nd D Q L c ) D D L a ndD M L d) D Q L a nd D C L 4. The proc e ss of r e storing t h e d a ta b a se to a c o r r ec t s t a te a ft e r a fa i l u r e is c a l l e d a ) rollb ac k b) r e c ov e r y c ) r e stor a t i on d) c o r re c t i on 5. A lo g i c a l un i t of w o r k on the d a t a b a se i s a ( n) a ) p r ogr a m b) r e triev a l c ) upd a te d) tr a nsa c t i on 6. An E - R model is a ) c on ce ptual le v e l m od e l b) lo g ic a l l e v e l m od e l c ) p h y sic a l m od e l d) tr a nsa c t i o n a l m od e l 7. An EER m od e l i s a ) not ne e d e d since ER m od e l i s popul a r b ) us e d for a d v a n ce d a ppl ic a t i on d e si g n w h e n c omp l e ten e ss a nd acc u r a c y is n ee d e d. c ) used for tr a di t ional a ppl i ca t i on. d) used b y D B A to mon i tor d a tab a se p e r f o rm a n c e . 8. An E ER m od e l i s g ood c hoi c e f or a ppl ic a t i ons likePage 2
1 Dr. Raj Si n gh Fal l , 2015 M CIS 6203 – M i d t e r m Y our Name NOT ES : At t a c h addi t ional pag e s w i t h y our name in t he upp e r r i ght corn e r, if n ee d e d. Pro v ide y our ans w e r for e a c h qu e st i on in t he spa c e pro v ided. M u l t ip l e c h oice q u e st i o n s. Ea c h q u e st i on i s w or t h 2 poi n ts. S e le c t corr ec t a n s w e r. 1. W h a t i s true a bout D a tab a s e s? a ) L ar g e r e posito r y of d a t a b) S h a r e d r e so u r c e , u s e d b y ma n y d e p a rtme n ts and a ppl i ca t i ons c ) Contains sev e r a l d i f f e r e n t r ec o r d t y p e s d) “ knows” a bout r e lationships i n d a ta e ) All of the a bov e . 2. W ho is r e spons i ble f or man a g i n g D a tab a s e s? a ) D a tab a ses a re s e lf m a n a ging b) P ro g r a m m e r c ) D a tab a se a dm i nis t r a tor d) V e ndor 3. Ev e r y D B MS uses a d a ta subl a n g u a g e , whi c h h a s two p a rts a ) C a nd C++ b) S Q L a nd D Q L c ) D D L a ndD M L d) D Q L a nd D C L 4. The proc e ss of r e storing t h e d a ta b a se to a c o r r ec t s t a te a ft e r a fa i l u r e is c a l l e d a ) rollb ac k b) r e c ov e r y c ) r e stor a t i on d) c o r re c t i on 5. A lo g i c a l un i t of w o r k on the d a t a b a se i s a ( n) a ) p r ogr a m b) r e triev a l c ) upd a te d) tr a nsa c t i on 6. An E - R model is a ) c on ce ptual le v e l m od e l b) lo g ic a l l e v e l m od e l c ) p h y sic a l m od e l d) tr a nsa c t i o n a l m od e l 7. An EER m od e l i s a ) not ne e d e d since ER m od e l i s popul a r b ) us e d for a d v a n ce d a ppl ic a t i on d e si g n w h e n c omp l e ten e ss a nd acc u r a c y is n ee d e d. c ) used for tr a di t ional a ppl i ca t i on. d) used b y D B A to mon i tor d a tab a se p e r f o rm a n c e . 8. An E ER m od e l i s g ood c hoi c e f or a ppl ic a t i ons like