达内月考题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现有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数据库中，关于主键约束与唯一约束说法错误的是（）在Oracle中，有表Person，如下： SELECTTelFROMPersonWHEREName=vartxt=newvartxt=newvartxt=newvartxt=new在Oracle中，当数据量较大时，删除表中所有数据，效率较高的是（）DELETEFROMDELETEFROMStudentWHERETRUNCATEtableTRUNCATEtableStudentWHERE reg= reg=new reg= reg=CREATEPRIMARYKEYONCREATECONSTRAINTpk_booksPRIMARYKEYONALTERTABLEbooksADDCONSTRAINTpk_booksPRIMARYKEYALTERTABLEbooksADDPRIMARYKEY<!ELEMENT paymenttype(check|cash)不合法的XML是<payment<payment<paymenttype=""<payment

body}

color:<bodystyle="color:<div

在Oracle中，现有Student表，其中包括学号stuId,stuName,成绩stuGrade80分的SELECTstuNameFROMstudentWHEREstuGrade=80ORDERBYSELECTstuNameFROMstudentWHEREstuGrade=80ORDERBYstuIdSELECTstuNameFROMstudentWHEREstuGradelike80GROUPBYSELECTstuNameFROMstudentWHEREstuGrade=80GROUPBYstuIda(3行数据)和表b（4行数据）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中的所有数据，可以使用的Sql是（）DROPTABLEDELETEFROMDELETE*FROMDROP*FROM在Oracle1850之间(1850)，可使用的代码是（）age>18andage>=18andage>=18&&age>18&&437100125052480000054550012562272000008436001256745600000出服务器的时间（毫秒数）。方法populate用于将日志文件中的数据插入到数据库的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“;为了实现对于数组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)用于将产生的整数curCode放入数组变量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