SSD7选择题题库完美版.docx
- 文档编号:7189440
- 上传时间:2023-01-21
- 格式:DOCX
- 页数:60
- 大小:35.17KB
SSD7选择题题库完美版.docx
《SSD7选择题题库完美版.docx》由会员分享,可在线阅读,更多相关《SSD7选择题题库完美版.docx(60页珍藏版)》请在冰豆网上搜索。
SSD7选择题题库完美版
alternatekeys
Aweakentitytypeimpliesa
(a)relationshipwithtotalparticipationconstraint
(b)weakrelationshiptype
(c)relationshipwithpartialparticipationconstraint
(d)strongrelationshiptype
Correctansweris(a)
Multiple-ChoiceQuiz1
1.AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesesamecomponentsmustbeincludedinadatabase?
Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.
Adatabasemustincludeacollectionofprogramsthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedata.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomains.
Adatabasemustincludeacollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.
(a)I,II,andIII
(b)Ionly
(c)IandIIonly
(d)IIonly
Correctansweris(b)
Yourscoreonthisquestionis:
14.29
Feedback:
Databasereferstojustthedata
----------------------------------------------------------------------
2.
Inadatabasesystem,whoseresponsibilityisittoprovidedataconsistency?
(a)thedatabaseadministrator's
(b)theuser's
(c)theapplicationprogrammer's
(d)theDBMS's
Correctansweris(d)
----------------------------------------------------------------------
3.
AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesamecomponentsmustbeincludedinadatabasemanagementsystem?
Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.
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
Correctansweris(b)
Feedback:
ADBMSreferstojustthesetofgeneral-purposeprogramstocontroldata.
----------------------------------------------------------------------
4.
AnE-Commercedatabasecontainsdataaboutcustomers,products,orders,systemresponsetimes,etc.WhichofthefollowingcanbespecifiedasintegrityconstraintsinanE-Commercedatabasesystem?
NotwoproductscanhavethesameproductID.
TheDBMSresponsetimeforallWebrequestsshouldbeatmost2seconds.
Acustomerordercannothavemorethanoneshippingaddress.
(a)Ionly
(b)IandIIonly
(c)IandIIIonly
(d)I,II,andIII
Correctansweris(c)
Feedback:
TheconstraintsI,IIandIIIspecifytheapplicationsemanticsofthedatacapturedintheE-Commercedatabase.ConstraintIII,althoughitseemscontrarytocommonsense,isnotsomethingthatcanbeprohibitedbytheDBMSbecausetheDBMSisgeneralpurpose.TheresponsetimeoftheDBMScannotbeenforcedbytheDBMS.Itdependsonfactorssuchtheprocessorspeed,memoryavailable,etc.
----------------------------------------------------------------------
5.
AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesesamecomponentswillconstituteadatabasesystem?
Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.
Acollectionofprogramsthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedataconstitutesadatabasesystem.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomainssuchasinalibraryinformationsystem.
Acollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem,constitutesadatabasesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.
(a)IandIIonly
(b)Ionly
(c)IIonly
(d)I,II,andIII
Correctansweris(d)
Feedback:
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.
(a)IandIIonly
(b)IandIIIonly
(c)I,II,andIII
(d)Ionly
Correctansweris(a)
Feedback:
(c)Unrelateddatasuchassitedowntimes,priceofgoods,employees,etcdonotconstituteadatabase.
----------------------------------------------------------------------
7.
Thephysicalstoragestructurewillbe_____totheapplicationprogrammerinadatabaseapproach,andwillbe_____totheapplicationprogrammerinafilesystemapproach.
(a)hidden,hidden
(b)visible,visible
(c)hidden,visible
(d)visible,hidden
Correctansweris(c)
---------------------------------------------------------------------
MultipleChoice2
1.
Thecardinalityofatableisthenumberof_____inthetable.
(a)columns
(b)keys
(c)rows
(d)foreignkeys
Correctansweris(c)
----------------------------------------------------------------------
2.
Thedegreeofatableisthenumberof_____inthetable.
(a)foreignkeys
(b)columns
(c)rows
(d)keys
Correctansweris(b)
Yourscoreonthisquestionis:
10.00
4.
Thearity元数ofatableisthenumberof_____inthetable.
(a)rows
(b)foreignkeys
(c)columns
(d)keys
Correctansweris(c)
--------------------------------------------------------------------------------
3.
Whatinformationisnecessarywhenspecifyingthestructureofatable?
(a)thenameofthetable,thenamesofthetable'sattributes,thedatatypesofattributes,andtheformatsofattributes
(b)thenameofthetableandthenamesofthetable'sattributes
(c)thenameofthetableandtheamountofstoragespacetobeallocatedtothetable
(d)thenameofthetable,thenamesofthetable'sattributes,thedatatypesofthetable'sattributes,theformatsofthetable'sattributes,andthemaximumnumberofrowsthatthetablecanhave
Correctansweris(a)
Yourscoreonthisquestionis:
10.00
--------------------------------------------------------------------------------
5.
Ajoinoperationjoins_____tablesinto_____.
(a)three,one
(b)two,one
(c)four,two
(d)three,two
Correctansweris(b)
Yourscoreonthisquestionis:
10.00
--------------------------------------------------------------------------------
6.
WhichofthefollowingSQLstatementscanbeusedtoremovearowfromatable?
(a)REMOVE
(b)ERASE
(c)DESTROY
(d)DELETE
Correctansweris(d)
--------------------------------------------------------------------------------
8.
WhichofthefollowingSQLstatementscanbeusedtomodifyjustonerow(outofmanyrows)inatable?
(a)CHANGE
(b)ALTER
(c)MODIFY
(d)UPDATE
Correctansweris(d)
Yourscoreonthisquestionis:
10.00
--------------------------------------------------------------------------------
9.
WhichofthefollowingSQLstatementscanbeusedtoaddarowtoatable?
(a)CREATE
(b)APPEND
(c)INSERT
(d)ADD
Correctansweris(c)
Yourscoreonthisquestionis:
10.00
--------------------------------------------------------------------------------
7.
DMLisusedto
(a)manipulatethestructureofdatabaseapplications.
(b)specifythestructureofadatabase.
(c)add/modify/deletedatainthedatabase.
(d)addanddeletetables.
Correctansweris(c)
--------------------------------------------------------------------------------
8.
DDLisusedto
(a)definethestructureofdatabaseapplications.
(b)specifythestructureofadatabase.
(c)accessthecontentsoftables.
(d)addcontentstotables.
Correctansweris(b)
--------------------------------------------------------------------------------
9.
WhichofthefollowingSQLstatementscanbeusedtocreatearelationaltable?
(a)APPEND
(b)INSERT
(c)ADD
(d)CREATE
Correctansweris(d)
Yourscoreonthisquestionis:
10.00
--------------------------------------------------------------------------------
10.
Thetermquerybyexamplerefersto
(a)aqueryforSQLexamples
(b)exampleSQLqueriesprovidedbyotherusersthatcanbemodifiedtosuitcurrentneeds
(c)avisualquerylanguagedevelopedbyIBM
(d)exampleSQLqueriesprovidedbytheDBMSthatuserscanmodifytosuittheircurrentneeds
Correctansweris(c)
Yourscoreonthisquestionis:
10.00
1.
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)