考题第二次下列代码运行结果是

publicclassTwoThreadsprivatestaticObjectresource=newObject();privatestaticvoiddelay(longn){try{}catch(Exceptione){System.out.print("Error");}}publicstaticvoidmain(String[]args){System.out.print("StartMain");newThread1().start();Threadt2=newThread2();System.out.print("EndMain}staticclassThread1extendsThread{publicvoidrun(){synchronized(resource){System.out.print("Startl");System.out.print("End1");}}}staticclassThread2extendsThread{publicvoidrun(){synchronized(resource){System.out.print("Start2");System.out.print("End2");}}}}StartMainStart1ErrorEndMainStartMainStart1EndMainEnd1Start2StartMainStart1ErrorStart2EndMainEnd2StartMainStart1EndMainEnd1Start2Error正确答案Oracleemp的noname100（包括）（不包括）条记录的SQL：（）selectno,namefromempwhererownum<110andselectno,namefrom(selectno,namerownumnumfromempwhererownum>=100)wherenum<110selectno,namefrom(selectno,namerownumnumfromempwhererownum<110)wherenum>=100selectno,namefromemplimit99,正确答案查询客户以及他的推荐人，没有推荐人的不显示，下列sql语句正确的是selecta1.real_namecustomer, fromaccounta1joinaccounta2ona1.id=a2.id;selecta1.real_namecustomer, fromaccounta1joinaccount mender_id selecta1.real_namecustomer, fromaccounta1joinaccounta2 mender_id=a2.id;selecta1.real_namecustomer, fromaccounta1, mender_id=正确答案下列关于线程的名字说法正确的是：（）Java规定所有的线程名字都是Thread=1Thread类的setName()方法为线程设置名字正确答案类AclassAprotectedvoidf()throwsFileNotFoundException}}下列代码段没有编译错误的是：（）classBextendsApublicvoidf()throwsException}}classBextendsApublicvoidg()throwsIOException{}}classBextendsA{publicvoidg(){try{}catch(IOExceptione)}catch(FileNotFoundExceptione1)}}}classBextendsA{publicvoidg(){try{}catch(FileNotFoundExceptione){thrownewRuntimeException(e);}}}正确答案IO（）下面是某文件中XML的代码，下列选项中符合XML语则的是oeeo<happy>Happy正确答案以下选项中可以用来在books表的isbn列上创建一个主键约束pk_books（）A.CREATEPRIMARYKEYONB.CREATECONSTRAINTpk_booksPRIMARYKEYONC.ALTERTABLEbooksADDCONSTRAINTpk_booksPRIMARYKEYD.ALTERTABLEbooksADDPRIMARYKEY正确答案在Oracle中，现有Student表，其中包括学号stuId,stuName,成绩stuGrade，现要查询成绩为80分的学生，并且结果按照学号降序排列，下面查询语句正确的是（）。A.SELECTstuNameFROMstudentWHEREstuGrade=80ORDERBYstuIdB.SELECTstuNameFROMstudentWHEREstuGrade=80ORDERBYstuIdDESCC.SELECTstuNameFROMstudentWHEREstuGradelike80GROUPBYstuIdD.SELECTstuNameFROMstudentWHEREstuGrade=80GROUPBYstuIdDESC正确答案一个VIEW被以下语句创建，请问在该VIEW：（）CREATEVIEWASSELECT*FROMstateWHEREcnt_code=1WITHREADONLY;B.SELECT,UPDATEC.SELECT,DELETED.SELECT,INSERT正确答案ResultSet（）查询结束后，所有的结果数据将一次被在ResultSet对象Statementclose后，由其创建的ResultSet查询结束后，ResultSetnext()才有可能取正确答案如果查询表a3行数据)和表b（4），使用SELECT*FROMa,b，返回的查询结正确答案下列选项中能够得到字符串的一部分的单行函数是（）正确答案publicclassTestTwoimplementsRunnablepublicstaticvoidmain(String[]args)throwsException{Threadt=newThread(newTestTwo());}publicvoidrun()for(inti=0;i<4;i++){}}}正确答案下列属于DML：（）正确答案下列代码所构建的流，能file.txt中文本的是InputStreamins=newFileInputStream("d:/file.txt");Readerinr=newReader(ins);InputStreamins=newFileInputStream("d:/file.txt");Readerinr=newFileReader(ins);InputStreamins=newFileInputStream("d:/file.txt");FileReaderinr=newFileReader(ins);InputStreamins=newFileInputStream("d:/file.txt");Readerinr=newInputStreamReader(ins);正确答案下面不属于接口的是：（）正确答案下列代码的运行结果是publicclassFoostaticvoidtest()throwsRuntimeException{try{System.out.print("test");thrownewRuntimeException();}catch(Exceptionex){System.out.print("exception");}}publicstaticvoidmain(String[]args){try{}catch(RuntimeExceptionex){System.out.print("runtime}System.out.print("end}}A.testendC.testruntimeD.testexception正确答案sqlaltersessionsetnls_date_format='yyyymmddhh24:mi:ss';selectadd_months(sysdate,-1),sysdate,add_months(sysdate,1)fromdual;alterusersetnls_date_format='yyyymmddselectadd_months(sysdate,-1),sysdate,add_months(sysdate,1)fromaltersessionsetnls_date_format='yyyymmddhh24:mi:ss';selectlast_month(),this_month(),next_month()fromdual;alterusersetnls_date_format='yyyymmddhh24:mi:ss';selectlast_month(),this_month(),next_month()fromdual;正确答案查询cost表中资费名称，月固定费用，月包时长，单位费用,下列sql语句正确的是selectname/base_duration/base_cost/unit_costfromselectname，base_cost,unit_costfromselectnameandbase_durationandbase_costandunit_costfromselectname,base_duration,base_cost,unit_costfrom正确答案下列代码的运行结果是（）publicclass implementsSerializable{privateTreetree=newTree();publicstaticvoidmain(String[]args){f=new tryFileOutputStreamfs=newFileOutputStream(" ObjectOutputStreamos=newObjectOutputStream(fs);}catch(Exceptionex){}}}classTree的实例和Tree正确答案OracleSELECTDISTINCTnameFROMSELECTnameDISTINCTFROMSELECTnameFROMSELECTnameFROMuserLIMIT正确答案RuntimeException：（） 正确答案正确答案ResultSetNUMBER该字段值的方法是：()。正确答案关于Java（）try……catch语句中对tryExceptionthrowsMainthrows正确答案12345有一个数据表usernfouserid，username123451234下列SqlSELECT*FROMuserinfoWHEREusernameIN(SELECTusernameFROMuserinfoGROUPBYSELECT*FROMuserinfoWHEREusernameIN(SELECTDISTINCTusernameFROMSELECT*FROMuserinfoWHEREusernameIN(SELECTusernameFROMuserinfoGROUPBYusernameWHERECOUNT(username)>1);SELECT*FROMuserinfoWHEREusernameIN(SELECTusernameFROMuserinfoGROUPBYusernameHAVINGCOUNT(username)>1);正确答案XML正确答案stateupdate_dtA.ALTERTABLEstateDROPCOLUMNupdate_dt;B.ALTERTABLEstateDELETECOLUMNupdate_dt;C.DROPCOLUMNupdate_dtFROMstate;D.REMOVECOLUMNupdate_dtFROM正确答案Statement的executeQuery()方返回一个结果Statement的executeUpdate()方返回是否更新成功的booleanResultSet中的getStringcharResultSet中的next()方使结果集中的下一行成为当前正确答案操作account表和age_segment表，查询客户huangrong的段，下列sql语句正确的selectreal_name,birthdate,fromaccountajoinage_segmentsonround((sysdate-birthdate)/365)betweenlowageandhiageandreal_name='huangrong';selectreal_name,birthdate,fromaccountaleftjoinage_segmentsonround((sysdate-birthdate)/365)betweenlowageandhiageandreal_name='huangrong';selectreal_name,birthdate,fromaccountaleftjoinage_segmentsonround((sysdate-birthdate)/365)betweenlowageandhiagewherereal_name='huangrong';selectreal_name,birthdate,fromaccountaleftjoinage_segmentsonround((sysdate-birthdate)/365)betweenlowageandRuntimeException：（） 下列语句在建表的同时在c2,c3createtable(c1numberconstrainttest_c1_pkprimarykey,c2numberconstrainttest_c2_ukforeignkey,c3numberconstrainttest_c3_ukforeignkey);createtable(c1numberconstrainttest_c1_pkprimarykey,c2number,c3numberconstrainttest_c3_ukforeigncreatetable(c1numberconstrainttest_c1_pkprimarykey,c2numberc3numberconstrainttest_c3_ukcreatetable(c1numberconstrainttest_c1_pkprimarykey,c2numberconstrainttest_c2_ukc3numberconstrainttest_c3_ukclassRunnerimplementsRunnablepublicvoidrun(){线程体…}publicstaticvoidmain(Stringargs[]){Runnerr=newRunner();Threadt=newThread(r);}}classRunnerimplementsRunnablepublicvoidrun(){线程体…}publicstaticvoidmain(Stringargs[]){Runnert=newRunner();}}classRunnerextendsThreadpublicvoidrun(){线程体…}publicstaticvoidmain(Stringargs[]){Threadt=newRunner();}}classRunnerpublicstaticvoidmain(Stringargs[]){Threadt=newThread(){publicvoidrun(}publicclassTestFiveprivateintx;publicvoidfoo(){intcurrent=x;x=current+}publicvoidgo()for(inti=0;i<5;i++){newThread(){publicvoidrun(){System.out.print(x+",}}}publicstaticvoidmain(String[]args){newTestFive().go();}}为了确保输出结果是“1，2，3，4，5，System.out.print(x+",");”行进入foo“xcurrent1;”行改变go方法的为：publicsynchronizedvoid改变x的变量为：privatestaticint把foo方法中的所有代码，使用synchronized(thisEmpDaoImpl类的findAllEmp（emp）和部门表（dept）中查询所有员工的empno，ename，sal,deptno和dname信息。dept表和emp表的表结构如下：primarynotprimaryforeignpublicclassEmp{privateIntegerempNo;privateStringempName;privateBigDecimalsalary;privateDept//省略getter和}publicclassDept{privateIntegerdeptNo;privateString//省略getter和}publicclassEmpDaoImplimplementsEmpDaoprivatestaticfinalStringSQL_FIND_ALL_EMP=" 1";publicList<Emp>findAllEmp()throwsException{Connectioncon=null;PreparedStatementstmt=null;try{conConnectionUtils.getConnection();//获取数据库连接stmt=con.prepareStatement(SQL_FIND_ALL_EMP);List<Emp>list=new空白处3whilers.nextEmpemp=newEmp();intdeptNo=rs.getInt(4);Deptdeptnull;if 空白处4){dept=}elsedept=newDept();depts.put(deptNo,}空白处5}return}catch(SQLExceptione){throwe;}finallyif(stmt!=null)if(con!=null)}}下列选项中，能填入空白处1的代码是 selecte.empno,e.ename,e.sal,d.dnamefromempejoindeptdone.deptno=d.deptnoselecte.empno,e.ename,e.sal,d.dnamefromempejoindeptdwheree.deptno=d.deptnoselecte.empno,e.ename,e.sal,d.dnamefromempejoindeptdande.deptno=d.deptnoselecte.empno,e.ename,e.sal,d.dnamefromempe，deptdone.deptno=d.deptno正确答案下列选项中，能填入空白处2的代码是 ResultSetrs=stmt.executeQuery(SQL_FIND_ALL_EMP);B.ResultSetrs=stmt.executeQuery();C.ResultSetrs=stmt.executeUpdate();D.ResultSetrs=stmt.execute();正确答案下列选项中，能填入空白处3的代码是 A.Map<String,Dept>depts=newHashMap<String,Dept>();B.Map<Integer,String>depts=newHashMap<Integer,String>();C.Map<Integer,Emp>depts=newHashMap<Integer,Emp>();D.Map<Integer,Dept>depts=newHashMap<Integer,Dept>();正确答案下列选项中，能填入空白处4的代码是( 正确答案下列选项中，能填入空白处5的代码是 正确答案IO类实现了打开并一个文本文件，每次一行内容。将每行作为一个String字符串放String5publicclassIOpublicString[]read(InputStreamin)throwsIOException{String[]arr=newString[1];String[]temp=空白处1Stringlinewhile(( 空白处2 )!=null){arr[arr.length-1]=line;for(inti=0;i<arr.length;i++)temp[i]=}for(inti=0;i<arr.length;i++){arr[i]=temp[i];}}arr=newString[temp.length-for(inti=0;i<arr.length;i++){arr[i]=temp[i];}}publicstaticvoidmain(String[]args)throwsIOExceptionString[]arr=newIO().read(newFileInputStream("data.txt"));空白处5}}}下列选项中，能填入空白处1的代码是 BufferedReaderbr=newBufferedReader(newBufferedReaderbr=newBufferedReader(newFileReaderbr=newInputStreamReaderbr=new正确答案下列选项中，能填入空白处2的代码是 line=line=line=line=正确答案下列选项中，能填入空白3的代码是 temp=newString[arr.length+temp=newtemp=newString[arr.length-temp=new正确答案下列选项中，能填入空白处4的代码是 arr=newarr=newString[temp.length-arr=newarr=new正确答案下列选项中，能填入空白处5的代码是 for(arr:Stringstr)for(arr[]:Stringfor(Stringstr:arr)for(Stringstr:arr[])有产品表123Aniseed4ChefAnton's有订单表56有订单详细表59据现需要查询产品表中所有产品的idSQLSELECTProductId,UnitPrice,(SELECTAVG(unitpriceFROMProducts)AS"均价",UnitPrice(SELECTAVG(unitprice)FROMProducts)AS"差额"FROMProductsSELECTProductId,UnitPrice,(SELECTAVG(unitpriceFROMProducts)ASUnitPriceAVG(unitpriceASFROMSELECTProductId,UnitPrice,AVG(unitpriceASUnitPriceAVG(unitpriceAS额”FROMProductsSELECTProductId,UnitPrice,AVG(unitpriceASUnitPriceAVG(unitpriceAS额”FROMProductsGROUPBYProductID正确答案SELECT*FROMProductsORDERBYUnitPriceWHERESELECT*FROMProductsORDERBYUnitPriceDESCWHERESELECT*FROMProductsWHEREUnitPrice=(SELECTMIN(UnitPrice)FROMSELECT*FROMProductsWHEREUnitPrice=正确答案5种商品的ID（提示：OrderDetailsty）,下列SQL（）SELECTProductId,SUM(ty)AS"Sum"FROMOrderDetailsGROUPBYProductIDHAVINGROWNUM<=5SELECTProductId,SUM(ty)AS"Sum"FROMorderdetailsGROUPBY