VF选择题.docx
- 文档编号:4470109
- 上传时间:2022-12-01
- 格式:DOCX
- 页数:14
- 大小:19.28KB
VF选择题.docx
《VF选择题.docx》由会员分享,可在线阅读,更多相关《VF选择题.docx(14页珍藏版)》请在冰豆网上搜索。
VF选择题
-
1.DBMSstandsforCA.DataBaseMarginalSystemB.DirectoryBasedMemoryStandard
C.DataBaseManagementSystemD.DualBusMaskStorage2.Inadatabase,eachrowiscalledasaBA.HorizontaldataB.RecordC.InformationD.Noneofthese3.AlltherowsinatableareCA.SameB.MayormaynotsameC.DifferentD.Allofthese4.WhichofthefollowingaretheelementsofadatabaseDA.DataB.RelationsC.ConstraintandSchemaD.Allofthese5.Whichofthefollowingisaproblemoffilemanagementsystem?
DA.DifficulttoupdateB.LackofdataindependenceC.DataredundancyD.Allofabove6.WhatisthelanguageusedbymostoftheDBMSsforhelpingtheiruserstoaccessdata?
C
A.HighlevellanguageB.SQLC.QueryLanguageD.4GL7.SQLstandsforBA.StandardQualityliteratureB.StructuredqueryLanguageC.StandardQueryLanguageD.StandardQueryLinguistics
9.InalargeDBMSAA.Eachusercan“see”onlyasmallpartoftheentiredatabaseB.EachsubschemacontainseveryfieldinthelogicalschemaC.EachusercanaccesseverysubschemaD.NoneoftheAbove9.DatabaseManagementSystemisa____AA.SoftwareB.HardwareC.BotharetrueD.Noneoftheabove
10.DatabasemanagementsystemsareintendedtoDA.EliminatedataredundancyB.EstablishrelationshipamongrecordsindifferentfilesC.MaintaindataintegrityD.Alloftheabove11.DMLisprovidedforCA.Descriptionoflogicalstructureofdatabase.B.Additionofnewstructuresinthedatabasesystem.C.Manipulation&processingofdatabase.D.Definitionofphysicalstructureofdatabasesystem12.ThehighestlevelinthehierarchyofdataorganizationiscalledBA.DatabankB.DatabaseC.DatafileD.Datarecord13.ThelanguageusedapplicationprogramstorequestdatafromtheDBMSisreferredtoastheAA.DMLB.DDLC.QuerylanguageD.Anyoftheabove
14.InthearchitectureofadatabasesystemexternallevelistheD
A.Physicallevel.B.Logicallevel.C.ConceptuallevelD.Viewlevel.
15.IntheDBMSapproach,applicationprogramsperformtheBA.StoragefunctionB.ProcessingfunctionsC.AccesscontrolD.Alloftheabove
16.ThegoalsofDMBSisto___and____databaseinformation.BA.StoreandsearchB.StoreandretrieveC.QueryandSQLD.Readandwrite
17.Whichofthefollowingdescribesthehigh-levelconceptualstructuringofdata?
CA.DBMSB.SQLC.DatamodelD.E-Rmodel18.Overalldesignofthedatabaseiscalleddatabase___D____
A.ViewB.InstanceC.ModelD.Schema
19.ActualcontentofthedatabaseataparticularmomentiscalledBA.ViewB.InstanceC.ModelD.Schema
20.ThelanguageusedexpressdatabaseschemausingsetofdefinitionsisreferredtoastheB
A.DMLB.DDLC.QuerylanguageD.Anyoftheabove
21.AstatementrequestingretrievalofinformationiscalledCA.TableB.RecordC.QueryD.Instance
22.ApersonwhohasthecentralcontrolofbothdataandprogramsiscalledB
A.DBMB.DBAC.SecurityD.Recorder
23.InanE-RdiagramanentitysetisrepresentbyaAA.Rectangle.B.Ellipse.C.DiamondD.Circle.24.InanE-RdiagramattributesarerepresentedbyC
A.Rectangle.B.Square.C.Ellipse.D.Triangle.
25.InanE-RdiagramrelationshipsarerepresentedbyDA.Rectangle.B.Square.C.Ellipse.D.Diamond.
26.Whichofthefollowingfieldsinastudentfilecanbeusedasaprimarykey?
BA.ClassB.StudentNumberC.GPAD.Major
27.AsetofpossibledatavaluesiscalledDA.Attribute.B.Degree.C.Tuple.D.Domain.
28.____________integrityensuresthateachrowcanbeuniquelyidentifiedanattributecalledtheprimarykeyB
A.DomainB.EntityC.ReferentialD.Noneoftheabove29._____keyisusuallychosebythedatabasedesignerCA.SuperB.CandidateC.PrimaryD.Foreign
30.Minimalsuperkeysarecalled____keysB
A.SuperB.CandidateC.PrimaryD.Foreign31.InanE-RdiagrammultivaluedattributerepresentedbyCA.SquareB.DiamondC.DoubleellipseD.Rectangle
32.InanE-RdiagramderivedattributerepresentedbyBA.SquareB.DashedellipseC.DoubleellipsesD.Rectangle33.InanE-RdiagramweakentitysetrepresentedbyAA.DoublerectangleB.DashedellipseC.DoubleellipsesD.Doublediamond34.ArowoftableinrelationalmodelterminologyisclassifiedasDA.RangeB.DomainC.RelationD.Tuple35.ThecolumnheaderoftableinrelationalmodelterminologyisclassifiedasAA.AttributeB.TablestarterC.TableenderD.Entitydomain
36.ThebasicoperationsthatcanbeperformedonrelationsareD
A.DeletionB.InsertionC.ModificationD.Allofabove37.Inrelationalmodelterminology,thetableisconsideredasCA.RangeB.DomainC.RelationD.Tuple
38.TheformatordatatypemustbespecifiedforDA.TableB.EntityC.RangeD.Domain39.ThecardinalityinrelationaldatamodelisconsideredasAA.TotalnumberofvaluesB.LimitednumberofvaluesC.TwonumbersfromsetD.Threenumbersfromset40.SelectoperationinrelationalmodelisdenotedbyDA.ΠB.ρC.xD.?
41.ProjectoperationinrelationalmodelisdenotedbyAA.ΠB.ρC.xD.?
42.Whichisnotafunctionofaggregatefunction?
C
A.CountB.AvgC.CreateD.Max
43.WhatdoesSQLstandfor?
C
A.StrongQuestionLanguageB.StructuredQuestionLanguageC.StructuredQueryLanguageD.ShandongQingdaoLanguage
44.WhichSQLstatementisusedtoextractdatafromadatabase?
C
A.GET
B.EXTRACT
C.SELECT
D.QUERY
45.WhichSQLstatementisusedtoupdatedatainadatabase?
A
A.UPDATE
B.INSERT
C.MODIFY
D.SAVE
46.WhichSQLstatementisusedtodeletedatafromadatabase?
B
A.TRUNCATE
B.DELETE
C.UPDATE
D.REMOVE
47.WhichSQLstatementisusedtoinsertnewdatainadatabase?
C
A.ADD
B.UPDATE
C.INSERT
D.NEW
48.WithSQL,howdoyouselectacolumnnamed“FirstName”fromatablenamed“Persons”?
B
A.EXTRACTFirstNameFROMPersons
B.SELECTFirstNameFROMPersons
C.SELECTPersons.FirstName
D.CHOOSEFirstNameFROMPersons
49.WithSQL,howdoyouselectallthecolumnsfromatablenamed“Persons”?
D
A.SELECT[all]FROMPersons
B.SELECTAllPersons
C.SELECT*.Persons
D.SELECT*FROMPersons
50.WithSQL,howdoyouselectalltherecordsfromatablenamed“Persons”wherethevalueofthecolumn“FirstName”is“Peter”?
D
A.SELECT[all]FROMPersonsWHEREFirstName=‘Peter’B.SELECT*FROMPersonsWHEREFirstNameLIKE‘Peter’
C.SELECT[all]FROMPersonsWHEREFirstNameLIKE‘Peter’
D.SELECT*FROMPersonsWHEREFirstName=‘Peter’
51.WithSQL,howdoyouselectalltherecordsfromatablenamed"Persons"wherethevalueofthecolumn"FirstName"startswithan"a"?
D
A.SELECT*FROMPersonsWHEREFirstName='%a%'
B.SELECT*FROMPersonsWHEREFirstNameLIKE'%a'
C.SELECT*FROMPersonsWHEREFirstName='a'
D.SELECT*FROMPersonsWHEREFirstNameLIKE'a%'
52.TheORoperatordisplaysarecordifANYconditionslistedaretrue.TheANDoperatordisplaysarecordifALLoftheconditionslistedaretrueA
A.True
B.False
53.WithSQL,howdoyouselectalltherecordsfromatablenamed"Persons"wherethe"FirstName"is"Peter"andthe"LastName"is"Jackson"?
B
A.SELECT*FROMPersonsWHEREFirstNameLIKE'Peter'ANDLastNameLIKE'Jackson‘
B.SELECT*FROMPersonsWHEREFirstName='Peter'ANDLastName='Jackson‘
C.SELECTFirstName='Peter',LastName='Jackson'FROMPersons
54.WithSQL,howdoyouselectalltherecordsfromatablenamed"Persons"wherethe"LastName"isalphabeticallybetween(andincluding)"Hansen"and"Pettersen"?
B
A.SELECTLastName>'Hansen'ANDLastName<'Pettersen'FROMPersons
B.SELECT*FROMPersonsWHERELastNameBETWEEN'Hansen'AND'Pettersen'
C.SELECT*FROMPersonsWHERELastName>'Hansen'ANDLastName<'Pettersen'
55.WhichSQLstatementisusedtoreturnonlydifferentvalues?
D
A.SELECTUNIQUE
B.SELECTINDENTITY
C.SELECTDIFFERENT
D.SELECTDISTINCT
56.WhichSQLkeywordisusedtosorttheresult-set?
C
A.SORTBY
B.ORDER
C.ORDERBY
D.SORT
57.WithSQL,howcanyoureturnalltherecordsfromatablenamed"Persons"sorted
descendingby"FirstName"?
B
A.SELECT*FROMPersonsSORTBY'FirstName'DESC
B.SELECT*FROMPersonsORDERBYFirstNameDESCC.SELECT*FROMPersonsORDERFirstNameDESCD.SELECT*FROMPersonsSORT'FirstName'DESC
58.WithSQL,howcanyouinsertanewrecordintothe"Persons"table?
A
A.INSERTINTOPersonsVALUES('Jimmy','Jackson')
B.INSERT('Jimmy','Jackson')INTOPersons
C.INSERTVALUES('Jimmy','Jackson')INTOPersons
60.Howcanyouchange"Hansen"into"Nilsen"inthe"LastName"columninthePersonstable?
B
A.UPDATEPersonsSETLastName='Hansen'INTOLastName='Nilsen'
B.UPDATEPersonsSETLastName='Nilsen'WHERELastName='Hansen'
C.MODIFYPersonsSETLastName='Hansen'INTOLastName='Nilsen
D.MODIFYPersonsSETLastName='Nilsen'WHERELastName='Hansen'
61.WithSQL,howcanyoudeletetherecordswherethe"FirstName"is"Peter"inthePersonsTable?
A
A.DELETEFROMPersonsWHEREFirstName='Peter'
B.DELETEROWFirstName='Peter'FROMPersons
C.DELETEFirstName='Peter'FROMPersons
62.WithSQL,howcanyoureturnthenumberofrecordsinthe"Persons"table?
B
A.SELECTCOLUMNS()FROMPersonsB.SELECTCOUNT(*)FROMPersons
C.SELECTCOLUMNS(*)FROMPersons
D.SELECTCOUNT()FROMPersons
63.Givenanemployeestableasshown.Whatvaluewillselectcount(*)fromemployeesreturn?
C
A.1
B.2
C.3
D.Noneoftheabove
64.TheresultofaSELECTstatementcancontainduplicaterows.A
A.True
B.False
65.Sometimestheexpression"selectcount(*)"willreturnfewerrowsthantheexpression"selectcount(value)".B
A.True
B.False
66.Whattypeoflockwilldenyusersanyaccesstoatable?
C
A.EXPLICIT
B.IMPLICIT
C.EXCLUS
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- VF 选择题