Skip to content
Solved Assignments

MCIS 6203 � Midterm

A solved midterm exam for MCIS 6203 covering computing concepts.

Preview 2 of 6 pages

See the first 2 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    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

  2. Page 2

4 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.