達內(nèi)月考題jsd1304第二次

functionwriteIt(value){}<body<form<inputtype="text"<inputtype="text"name="second_text"result.push(curCode)curCoderesult中。下列result[i]=SELECTkc,COUNT(kc)FROMleanrORDERBYCOUNT(kc)GROUPBY WHERECOUNT(kc)>=2SELECTkc,COUNT(kc)FROMleanrORDERBYCOUNT(kc)GROUPBY SELECTkc,COUNT(kc)FROM GROUPBY WHEREORDERBYCOUNT(kc)SELECTkc,COUNT(kc)FROM GROUPBY

ORDERBYCOUNT(kc)ABCD<tableborder="1"<tr><td <tableborder="1"<tr><td<tableborder="1"<tr><td<tr><td>B</td><td<tr><td<tableborder="1"<tr><td<tr><td>B</td><td<tr><tdSELECTDISTINCTnameFROMSELECTnameDISTINCTFROMSELECTnameFROMSELECTnameFROMuserLIMITSELECT100/NVL(quantity,0)FROMquantityNULL空值時，將導致出錯，其原因是：（）的顧客編號，下列Sql語句正確的是（）SELECTDISTINCT(cid)FROMordersWHEREo1.pidSELECTDISTINCT(cid)FROMORDERSo1,ordersWHEREo1.pid=’p01’ANDANDSELECTDISTINCT(cid)FROMWHEREpid=’p01’ANDcidIN(selectcidFROMordersWHERESELECTDISTINCT(cid)FROMorderso1,ordersWHEREo1.pid=’p01’AND現(xiàn)有a表和b表a：jigou(機構)，kehhao(客戶號)，jiaoyrq(交易日期),jioyje(交易金額)b:kehhao(客戶號)bVIP客戶號表SELECTCOUNT(akehhao)FROMaINNERJOINbONakehhao=b.kehhaoGROUPBYSELECTCOUNT(akehhao)FROMaINNERJOINbONakehhao=b.kehhaoORDERBYSELECTSUM(akehhao)FROMaINNERJOINbONakehhao=bkehhaoORDERBYSELECTCOUNT(akehhao)FROMaINNERJOINbONakehhao=b.kehhaoHAVING"Hello("Hello在Oracle數(shù)據(jù)庫中，關于主鍵約束與唯一約束說法錯誤的是（）在Oracle中，有表Person，如下： SELECTTelFROMPersonWHEREName=vartxt=newvartxt=newvartxt=newvartxt=new在Oracle中，當數(shù)據(jù)量較大時，刪除表中所有數(shù)據(jù)，效率較高的是（）DELETEFROMDELETEFROMStudentWHERETRUNCATEtableTRUNCATEtableStudentWHERE reg= reg=new reg= reg=CREATEPRIMARYKEYONCREATECONSTRAINTpk_booksPRIMARYKEYONALTERTABLEbooksADDCONSTRAINTpk_booksPRIMARYKEYALTERTABLEbooksADDPRIMARYKEY<!ELEMENT paymenttype(check|cash)不合法的XML是<payment<payment<paymenttype=""<payment

body}

color:<bodystyle="color:<div

在Oracle中，現(xiàn)有Student表，其中包括學號stuId,stuName,成績stuGrade80分的SELECTstuNameFROMstudentWHEREstuGrade=80ORDERBYSELECTstuNameFROMstudentWHEREstuGrade=80ORDERBYstuIdSELECTstuNameFROMstudentWHEREstuGradelike80GROUPBYSELECTstuNameFROMstudentWHEREstuGrade=80GROUPBYstuIda(3行數(shù)據(jù))和表b（4行數(shù)據(jù)）SELECT*FROMa,b，返回的查詢結果的710altersessionsetnls_date_format='yyyymmddfromdual;alterusersetnls_date_format='yyyymmddfromdual;altersessionsetnls_date_format='yyyymmddC.selectlast_month(),this_month(),next_month()fromalterusersetnls_date_format='yyyymmddD.selectlast_month(),this_month(),next_month()from下面的描述錯誤的是

<happy>Happyvara=newArray(2,3,4,5,6,7);varsum=0;for(vari=1;i<a.length;i++)sum+=a[i];varx=vary=varm=x+以下對JavaScript理解正確的是（）abcd<tableborder="1"<tr><td<tr><td<tableborder="1"<tr><td<tr><td<tableborder="1"<tr><td<tr><td<tableborder="1"<tr><td<tr><td在HTML中引入外部的CSS文件，正確的HTML代碼是：（）<style<input<inputC.D.在Oracle中，刪除表Student中的所有數(shù)據(jù)，可以使用的Sql是（）DROPTABLEDELETEFROMDELETE*FROMDROP*FROM在Oracle1850之間(1850)，可使用的代碼是（）age>18andage>=18andage>=18&&age>18&&437100125052480000054550012562272000008436001256745600000出服務器的時間（毫秒數(shù)）。方法populate用于將日志文件中的數(shù)據(jù)插入到數(shù)據(jù)庫的t_loginfo表中，建表的SQL如下：createtablet_loginfo(idnumber(12)notnull,user_idnumber(6)notnull,login_timenumber(20)notnull,altertablet_loginfoaddconstraintpk_t_loginfoprimarykey(id);createsequencet_loginfo_seq;publicvoidpopulate(FilelogFile)throws{intbatchSize=Connectioncon=PreparedStatementstmt=null;try{Stringline=null;introws=0;while((line=reader.readLine())!=null)3stmt.setInt(1,Integer.parseInt(data[0]));stmt.setLong(2,Long.parseLong(data[1]));if(++rows>=rows=0;}}}catch(Exceptione)throwe;}finallyif(stmt!=null)stmt.close();}}BufferedReaderreader=newBufferedReaderreader=newBufferedReader(newFileReader(logFile,"utf-BufferedReaderreader=newBufferedReader(newInputStreamReader(logFile,"utf-

String[]data=String[]data=line.split("String[]data=line.parse("String[]data=

<scriptlanguage="javascript"type="text/javascript">functionBuy(){varr=CreateBallCode();}varresult=newvari=0;while(i<7){varcurCode=GetRandomInt(1,37);varisHas=false;for(varj=0;j<result.length;{if(result[j]==curCode)isHas=true;}}if(!isHas)}}returnresult;}varn=Math.floor(Math.random()*(max-min))+min;returnn;}functionSortFunc(a,b)returna-}<form

A.document.getElementById("divResult").color=red;B.document.getElementById("divResult").style.color=red;C.document.getElementById("divResult").color=“red“;為了實現(xiàn)對于數(shù)組resultSortFunc。如B.result.sort(newFunction("a","b","returna-b;"));C.result.sort(Function(a,b,returna-b));D.result.sort(newFunction(a,b,returna-b));result.push(curCode)用于將產(chǎn)生的整數(shù)curCode放入數(shù)組變量result中。下列代A.result[i]=curCode;primarynotINSERTINTOclassInfo(claId,claName)VALUES(1,'Java1209');INSERTINTOclassInfo(claId,claName)VALUES(2,'Java1210');INSERTINTOclassInfo(claId,claName)VALUES(3,'Java1211');primaryforeigncheck(sexorsex=defaultdefaultINSERTINTOstudent(username,claId,sex,age,score)INSERTINTOstudent(username,claId,sex,age,score)INSERTINTOstudent(username,claId,sex,age,score)INSERTINTOstudent(username,claId,sex,age,score)INSERTINTOstudent(username,claId,sex,age,score)INSERTINTOstudent(username,claId,sex) 0 0 '%查詢Java1209Java1210班所有學生信息。以下語句正確的是SELECT*FROMstudentWHEREclaId(SELECTclaIdFROMclassInfoWHEREORSELECT*FROMstudentWHEREclaId(SELECTclaIdFROMclassInfoWHEREORSELECTuserName,a.claId,sex,age,scoreFROMstudenta,classInfoWHEREclaName='Java1209'ORclaName='SELECT*FROMstudentWHEREclaId(SELECTclaIdFROMclassInfoWHEREclaName='J