Test Bank For Database Concepts 10th Edition All Chapters - 9780137913817.pdf

,DatabasedConcepts,d6ed(Kroenke/Auer)
AppendixdAd MicrosoftdSQLdServerd2012dExpressdEdition

1) SQLdServerd2012dExpressdrequiresdthatdthed.NETdFrameworkdversiond2.0dbedinstalled.d
Answer:d FALSE
Diff:d1 PagedRef:dA-4

2) ThedMicrosoftdSQLdServerdManagementdStudiodisdincludeddwithdMicrosoftdSQLdServerd2012d
ExpressdAdvanced.
Answer:d TRUE
Diff:d1 PagedRef:dA-4

3) AndimportantdreasondfordusingdSQLdServerd2012dExpressdisdthatditdhasdfulldSQLdcapabilities.d
Answer:d TRUE
Diff:d1 PagedRef:dA-4

4) TodstartdworkingdwithdSQLdServerd2012dExpress,dusedthedcommanddStartd|dAlldProgramsd|d
MicrosoftdSQLdServerd2012d|dSQLdServerdmanagementdStudiodExpress.
Answer:d TRUE
Diff:d1 PagedRef:dA-5

5) UsersdlogdintodSQLdServerd2012dExpressdusingdthedConnectdtodServerddialogdbox.d
Answer:d TRUE
Diff:d1 PagedRef:dA-5

6) SQLdServerd2012dusesdDBMSdauthenticationdbyddefault.d
Answer:d FALSE
Diff:d2 PagedRef:dA-5

7) DatabasedobjectsdareddisplayeddindthedObjectdExplorerdwindowdindthedSQLdServerdManagementd
Studio.
Answer:d TRUE
Diff:d1 PagedRef:dA-5

8) AdnewdSQLdServerddatabasedisdcreateddusingdthedNewdDatabaseddialogdbox.d
Answer:d TRUE
Diff:d2 PagedRef:dA-6-A-8

9) SQLdstatementsdcandbedrundindividuallydordasdpartdofdadrelateddgroupdofdSQLdstatementsdknownda
sdadscript.
Answer:d TRUE
Diff:d1 PagedRef:dA-8

10) TodrundandSQLdscript,dclickdthedExecutedbuttondondthedQuerydToolbar.d
Answer:d FALSE
Diff:d1 PagedRef:dA-10


1
Copyrightd©d2013dPearsondEducation,dInc.dPublishingdasdPrenticedHall

,11) TodcreatedadnewdSQLdquery,dclickdthedNewdQuerydbutton.d
Answer:d TRUE
Diff:d1 PagedRef:dA-11

12) SQLdquerydresultsdareddisplayeddindadtabbeddResultsetdwindow.d
Answer:d FALSE
Diff:d1 PagedRef:dA-12

13) SQLdServerd2012dExpressdrequiresdthedpriordordconcurrentdinstallationdof:
A) thed.NETdFrameworkdversiond2.0.
B) thed.NETdFrameworkdversiond3.0.
C) thed.NETdFrameworkdversiond4.0.
D) thed.NETdFrameworkdversiond3.5dSP1.
E) Nonedofdthedaboved—
dthed.NETdFrameworkdisdnotdrequired.dAnswer:d C

Diff:d1 PagedRef:dA-4

14) MicrosoftdSQLdServerd2012dExpressdAdvanceddincludes:
A) SQLdServerd2012dManagementdStudio.
B) SQLdServerd2012dReportingdServices.
C) WindowsdInstallerd4.5.
D) BothdAdanddB
E) Alldofdthedaboved
Answer:d D
Diff:d2 PagedRef:dA-4

15) LoggingdintodthedSQLdServerd2012dExpressdDBMSdisddonedusing:
A) thedConnectdtodServerdcommand.
B) thedConnectdtodServerddialogdbox.
C) thedConnectdtodSQLdServerdInstancedcommand.
D) thedConnectdtodSQLdServerdInstanceddialogdbox.
E) Nonedofdthedabovedisdcorrect.d
Answer:d B
Diff:d2 PagedRef:dA-5

16) DBMSdobjectsdareddisplayed:
A) indthedNavigationdPane.
B) indthedObjectdBrowser.
C) indthedtabbedddatabasedwindow.
D) indthedtabbedddocumentdwindow.
E) indthedcommanddtab.
Answer:d B
Diff:d2 PagedRef:dA-6-A-7




2
Copyrightd©d2013dPearsondEducation,dInc.dPublishingdasdPrenticedHall

, 17) AdnewdSQLdServerddatabasedisdcreateddusing:
A) thedNewdDatabaseddialogdbox.
B) thedCreatedDatabasedcommand.
C) thedCreatedNewdSchemaddialogdbox.
D) thedCreatedSchemadcommand.
E) thedNewdObjectddialogdbox.d
Answer:d A
Diff:d2 PagedRef:dA-6

18) SQLdstatementsdcandbedrundindividuallydordasdpartdofdadrelateddgroupdofdSQLdstatementsdk
nowndasda(n):
A) Result.
B) Resultset.
C) Script.
D) Scriptset.
E) Commandset.
dAnswer:d C

Diff:d1 PagedRef:dA-8

19) TodrundandSQLdscriptdordSQLdcommanddindSQLdServerd2012:
A) clickdthedExecutedbuttondondthedQuerydToolbar.
B) clickdthedExecutedbuttondondthedBrowserdToolbar.
C) clickdthedRundbuttondondthedQuerydToolbar.
D) clickdthedRundbuttondondthedBrowserdToolbar.
E) clickdthedResultsdbuttondondthedQuerydToolbar.d
Answer:d A
Diff:d2 PagedRef:dA-10

20) SQLdquerydresultsdareddisplayed:
A) indadtabbeddResultsetdwindow.
B) indadtabbeddResultsdwindow.
C) indadtabbeddDocumentdwindow.
D) indadtabbeddMessagesdwindow.
E) indadtabbeddFinisheddwindow.d
Answer:d B
Diff:d2 PagedRef:dA-12

21) WhendSQLdServerd2012disdinstalled,dthedSQLdServerd2012dODBCdclientdis:
A) installeddautomaticallydasdpartdofdthedinstallation.
B) installeddmanuallydasdadseparatedpartdofdthedinstallationdprocess.
C) notdinstalled,danddmustdbeddownloadeddanddinstalleddmanually.
D) notdinstalleddbecausedtheredisdnodODBCdclientdfordSQLdServerd2012.
E) EitherdAdordBd
Answer:d A
Diff:d2 PagedRef:dA-12



3
Copyrightd©d2013dPearsondEducation,dInc.dPublishingdasdPrenticedHall