首页
试卷库
试题库
当前位置：
X题卡
>
所有题目
>
题目详情
在SQL的查询语句中，允许出现聚集函数的是（）。
查看本题答案
包含此试题的试卷
中级数据库系统工程师《单项选择》真题及答案
点击查看
你可能感兴趣的试题
SQL语句中子查询指的是
返回单表中数据子集的查询语句
选许多表中字段子集的查询语句
选取单表中字段子集的查询语句
嵌入到另一个查询语句中的查询语句
SQL的聚集函数COUNTSUMAVGMAXMIN不允许出现在查询语句的子句之中
SELECT
HAVING
GROUPBY…HAVING
WHERE
在SQLServer2000中有教师表TeachersTeacherIDNameLeaderID其中
在SQL查询语句中GROUPBY语句用于
选择行条件
对查询进行排序
列表
分组查询
在SQL的查询语句中允许出现聚集函数的是40
SELECT 子句
WHERE 子句
HAVING 短语
SELECT 子句和HAVING 短语
在SQLSELECT语句中*表示查询所有字段
在SQL的查询语句中用于分组查询的语句是
ORDER BY
WHERE
GROUP BY
HAVING
SQLSELECT的查询输出语句中______短语表示将查询结果送到打印机
在sql的查询语句中不能用于分组查询的语句是
groupby
orderby
having
limit
SQL语句中DISTINCT短语的功能是
按要求显示部分查询记录
消除重复出现的查询记录
删除查询结果中符合条件的记录
对查询结果进行排序
SQL的SELECT语句中用于计算平均值查询的函数是【13】用于计数查询的函数是【14】用于求和查询
在SQLServer2000中有教师表TeachersTeacherIDNameLeaderID其中
SQL查询语句中用于记录分组查询的子句是【11】
在SQL语句中DISTINCT短语的作用是
对查询结果进行分组
消除重复出现的查询记录
按条件显示部分查询记录
删除查询结果中符合条件的记录
热门试题
更多
In85softwareonequestionofnear-universalinterestishowrapidlyWindowsNTwhichbeganshippinglastsummerwillbe86inthemarketplaceandforwhatuses.Forthemostpartobserversare87abouttheoperatingsystem’slongtermprospectsbutexpectittoremainon88ratherthandesktopsduring1994sayingthatitwon’tbecomeamainstreamproductuntil89PCstypicallyhave16to24MBofRAMwhichisunlikelytohappennextyear.
Inrecentyearsoneofthemorepopulartopicsforpaneldiscussionsatcomputerconferencesandtrade61hasbeentheRISCversusCISCdebate.RISCprocessorsfeatureasmallnumberofinstructionsthateachexecutesin62machinecycle.CISCprocessorsusecomplexinstructionsthatcantakeseveralcyclestoexecute.TheRISCversusCISCdebatewon’tbedecidedbypaneldiscussion;itwillbewoninthemarketplace.Andthedecidingfactormayhavelittletodowith63ofinstructionsandregistersandmoretodowithparallelism.SincetheirconceptionRISCprocessorshavebeenevolvingtowardmicroparallelismincorporatingparallel-processingfeatures64theprocessorRISCprocessorsfeaturepipeliningwherebymanyinstructionscanbedecodedwhileoneinstructionexecutes.RISCprocessorshoweveraremovingtowardpipelinesforeachunitoftheprocessor.CISCprocessorsalsoemploypipelining.TheyhavemanyintegerinstructionsthatexecuteinonecyclebutthevaryingexecutiontimesofCISCinstructions65theeffectivenessofparallelism.
OneoftheguidelinesinwritingtheCcodeforasoftwaretoolisasfollows:writecodethatisasclearandassimplea76.TheClanguagecanbedifficulttoreadifyoucombineall77featuresinasinglestatement.Breakcomplicated78intoseveraleasytounderstandstatementsforthe79ofreadability.Thisstylehelpstomakeyourprogramsmore80anderror-free.
TheRationalUnifiedProcessRUPisasoftwareengineeringprocesswhichcapturesmanyofbestpracticesinmodemsoftwaredevelopment.Thenotionsof36andscenarioshavebeenproventobeanexcellentwaytocapturefunctionrequirements.RUPcanbedescribedintwodimensions-timeandcontent.Inthetimedimensionthesoftwarelifecycleisbrokenintocycles.Eachcycleisdividedintofourconsecutive37whichisconcludedwithawell-defined38andcanbefurtherbrokendowninto39-acompletedevelopmentloopresultinginareleaseofanexecutableproductasubsetofthefinalproductunderdevelopmentwhichgrowsincrementallytobecomethefinalsystem.Thecontentstructurereferstothedisciplineswhichgroup40logicallybynature.
Object-orientedDBMSintegratedavarietyof81datatypes-suchasbusinessproceduresgraphicspicturesvoiceandannotatedtext.Objectorientationalsomakesa82toapplicationdevelopmentefficiency.Itmakesthedatafunctionsattributesandrelationshipsanintegralpartofthe83.Inthiswayobjectscanbereusedandreplicated.SomeleadingRDBMSvendorssupporttheconceptofintegratingobjectmanagementcapabilitieswiththeircurrentlineofrelationalproducts.Thatcapabilityenableuserstothedevelopmentcyclesinceintegritylogicandbusinessrolesnolongerneedtobeprogrammed84eachapplication.
In85softwareonequestionofnear-universalinterestishowrapidlyWindowsNTwhichbeganshippinglastsummerwillbe86inthemarketplaceandforwhatuses.Forthemostpartobserversare87abouttheoperatingsystem’slongtermprospectsbutexpectittoremainon88ratherthandesktopsduring1994sayingthatitwon’tbecomeamainstreamproductuntil89PCstypicallyhave16to24MBofRAMwhichisunlikelytohappennextyear.
Forusersmicrokerneltechnologypromises90compactandsophisticatedoperatingsystemsthataretypically91acrossarangeofhardwareplatforms.Theseoperatingsystemswillbecustomizabletoletusersrunmultipleoperatingsystemandapplicationpersonalitiesontopofasinglemicrokernel92.Microkernelbasedsystemscanprovidethisflexibilitybecausethecoreoperatingsystemfunctionsare93fromthelargenumberofutilitiesfeaturesandextensionsthatarelayeredontopofthem.Asaresultupdatingandmaintainingoperatingsystemiseasiersincedevelopersdon’thavetomodifythe94everytimetheymustacidanewfeature.
Object-orientedDBMSintegratedavarietyof81datatypes-suchasbusinessproceduresgraphicspicturesvoiceandannotatedtext.Objectorientationalsomakesa82toapplicationdevelopmentefficiency.Itmakesthedatafunctionsattributesandrelationshipsanintegralpartofthe83.Inthiswayobjectscanbereusedandreplicated.SomeleadingRDBMSvendorssupporttheconceptofintegratingobjectmanagementcapabilitieswiththeircurrentlineofrelationalproducts.Thatcapabilityenableuserstothedevelopmentcyclesinceintegritylogicandbusinessrolesnolongerneedtobeprogrammed84eachapplication.
Anexpertsystemisasoftwarethat41specialistknowledge-aboutaparticulardomainof42andiscapableofmaking43decisionswithinthatdomain.Althoughexpertsystemstypicallyfocusonaverynarrowdomaintheyhaveachieveddramaticsuccesswith44problemsThishasexcitedwidespreadinterestoutsidetheresearchlaboratoriesfromwhichtheyemerged.Expertsystemshavegivenrisetoasetofknowledgeengineeringmethodsconstitutinganewapproachtodesignofhighperformancesoftwaresystem.Thisnewapproachrepresentsan45changewithrevolutionaryconsequences.
Inrecentyearsoneofthemorepopulartopicsforpaneldiscussionsatcomputerconferencesandtrade61hasbeentheRISCversusCISCdebate.RISCprocessorsfeatureasmallnumberofinstructionsthateachexecutesin62machinecycle.CISCprocessorsusecomplexinstructionsthatcantakeseveralcyclestoexecute.TheRISCversusCISCdebatewon’tbedecidedbypaneldiscussion;itwillbewoninthemarketplace.Andthedecidingfactormayhavelittletodowith63ofinstructionsandregistersandmoretodowithparallelism.SincetheirconceptionRISCprocessorshavebeenevolvingtowardmicroparallelismincorporatingparallel-processingfeatures64theprocessorRISCprocessorsfeaturepipeliningwherebymanyinstructionscanbedecodedwhileoneinstructionexecutes.RISCprocessorshoweveraremovingtowardpipelinesforeachunitoftheprocessor.CISCprocessorsalsoemploypipelining.TheyhavemanyintegerinstructionsthatexecuteinonecyclebutthevaryingexecutiontimesofCISCinstructions65theeffectivenessofparallelism.
Inrecentyearsoneofthemorepopulartopicsforpaneldiscussionsatcomputerconferencesandtrade61hasbeentheRISCversusCISCdebate.RISCprocessorsfeatureasmallnumberofinstructionsthateachexecutesin62machinecycle.CISCprocessorsusecomplexinstructionsthatcantakeseveralcyclestoexecute.TheRISCversusCISCdebatewon’tbedecidedbypaneldiscussion;itwillbewoninthemarketplace.Andthedecidingfactormayhavelittletodowith63ofinstructionsandregistersandmoretodowithparallelism.SincetheirconceptionRISCprocessorshavebeenevolvingtowardmicroparallelismincorporatingparallel-processingfeatures64theprocessorRISCprocessorsfeaturepipeliningwherebymanyinstructionscanbedecodedwhileoneinstructionexecutes.RISCprocessorshoweveraremovingtowardpipelinesforeachunitoftheprocessor.CISCprocessorsalsoemploypipelining.TheyhavemanyintegerinstructionsthatexecuteinonecyclebutthevaryingexecutiontimesofCISCinstructions65theeffectivenessofparallelism.
Programmingisa46thathasvariousengineeringand47aspects.Althoughmostoftheseaspectsareinterrelatedeachofthemcoversanumberof48andgoalswinchareveryspecific.Theprogressbeingmadeinteaching49isreflectedbythefactthatmost50sciencecurriculacontainabroadspectrumofprogrammingcourseseachemphasizingadifferentaspectofprogramming.
WhilemostrecentattentionintheAIfieldhasbeenfocusedonexpertsystemsoftwareAI66hasalsoseendramaticadvances.Activityinthepastyearswascharacterizedbynewlow-costpowerfulLispmachinestheintroductionofAIworkstationsLispcompilersbecomingavailableforallmajorprofessionalandengineeringworkstationsandthepersonalcomputeremergingasa67.toolforexpertsystemdevelopment.Thenextfewyearswillseethistechnologyevolvesfurther.Becausethe68ofanAIcomputerrepresentsasizableinvestmentcompaniesshouldcarefully69alloptionsthatareavailableaswellashaveagoodideaofwhatthenextgenerationofsystemswillofferinorderto70theoptimumsystem.Thispublicationprovidestheinformationnecessarytogainthisunderstanding.
Mobilecomputers-which71laptopsnotebookssubnotebooksandhandhelds-72soubiquitousinsuchashorttimenosurprisetohearwhosay:Itwilldefinetheleadingedge73thenextfiveyearsorso.Themostremarkable74mobilecomputersistheamountofdatastorageandmemorypacked75theirtinyboxes.Thesedevicesnotonlyhandlewindowseasilybutalsorunstorage-hungryprograms.
31analysisemphasizesthedrawingofpictorialsystemmodelstodocumentandvalidatebothexistingand/orproposedsystems.Ultimatelythesystemmodelsbecomethe32fordesigningandconstructinganimprovedsystem.33issuchatechnique.Theemphasisinthistechniqueisprocess-centered.Systemsanalystsdrawaseriesofprocessmodelscalled34.35isanothersuchtechniquethatintegratesdataandprocessconcernsintoconstructscalledobjects.
Inobject-oriented51objectscanbeviewedasreusablecomponentsandoncetheprogrammerhasdevelopeda52ofthesecomponentshecan53theamountofnewcodingrequired.But52a54isnosimpletaskbecausetheintegrityoftheOriginalsoftwaredesigniscritical.Reusabilitycanbeamixedblessingforusertooasaprogrammerhastobeabletofindtheobjectheneeds.Butif55isyouraimreusabilityisworththerisk.
Mobilecomputers-which71laptopsnotebookssubnotebooksandhandhelds-72soubiquitousinsuchashorttimenosurprisetohearwhosay:Itwilldefinetheleadingedge73thenextfiveyearsorso.Themostremarkable74mobilecomputersistheamountofdatastorageandmemorypacked75theirtinyboxes.Thesedevicesnotonlyhandlewindowseasilybutalsorunstorage-hungryprograms.
Mobilecomputers-which71laptopsnotebookssubnotebooksandhandhelds-72soubiquitousinsuchashorttimenosurprisetohearwhosay:Itwilldefinetheleadingedge73thenextfiveyearsorso.Themostremarkable74mobilecomputersistheamountofdatastorageandmemorypacked75theirtinyboxes.Thesedevicesnotonlyhandlewindowseasilybutalsorunstorage-hungryprograms.
Anexpertsystemisasoftwarethat41specialistknowledge-aboutaparticulardomainof42andiscapableofmaking43decisionswithinthatdomain.Althoughexpertsystemstypicallyfocusonaverynarrowdomaintheyhaveachieveddramaticsuccesswith44problemsThishasexcitedwidespreadinterestoutsidetheresearchlaboratoriesfromwhichtheyemerged.Expertsystemshavegivenrisetoasetofknowledgeengineeringmethodsconstitutinganewapproachtodesignofhighperformancesoftwaresystem.Thisnewapproachrepresentsan45changewithrevolutionaryconsequences.
Anexpertsystemisasoftwarethat41specialistknowledge-aboutaparticulardomainof42andiscapableofmaking43decisionswithinthatdomain.Althoughexpertsystemstypicallyfocusonaverynarrowdomaintheyhaveachieveddramaticsuccesswith44problemsThishasexcitedwidespreadinterestoutsidetheresearchlaboratoriesfromwhichtheyemerged.Expertsystemshavegivenrisetoasetofknowledgeengineeringmethodsconstitutinganewapproachtodesignofhighperformancesoftwaresystem.Thisnewapproachrepresentsan45changewithrevolutionaryconsequences.
Withthewidespreaduseofthepersonalcomputermanyauthoritiesinthefieldof56havepointedouttheneedforcomputerliteracy.Unfortunatelythereisno57agreementastowhatthetermcomputerliteracymeans.Somefeelthatcomputerliteracymeansknowinghowtomakethecomputercompute;thatisknowinghowtoprogramcomputersinoneormoreprogramminglanguages.Othersfeelthatknowinghowtoprogramismerelyasmallsegmentofcomputerliteracy.Thesepeople58themajoremphasisinschoolsshouldbeonteachinghowtoeffectivelyusethemanysoftwarepackagesthatareavailable.Stillotherssuggestthatcomputerliteracyeducationisnotrequired.Theysuggestthatcomputersarebeingsorapidlyintegratedintooursocietythatusingacomputerwillbeas59asusingatelephoneoravideotaperecorderandthatspecialeducationwillnotbenecessary.60ofone’sdefinitionofcomputerliteracyitisrecognizedbymostthatlearningtouseacomputerisindeedanimportantskillinmodernsociety.
Inobject-oriented51objectscanbeviewedasreusablecomponentsandoncetheprogrammerhasdevelopeda52ofthesecomponentshecan53theamountofnewcodingrequired.But52a54isnosimpletaskbecausetheintegrityoftheOriginalsoftwaredesigniscritical.Reusabilitycanbeamixedblessingforusertooasaprogrammerhastobeabletofindtheobjectheneeds.Butif55isyouraimreusabilityisworththerisk.
WhilemostrecentattentionintheAIfieldhasbeenfocusedonexpertsystemsoftwareAI66hasalsoseendramaticadvances.Activityinthepastyearswascharacterizedbynewlow-costpowerfulLispmachinestheintroductionofAIworkstationsLispcompilersbecomingavailableforallmajorprofessionalandengineeringworkstationsandthepersonalcomputeremergingasa67.toolforexpertsystemdevelopment.Thenextfewyearswillseethistechnologyevolvesfurther.Becausethe68ofanAIcomputerrepresentsasizableinvestmentcompaniesshouldcarefully69alloptionsthatareavailableaswellashaveagoodideaofwhatthenextgenerationofsystemswillofferinorderto70theoptimumsystem.Thispublicationprovidestheinformationnecessarytogainthisunderstanding.
Inobject-oriented51objectscanbeviewedasreusablecomponentsandoncetheprogrammerhasdevelopeda52ofthesecomponentshecan53theamountofnewcodingrequired.But52a54isnosimpletaskbecausetheintegrityoftheOriginalsoftwaredesigniscritical.Reusabilitycanbeamixedblessingforusertooasaprogrammerhastobeabletofindtheobjectheneeds.Butif55isyouraimreusabilityisworththerisk.
In85softwareonequestionofnear-universalinterestishowrapidlyWindowsNTwhichbeganshippinglastsummerwillbe86inthemarketplaceandforwhatuses.Forthemostpartobserversare87abouttheoperatingsystem’slongtermprospectsbutexpectittoremainon88ratherthandesktopsduring1994sayingthatitwon’tbecomeamainstreamproductuntil89PCstypicallyhave16to24MBofRAMwhichisunlikelytohappennextyear.
TheRationalUnifiedProcessRUPisasoftwareengineeringprocesswhichcapturesmanyofbestpracticesinmodemsoftwaredevelopment.Thenotionsof36andscenarioshavebeenproventobeanexcellentwaytocapturefunctionrequirements.RUPcanbedescribedintwodimensions-timeandcontent.Inthetimedimensionthesoftwarelifecycleisbrokenintocycles.Eachcycleisdividedintofourconsecutive37whichisconcludedwithawell-defined38andcanbefurtherbrokendowninto39-acompletedevelopmentloopresultinginareleaseofanexecutableproductasubsetofthefinalproductunderdevelopmentwhichgrowsincrementallytobecomethefinalsystem.Thecontentstructurereferstothedisciplineswhichgroup40logicallybynature.
Programmingisa46thathasvariousengineeringand47aspects.Althoughmostoftheseaspectsareinterrelatedeachofthemcoversanumberof48andgoalswinchareveryspecific.Theprogressbeingmadeinteaching49isreflectedbythefactthatmost50sciencecurriculacontainabroadspectrumofprogrammingcourseseachemphasizingadifferentaspectofprogramming.
Forusersmicrokerneltechnologypromises90compactandsophisticatedoperatingsystemsthataretypically91acrossarangeofhardwareplatforms.Theseoperatingsystemswillbecustomizabletoletusersrunmultipleoperatingsystemandapplicationpersonalitiesontopofasinglemicrokernel92.Microkernelbasedsystemscanprovidethisflexibilitybecausethecoreoperatingsystemfunctionsare93fromthelargenumberofutilitiesfeaturesandextensionsthatarelayeredontopofthem.Asaresultupdatingandmaintainingoperatingsystemiseasiersincedevelopersdon’thavetomodifythe94everytimetheymustacidanewfeature.
Withthewidespreaduseofthepersonalcomputermanyauthoritiesinthefieldof56havepointedouttheneedforcomputerliteracy.Unfortunatelythereisno57agreementastowhatthetermcomputerliteracymeans.Somefeelthatcomputerliteracymeansknowinghowtomakethecomputercompute;thatisknowinghowtoprogramcomputersinoneormoreprogramminglanguages.Othersfeelthatknowinghowtoprogramismerelyasmallsegmentofcomputerliteracy.Thesepeople58themajoremphasisinschoolsshouldbeonteachinghowtoeffectivelyusethemanysoftwarepackagesthatareavailable.Stillotherssuggestthatcomputerliteracyeducationisnotrequired.Theysuggestthatcomputersarebeingsorapidlyintegratedintooursocietythatusingacomputerwillbeas59asusingatelephoneoravideotaperecorderandthatspecialeducationwillnotbenecessary.60ofone’sdefinitionofcomputerliteracyitisrecognizedbymostthatlearningtouseacomputerisindeedanimportantskillinmodernsociety.
OneoftheguidelinesinwritingtheCcodeforasoftwaretoolisasfollows:writecodethatisasclearandassimplea76.TheClanguagecanbedifficulttoreadifyoucombineall77featuresinasinglestatement.Breakcomplicated78intoseveraleasytounderstandstatementsforthe79ofreadability.Thisstylehelpstomakeyourprogramsmore80anderror-free.
热门题库
更多
中级软件设计师
初级网络管理员
初级信息处理技术员
中级数据库系统工程师
中级多媒体应用设计师
高级系统分析师
高级网络规划设计师
高级系统架构师
中级信息系统监理师
初级通信工程师
中级通信工程师
通信新技术、新业务知识
无线通信专业技术
移动通信专业技术
有线传输专业技术
电话交换专业技术
湘公网安备 43130202000226号