考題第二次下列代碼運行結(jié)果是

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=正確答案下列關(guān)于線程的名字說法正確的是：（）Java規(guī)定所有的線程名字都是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列上創(chuàng)建一個主鍵約束pk_books（）A.CREATEPRIMARYKEYONB.CREATECONSTRAINTpk_booksPRIMARYKEYONC.ALTERTABLEbooksADDCONSTRAINTpk_booksPRIMARYKEYD.ALTERTABLEbooksADDPRIMARYKEY正確答案在Oracle中，現(xiàn)有Student表，其中包括學號stuId,stuName,成績stuGrade，現(xiàn)要查詢成績?yōu)?0分的學生，并且結(jié)果按照學號降序排列，下面查詢語句正確的是（）。A.SELECTstuNameFROMstudentWHEREstuGrade=80ORDERBYstuIdB.SELECTstuNameFROMstudentWHEREstuGrade=80ORDERBYstuIdDESCC.SELECTstuNameFROMstudentWHEREstuGradelike80GROUPBYstuIdD.SELECTstuNameFROMstudentWHEREstuGrade=80GROUPBYstuIdDESC正確答案一個VIEW被以下語句創(chuàng)建，請問在該VIEW：（）CREATEVIEWASSELECT*FROMstateWHEREcnt_code=1WITHREADONLY;B.SELECT,UPDATEC.SELECT,DELETED.SELECT,INSERT正確答案ResultSet（）查詢結(jié)束后，所有的結(jié)果數(shù)據(jù)將一次被在ResultSet對象Statementclose后，由其創(chuàng)建的ResultSet查詢結(jié)束后，ResultSetnext()才有可能取正確答案如果查詢表a3行數(shù)據(jù))和表b（4），使用SELECT*FROMa,b，返回的查詢結(jié)正確答案下列選項中能夠得到字符串的一部分的單行函數(shù)是（）正確答案publicclassTestTwoimplementsRunnablepublicstaticvoidmain(String[]args)throwsException{Threadt=newThread(newTestTwo());}publicvoidrun()for(inti=0;i<4;i++){}}}正確答案下列屬于DML：（）正確答案下列代碼所構(gòu)建的流，能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);正確答案下面不屬于接口的是：（）正確答案下列代碼的運行結(jié)果是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正確答案下列代碼的運行結(jié)果是（）publicclass implementsSerializable{privateTreetree=newTree();publicstaticvoidmain(String[]args){f=new tryFileOutputStreamfs=newFileOutputStream(" ObjectOutputStreamos=newObjectOutputStream(fs);}catch(Exceptionex){}}}classTree的實例和Tree正確答案OracleSELECTDISTINCTnameFROMSELECTnameDISTINCTFROMSELECTnameFROMSELECTnameFROMuserLIMIT正確答案RuntimeException：（） 正確答案正確答案ResultSetNUMBER該字段值的方法是：()。正確答案關(guān)于Java（）try……catch語句中對tryExceptionthrowsMainthrows正確答案12345有一個數(shù)據(jù)表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()方返回一個結(jié)果Statement的executeUpdate()方返回是否更新成功的booleanResultSet中的getStringcharResultSet中的next()方使結(jié)果集中的下一行成為當前正確答案操作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();}}為了確保輸出結(jié)果是“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表的表結(jié)構(gòu)如下：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();//獲取數(shù)據(jù)庫連接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類實現(xiàn)了打開并一個文本文件，每次一行內(nèi)容。將每行作為一個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[])有產(chǎn)品表123Aniseed4ChefAnton's有訂單表56有訂單詳細表59據(jù)現(xiàn)需要查詢產(chǎn)品表中所有產(chǎn)品的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