MCIS 6203 � Midterm

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

MCIS 6203 � Midterm - Page 1 preview image

Loading page ...

1Dr.RajSinghFall, 2015MCIS6203MidtermYourNameNOTES: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!

Study Now!

XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Related Documents

View all