SSD7选择题题库完美版Word格式文档下载.docx
- 文档编号:20290267
- 上传时间:2023-01-21
- 格式:DOCX
- 页数:60
- 大小:35.17KB
SSD7选择题题库完美版Word格式文档下载.docx
《SSD7选择题题库完美版Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《SSD7选择题题库完美版Word格式文档下载.docx(60页珍藏版)》请在冰豆网上搜索。
(b)Ionly
(c)IandIIonly
(d)IIonly
Correctansweris(b)
Yourscoreonthisquestionis:
14.29
Feedback:
Databasereferstojustthedata
----------------------------------------------------------------------
2.
Inadatabasesystem,whoseresponsibilityisittoprovidedataconsistency?
(a)thedatabaseadministrator'
s
(b)theuser'
(c)theapplicationprogrammer'
(d)theDBMS'
s
Correctansweris(d)
3.
AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesamecomponentsmustbeincludedinadatabasemanagementsystem?
Acollectionofprogramsmustbeincludedthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedata.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomains,suchasinalibraryinformationsystem.
Acollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.
(a)IIandIIIonly
(b)IIonly
(c)Ionly
(d)I,II,andIII
ADBMSreferstojustthesetofgeneral-purposeprogramstocontroldata.
4.
AnE-Commercedatabasecontainsdataaboutcustomers,products,orders,systemresponsetimes,etc.WhichofthefollowingcanbespecifiedasintegrityconstraintsinanE-Commercedatabasesystem?
NotwoproductscanhavethesameproductID.
TheDBMSresponsetimeforallWebrequestsshouldbeatmost2seconds.
Acustomerordercannothavemorethanoneshippingaddress.
(a)Ionly
(b)IandIIonly
(c)IandIIIonly
Correctansweris(c)
TheconstraintsI,IIandIIIspecifytheapplicationsemanticsofthedatacapturedintheE-Commercedatabase.ConstraintIII,althoughitseemscontrarytocommonsense,isnotsomethingthatcanbeprohibitedbytheDBMSbecausetheDBMSisgeneralpurpose.TheresponsetimeoftheDBMScannotbeenforcedbytheDBMS.Itdependsonfactorssuchtheprocessorspeed,memoryavailable,etc.
5.
AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesesamecomponentswillconstituteadatabasesystem?
Acollectionofprogramsthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedataconstitutesadatabasesystem.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomainssuchasinalibraryinformationsystem.
Acollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem,constitutesadatabasesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.
(a)IandIIonly
(c)IIonly
Adatabasesystemincludesthedata,theDBMS,andtheapplication-specificprogramsthatoperateonthatdata.
6.
Adatabaseisneededforwhichofthefollowingapplicationscenarios?
I.Avideostorethatneedstokeeptrackofdataaboutmembers,aboutvideoscarriedbythestore,aboutvideosrentedbymembers,aswellasdataconcerningborrow-date,return-date,andpaymentinformation.
II.Inthehumanresourcesdepartmentofacompany,informationaboutemployees,theirtitles,theirsalariesandsickdays,andaboutvacationdaystakenbyeachemployee.
III.Acomputer-simulatedvideogamewhichneedstocalculateanddisplay,thephysical(x,y)locationofeachactorinthegame,thespeedwithwhichtheyaremovingatthecurrentinstant,thedirectioninwhichtheyaremoving,theactiontheyareperforming,theangleatwhichthegame-playerisviewingthescene.
(b)IandIIIonly
(c)I,II,andIII
(d)Ionly
(c)Unrelateddatasuchassitedowntimes,priceofgoods,employees,etcdonotconstituteadatabase.
7.
Thephysicalstoragestructurewillbe_____totheapplicationprogrammerinadatabaseapproach,andwillbe_____totheapplicationprogrammerinafilesystemapproach.
(a)hidden,hidden
(b)visible,visible
(c)hidden,visible
(d)visible,hidden
---------------------------------------------------------------------
MultipleChoice2
1.
Thecardinalityofatableisthenumberof_____inthetable.
(a)columns
(b)keys
(c)rows
(d)foreignkeys
Thedegreeofatableisthenumberof_____inthetable.
(a)foreignkeys
(b)columns
(d)keys
10.00
4.
Thearity元数ofatableisthenumberof_____inthetable.
(a)rows
(b)foreignkeys
(c)columns
--------------------------------------------------------------------------------
Whatinformationisnecessarywhenspecifyingthestructureofatable?
(a)thenameofthetable,thenamesofthetable'
sattributes,thedatatypesofattributes,andtheformatsofattributes
(b)thenameofthetableandthenamesofthetable'
sattributes
(c)thenameofthetableandtheamountofstoragespacetobeallocatedtothetable
(d)thenameofthetable,thenamesofthetable'
sattributes,thedatatypesofthetable'
sattributes,theformatsofthetable'
sattributes,andthemaximumnumberofrowsthatthetablecanhave
Ajoinoperationjoins_____tablesinto_____.
(a)three,one
(b)two,one
(c)four,two
(d)three,two
WhichofthefollowingSQLstatementscanbeusedtoremovearowfromatable?
(a)REMOVE
(b)ERASE
(c)DESTROY
(d)DELETE
8.
WhichofthefollowingSQLstatementscanbeusedtomodifyjustonerow(outofmanyrows)inatable?
(a)CHANGE
(b)ALTER
(c)MODIFY
(d)UPDATE
9.
WhichofthefollowingSQLstatementscanbeusedtoaddarowtoatable?
(a)CREATE
(b)APPEND
(c)INSERT
(d)ADD
DMLisusedto
(a)manipulatethestructureofdatabaseapplications.
(b)specifythestructureofadatabase.
(c)add/modify/deletedatainthedatabase.
(d)addanddeletetables.
DDLisusedto
(a)definethestructureofdatabaseapplications.
(c)accessthecontentsoftables.
(d)addcontentstotables.
WhichofthefollowingSQLstatementscanbeusedtocreatearelationaltable?
(a)APPEND
(b)INSERT
(c)ADD
(d)CREATE
10.
Thetermquerybyexamplerefersto
(a)aqueryforSQLexamples
(b)exampleSQLqueriesprovidedbyotherusersthatcanbemodifiedtosuitcurrentneeds
(c)avisualquerylanguagedevelopedbyIBM
(d)exampleSQLqueriesprovidedbytheDBMSthatuserscanmodifytosuittheircurrentneeds
TheforeignkeyinatableT1_____thesame_____asthecorrespondingprimarykeyintableT2.
musthave,name
neednothave,name
musthave,domain
(a)
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SSD7 选择题 题库 完美
![提示](https://static.bdocx.com/images/bang_tan.gif)