数据库原理与应用Oracle期末考试题2012A-答案

技术官员村位于位于亚运城东部，主干道二以东石楼涌以西的地块，占地面积、m2，总建筑面积、m2，共包括地下室南区、地下室北区、地上部分1栋～12栋、服务中心、室外工程等多个单体工程。其中住宅面积m2，共12栋，1～7栋建筑层数为11层，8～12栋11层（局部复式顶层），首层局部架空，布置公建配套设施。integratedenergy,chemicalsandtextileYibincity,arethethreecorepillarsoftheindustry.In2014,thewuliangyebrandvalueto73.58billionyuan,thecity'sliquorindustrysliptostabilise.Promotingdeepdevelopmentofintegratedenergy,advancedequipmentmanufacturingindustry,changningdistrict,shalegasproductioncapacityreached277millioncubicmetres,builtthecountry'sfirstindependenthigh-yieldwellsandpipelinesinthefirstsection,theleadinfactoryproductionandsupplytothepopulation.2.1-3GDPgrowthfigure2.1-4Yibin,Yibincity,Yibincity,fiscalrevenuegrowth2.1.4topographyterrainoverallisSouthwest,North-EasternState.Lowmountainsandhillsinthecitylandscapeasthemainridge-and-Valley,pingbasmallfragmentednaturepictureforwaterandthesecondlandofthesevenhills.236metersto2000metersabovesealevelinthecity,lowmountain,46.6%hills45.3%,pingbaonly8.1%.2.1.5developmentofYibinlandscapesanddistinctivefeatureinthecenterofthecity,withlimitations,andspatialstructureoftypicalzonalgroup,2012-citiesinbuildingwithanareaofabout76.2km2.Fromcity-buildingsituation,oldtown-theSouthBankCenterconstructionislaggingbehind,disintegrationoftheoldcityisslow,optimizationandupgrading,qualitypublicserviceresourcesarestillheavilyconcentratedintheoldtowntogether.SouthbankCentrehasnotbeenformed,functionsoftheserviceareaspaceismissing.Meanwhile,peripheralgroupcentresservicewasweakandinadequateaccountingforcitydevelopment,suspiciouspatterncouldnotbeformed.Asregardstransport,withtheoutwardexpansionofcities,citieshavebeenexpanding,centripetalcitytrafficorganizationhasnotchanged,integratedenergy,chemicalsandtextileYibincity,arethethreecorepillarsoftheindustry.In2014,thewuliangyebrandvalueto73.58billionyuan,thecity'sliquorindustrysliptostabilise.Promotingdeepdevelopmentofintegratedenergy,advancedequipmentmanufacturingindustry,changningdistrict,shalegasproductioncapacityreached277millioncubicmetres,builtthecountry'sfirstindependenthigh-yieldwellsandpipelinesinthefirstsection,theleadinfactoryproductionandsupplytothepopulation.2.1-3GDPgrowthfigure2.1-4Yibin,Yibincity,Yibincity,fiscalrevenuegrowth2.1.4topographyterrainoverallisSouthwest,North-EasternState.Lowmountainsandhillsinthecitylandscapeasthemainridge-and-Valley,pingbasmallfragmentednaturepictureforwaterandthesecondlandofthesevenhills.236metersto2000metersabovesealevelinthecity,lowmountain,46.6%hills45.3%,pingbaonly8.1%.2.1.5developmentofYibinlandscapesanddistinctivefeatureinthecenterofthecity,withlimitations,andspatialstructureoftypicalzonalgroup,2012-citiesinbuildingwithanareaofabout76.2km2.Fromcity-buildingsituation,oldtown-theSouthBankCenterconstructionislaggingbehind,disintegrationoftheoldcityisslow,optimizationandupgrading,qualitypublicserviceresourcesarestillheavilyconcentratedintheoldtowntogether.SouthbankCentrehasnotbeenformed,functionsoftheserviceareaspaceismissing.Meanwhile,peripheralgroupcentresservicewasweakandinadequateaccountingforcitydevelopment,suspiciouspatterncouldnotbeformed.Asregardstransport,withtheoutwardexpansionofcities,citieshavebeenexpanding,centripetalcitytrafficorganizationhasnotchanged,中国农业大学20011~2012学年春季学期数据库原理与应用课程考试试题答案题号一二三四五六七八总分得分一、填空题（共10分，每空1分）1.SQL语言中用来建立数据库对象的命令动词是①__CREATE_____，查询数据库中记录的命令动词是②___SELECT___。2.语句selectyear('1931-9-18')的执行结果是③__1931____。3.数据模型的三个要素是数据静态描述、数据的动态描述、数据的完整性约束4.建立和使用⑦约束(或规则)的目的是为了保证数据的完整性。5.Createtrigger命令用于创建⑧触发器。6.对视图的数据进行操作时，系统根据视图的定义去操作与视图相关联的⑨___基本表____。7.能唯一标识一个元组的属性或属性组称为⑩____候选键、主键或关键字_______。二、单择题（共20分，每题2分）1.____C_是长期存储在计算机内的有组织的、可共享的数据集合。（A）数据库管理系统（B）数据库系统（C）数据库（D）文件组织2.下列命令不属于DBMS的数据定义语言的是：C。（A）CREATE（B）DROP（C）INSERT（D）ALTER3.在数据库需求分析阶段，数据字典是对系统中（D）。A.数据的描述B.处理的描述C.功能的描述D.数据与处理关系的描述4.如果要删除Student数据库中的Information表，则可以使用命令：C。（A)DELETETABLEinformation（B)TRUNCATETABLEinformation（C）DROPTABLEinformation（D）ALTERTABLEinformation5.使用关键字__A_可以把查询结果中的重复行屏蔽。（A）DISTINCT（B）UNION（C）ALL（D）TOP6.在数据库中，可以有A个主键。（A)一个（B)二个技术官员村位于位于亚运城东部，主干道二以东石楼涌以西的地块，占地面积、m2，总建筑面积、m2，共包括地下室南区、地下室北区、地上部分1栋～12栋、服务中心、室外工程等多个单体工程。其中住宅面积m2，共12栋，1～7栋建筑层数为11层，8～12栋11层（局部复式顶层），首层局部架空，布置公建配套设施。integratedenergy,chemicalsandtextileYibincity,arethethreecorepillarsoftheindustry.In2014,thewuliangyebrandvalueto73.58billionyuan,thecity'sliquorindustrysliptostabilise.Promotingdeepdevelopmentofintegratedenergy,advancedequipmentmanufacturingindustry,changningdistrict,shalegasproductioncapacityreached277millioncubicmetres,builtthecountry'sfirstindependenthigh-yieldwellsandpipelinesinthefirstsection,theleadinfactoryproductionandsupplytothepopulation.2.1-3GDPgrowthfigure2.1-4Yibin,Yibincity,Yibincity,fiscalrevenuegrowth2.1.4topographyterrainoverallisSouthwest,North-EasternState.Lowmountainsandhillsinthecitylandscapeasthemainridge-and-Valley,pingbasmallfragmentednaturepictureforwaterandthesecondlandofthesevenhills.236metersto2000metersabovesealevelinthecity,lowmountain,46.6%hills45.3%,pingbaonly8.1%.2.1.5developmentofYibinlandscapesanddistinctivefeatureinthecenterofthecity,with