福師《數(shù)據(jù)庫管理與應(yīng)用》在線作業(yè)一答卷

牽弗ゞ方象垂砿尖嚥哘喘〃壓?恬匍匯-0002編壌悳蛍:100誼蛍:100匯、汽僉籾(慌40祇編籾,慌80蛍)譜嗤匯倖兆葎GZ?DBF議燕猟周?淫根參和忖粁?侖兆(C?8)、岼暦?C?10?、垢彿(N?6?2)、竃伏晩豚?D?8?才屎塀垢?L?l?。堋響參和殻會?USEGZDOWHILE?NOT.EOF____IF岼暦?＾垢殻弗￣.AND.竃伏晩豚??10?20?60?D?竃伏晩豚NAME?侖兆SALARY?垢彿EXITENDIFSKIPENDDOY?YEAR?DATE____??YEAR?D??幣匯了1960定10埖20晩朔竃伏議垢殻弗侖兆?定槍式垢彿?幣匯了1960定10埖20晩朔竃伏議垢殻弗侖兆?定槍?幣1960定10埖20晩朔竃伏議垢殻弗侖兆?定槍式垢彿?幣侭嗤1960定10埖20晩朔竃伏議垢殻弗侖兆?定槍式垢彿基宛:A2.和雙陳匯?音頁DBMS議怏撹何蛍?()DDL式凪鍬咎侃尖殻會DML式凪園咎、盾瞥殻會方象垂塰佩陣崙殻會凡麼囂冱式凪園咎、侃尖殻會基宛:D3.壓凋綜完笥嶄峇佩____凋綜?辛參嬉蝕潮範猟周斜和議＾僥伏撹示￣?朕。CREATEPROJECT僥伏撹示MODIFYPROJECT僥伏撹示OPENPROJECT僥伏撹示褒似＾僥伏撹示.PRG￣猟周兆基宛:B4.乾窟匂頁匯嶽蒙歩議()沫哈篇夕児云燕贋刈狛殻基宛:D5.和雙膨?嶄傍隈音屎鳩議頁()方象垂受富阻方象庇噫方象垂嶄議方象辛參慌?方象垂閲窒阻匯俳方象議嶷鹸方象垂醤嗤熟互議方象鏡羨來基宛:C6.方象垂狼由嶄茅阻辛喘蚊肝庁侏才購狼庁侏燕幣糞悶竊侏式糞悶寂選狼議方象庁侏參翌?珊嗤??。E-R庁侏佚連庁侏利大庁侏麗尖庁侏基宛:C7.斤篇夕議臥儂?恷嶮勣廬曬葎斤()議臥儂。沫哈圷怏児云燕方象垂基宛:C8.壓購狼方象庁侏嶄?宥械辛參委忖粁各葎奉來?遇委____各葎購狼庁塀。芝村芝村竊侏圷怏圷怏鹿基宛:B9.()頁斤喘薩侭喘欺議椎何蛍方象議宙峰。庁塀翌庁塀坪庁塀購狼庁塀基宛:B10.SKIP-2議峇佩佩葎頁____。輝念芝村?猟周硫卞強2倖芝村輝念芝村?猟周遊卞強2倖芝村音恬販採卞強輝念芝村貫猟周硫朔曜2倖芝村基宛:B11.邪協(xié)嗤購狼僥伏(僥催、侖兆、定槍、萎雫催)?仁殻(仁殻催、仁各兆、僥蛍)?深編(僥催、仁殻催、撹示)?臥儂20槙議僥伏議僥催、侖兆才定槍。聞喘()購狼。僥伏仁殻深編僥伏才仁?；?A12.方象垂砿尖狼由嶄喘噐協(xié)吶才宙峰方象垂貸辭潤更議囂冱各葎____。方象垂庁塀宙峰囂冱方象垂徨囂冱方象荷忿囂冱方象潤更囂冱基宛:A13.和中購噐凋綜DOFORMXXNAMEYYLINKED議蠣峰嶄?屎鳩議頁()恢伏燕汽斤?哈喘延楚XX?壓瞥慧延楚XX扮徭強購液燕汽恢伏燕汽斤?哈喘延楚XX?壓瞥慧延楚XX扮旺音購液燕汽恢伏燕汽斤?哈喘延楚YY?壓瞥慧延楚YY扮徭強購液燕汽恢伏燕汽斤?哈喘延楚YY?壓瞥慧延楚YY扮旺音購液燕汽基宛:C14.燕汽兆葎myForm議燕汽嶄嗤匯倖匈崇myPageFrame?繍乎匈崇議及3匈(Page3)議炎籾譜崔葎＾俐個￣?辛參聞喘旗鷹()myForm.Page3.myPageFrame.Caption="俐個"myForm.myPageFrame.Caption.Page3="俐個"Thisform.myPageFrame.Page3.Caption="俐個"Thisform.myPageFrame.Caption.Page3="俐個"基宛:C15.譜購狼R=(A?B?C)?嚥SQL囂鞘selectdistinctAfromRwhereB=17吉勺議購狼旗方燕器塀頁()πA(σB=17(R))σB=17(πA(R))σB=17(πA?C(R))πA?C(σB=17(R))基宛:A16.斤購狼庁塀序佩蛍盾議朕議頁聞庁塀厚紗()號袈曬潤更曬炎彈曬酒汽曬基宛:A17.()頁斤方象垂嶄畠悶方象議貸辭潤更才蒙尢議宙峰。庁塀徨庁塀翌庁塀坪庁塀基宛:A18.壓方象垂狼由嶄?宥械喘眉雫庁塀棲宙峰方象垂?____宙峰阻方象議麗尖潤更翌庁塀古廷庁塀坪庁塀貸辭潤更基宛:C19.梓泥議Name奉來喘噐____。恬葎梓泥貧議猟忖梓泥斤?議哈喘兆梓泥議奉來兆參貧脅音頁基宛:B20.方象議砿尖圭隈麼勣嗤____。答侃尖才猟周狼由猟周狼由才蛍下塀狼由蛍下塀狼由才答侃尖方象垂狼由才猟周狼由基宛:D21.譜嗤匯倖購狼?DEPT?DNO?DNAME??泌惚勣孀竃宜方及眉倖忖銚葎W?旺拝崛富淫根4倖忖銚議DNAME?夸臥儂訳周徨鞘哘亟撹WHEREDNAMELIKE??。｀__W_%¨｀_%W__¨｀_W__¨｀_W_%¨基宛:B22.飛並暦T斤方象R廝紗X迄?夸凪麿斤方象R____。辛參紗S迄音嬬紗X迄音嬬紗S迄辛參紗X迄辛參紗S迄匆辛參紗X迄音嬬紗販採迄基宛:D23.SQL嶄聞喘()囂鞘幹秀沫哈。CREATEPROCCREATEVIEWCREATETABLECREATEINDEX基宛:D24.峇佩at(＾fp￣,＾VFP柴麻字￣)議潤惚頁____。02.T..F.基宛:A25.方象垂議児云蒙泣頁____。?1?方象辛參慌??賜方象潤更曬??2?方象鏡羨來?3?方象庇噫寄?叟卞峅?4?由匯砿尖才陣崙?1?方象辛參慌??賜方象潤更曬??2?方象鏡羨來?3?方象庇噫弌?叟制割?4?由匯砿尖才陣崙?1?方象辛參慌??賜方象潤更曬??2?方象札算來?3?方象庇噫弌?叟制割?4?由匯砿尖才陣崙?1?方象掲潤更曬?2?方象鏡羨來?3?方象庇噫弌?叟制割?4?由匯砿尖才陣崙基宛:B26.壓方象垂室寶嶄?郡啌?糞弊順嶄並麗議贋壓圭塀才塰強彜蓑議頁??。佚連方象?連凋綜基宛:A27.E-R庁侏嶄議匯倖選狼?掲ISA選狼?廬算葎匯倖購狼庁塀。泌惚選狼頁1:1議?夸嚥乎選狼?銭議光()議囚譲辛恬葎購狼庁塀議囚。奉來鹿糞悶鹿選狼鹿號夸鹿基宛:B28.方象垂狼由議宰伉頁____。園咎狼由方象垂荷恬狼由方象垂砿尖狼由基宛:D29.斤旺窟荷恬飛音紗參陣崙?辛嬬氏揮棲____諒籾。音蘆畠棒迄棒字音匯崑基宛:D30.()頁喘棲譜崔嚥SQLServer2000銭俊議利大塘崔。二匍砿尖匂並周冥霞匂臥儂蛍裂匂人薩極利大糞喘垢醤基宛:D31.壓VisualFoxPro嶄,參和購噐臥儂議宙峰屎鳩議頁()音嬬喘徭喇燕秀羨臥儂峪嬬聞喘徭喇燕秀羨臥儂音嬬喘方象垂燕秀羨臥儂辛參喘方象垂燕才徭喇燕秀羨臥儂基宛:D32.峇佩和雙凋綜?HZ?＾嶄鯖繁酎慌才忽￣?SUBSTR?HZ?LEN?HZ??2-2?4?補竃議潤惚頁____。嶄鯖繁酎慌才才忽基宛:B33.泌惚塰佩匯倖燕汽?參和並周遍枠瓜乾窟議頁??LoadErrorInitClick基宛:A34.嗤方象垂A、B、C?廝秀羨阻A★B議購選?圀壅秀羨B★C議購選?參更撹A★B★C議購選____。駅倬聞喘揮ADDITIVE徨鞘議SETRELATION凋綜聞喘音揮ADDITIVE徨鞘議SETRELATION凋綜軸辛壓隠隔A★B購選議児粥貧音嬬壅秀羨B★C議購選壓隠隔A★B購選議児粥貧音嬬壅秀羨B★C議購選?徽辛參秀羨A★C議購選基宛:A35.譜購狼R才S議奉來倖方葎r才s?夸(R～S)荷恬潤惚議奉來倖方葎()r+sr-sr*smax(r,s)基宛:A36.()潤更嶄崛富嗤匯倖潤泣嗤謹噐匯倖議幻潤泣。蚊肝庁侏利大庁侏購狼庁侏中?斤?庁侏基宛:B37.壓方象垂嶄?恢伏方象音匯崑議功云圻咀頁____。短嗤冢鯉隠擦方象方象贋刈楚湊寄隆斤方象序佩頼屁來陣崙方象庇噫基宛:D38.方象垂?DB?、方象垂狼由?DBS?才方象垂砿尖狼由?DBMS?眉宀岻寂議購狼頁____。DBS淫凄DB才DBMSDBMS淫凄DB才DBSDB淫凄DBS才DBMSDBS祥頁DB?匆祥頁DBMS基宛:A39.壓FoxPro狼由彜蓑和?嗤和雙凋綜會雙?Z?＾X*Y￣X?5Y?10??Z峇佩朔?補竃潤惚頁____。50X*YZ5*10基宛:A40.葎阻契峭匯倖喘薩議垢恬音癖輝仇唹?総匯倖喘薩?哘乎寡函??。頼屁來陣崙蘆畠來陣崙旺窟陣崙恵諒陣崙基宛:C屈、謹僉籾(慌10祇編籾,慌20蛍)41.DBMS斤方象垂序佩撃迄扮寡喘議児云迄竊侏頁()N迄S迄X迄Y迄基宛:BC42.購狼庁侏塋俯協(xié)吶()眉竊頼屁來埃崩。潤更頼屁來糞悶頼屁來歌孚頼屁來狼由頼屁來喘薩協(xié)吶議頼屁來基宛:BCE43.喘薩協(xié)吶議頼屁來埃崩訳周議恬喘斤?辛參頁()圷怏購狼奉來雙方象垂児云燕基宛:ABCE44.並暦頁DBMS議峇佩汽了?匯違醤嗤陳乂來嵎?()圻徨來匯崑來侯宣來隔消來基宛:ABCD45.壓購狼方象嶄?眉雫庁塀潤更淫凄()坪庁塀古廷庁塀贋刈庁塀翌庁塀基宛:ABD46.和中購噐痕方卆正議偃峰嶄?屎鳩議頁()飛X★Y?X★Z?夸X★YZ飛XY★Z?夸X★Z,Y★Z飛X★Y?WY★Z?夸XW★Z飛X★Y?夸XZ★YZ基宛:ACD47.方象庁侏梓孚音揖議哘喘蚊肝辛繍凪皿蛍葎()古廷庁侏貸辭方象庁侏蕉何庁侏麗尖庁侏畠蕉庁侏基宛:AB48.E-R庁侏議譜柴