A solved midterm exam for MCIS 6203 covering computing concepts.
Isaac Ross
Contributor
4.8
40
6 months ago
Preview (2 of 6 Pages)
100%
Purchase to unlock
Page 1
Loading page ...
1Dr.RajSinghFall, 2015MCIS6203–MidtermYourNameNOTES:Attach additionalpageswithyour nameintheupper right corner, ifneeded.Provideyour answer foreach question inthespaceprovided.Multiplechoicequestions.Eachquestionisworth2 points.Select correctanswer.1.Whatis trueabout Databases?a)Largerepositoryof datab)Shared resource, usedbymanydepartments andapplicationsc)Contains several different recordtypesd)“knows”aboutrelationshipsin datae)All of theabove.2.Who is responsibleformanagingDatabases?a)Databasesareself managing b)Programmerc)Databaseadministratord)Vendor3. EveryDBMSuses adatasublanguage,which has two partsa)Cand C++b)SQLandDQLc)DDLandDMLd)DQLand DCL4. Theprocess ofrestoringthedatabasetoacorrect stateafterafailureis calleda)rollbackb)recoveryc)restorationd)correction5. A logical unit ofwork on the databaseis a(n)a) programb) retrievalc)updated)transaction6. AnE-R model isa)conceptual levelmodelb)logicallevelmodelc)physicalmodeld)transactionalmodel7. An EERmodelisa)not needed sinceERmodelis popularb)used foradvancedapplication design whencompletenessandaccuracyisneeded.c)usedfortraditionalapplication.d)usedbyDBA to monitordatabaseperformance.8. AnEERmodelisgoodchoiceforapplications like
Page 2
Preview Mode
This document has 6 pages. Sign in to access the full document!