电讯盈科笔试题

Solutions Candidate Test一.Core java (每题5分,共8题,总40)1. Which declarations of identifiers are legal?A. $personsB. TwoUsersC. *pointD. t hisE. endline2. Which are syntactically valid statement at”//point x”?class Person {private int a;public int change(int m){ return m; }}public class Teacher extends Person {public int b;public static void main(String arg[]){Person p = new Person();Teacher t = new Teacher();int i;// point x}}A. i = m;B. i = b;C. i = p.a;D. i = p.change(30)3. What will happen when you attempt tocompile and run the following code?public class Static{static{int x = 5;}static int x,y;public static void main(String args[]){x--;myMethod();System.out.println(x + y + ++x);}public static void myMethod(){y = x++ + ++x;}}A. compiletime errorB. print 1C. p rint 2D. p rint 3E. pirnt 7F. print 84. Given the following code, what will be theoutput?class Value{public int i = 15;}public class Test{public static void main(String argv[]){Test t = new Test();t.first();}public void first(){int i = 5;Value v = new Value();v.i = 25;second(v, i);System.out.println(v.i);}public void second(Value v, int i){i = 0;v.i = 20;Value val = new Value();v = val;System.out.println(v.i + " " + i);}}A. 15 0 20B. 15 0 15C. 20 0 20D. 0 15 205. What will be the result of executing thefollowing code?boolean a = true;boolean b = false;boolean c = true;if (a == true)if (b == true)if (c == true) System.out.println("Some things are true in this world");else System.out.println("Nothing is true inthis world!");else if (a && (b = c))System.out.println("It's too confusing to tell what is true and what is false");else System.out.println("Heythis won't compile");A. The code won’t compile.B. “some things are t rue in thisworld” will be printedC. “hey this won’t compile” will beprintedD. None of these6. What results from attempting to compile andrun the following code?public class Ternary{public static void main(String args[]){int a = 5;System.out.println("Value is - " + ((a < 5) ? 9.0 : 9));}}A. print:Value is -9B. print:Value is -5C. C ompilation errorD. n one of these7. In the following pieces of code, A and D willcompile without any error. True/False?A. StringBuffer sb1 = "abcd";B. Boolean b = new Boolean("abcd");C. b yte b = 255;D. i nt x = 0x1234;8. Which of the following collection classesfrom java.util package are Thread safe?A. VectorB. ArrayListC. H ashmapD. H ashtable二.J2EE (共2题, 每题5分, 总10)9. In java web developing , which component isoften use for C in M-V-C?F. ResinG. A pacheH. S trutsI. Velocity10. which url-pattern in servlet config is legal?A. /path/*.doB. /*/doC. /do/*D. a ll above 11. which method is contained in Servlet classbut not in HttpServlet?A. doGetB. doHeadC. s erviceD. d oPost三.Web编程(共3题,每题5分, 共15分)12. Which layout manager is used when theframe is resized the buttons's position in theFrame might be changed?A. BorderLayoutB. FlowLayoutC. C ardLayoutD. G ridLayout13. Define a array in js, which is right?A. var txt = new Array="G","J","T"B. var txt = new Array(1:"G",2:"J",3:"Ts")C. v ar txt = new Array("G","J","T")D. v ar txt = newArray:1=("G")2=("J")3=("T")14. which tech is AJAX base on?A. javaB. javascriptC. c ssD. x ml四.ORACLE题(3题, 每题5分, 共15)15. 设有图书管理数据库：图书(总编号C(6),分类号C(8),书名C(16),作者C(6),出版单位C(20),单价N(6,2))读者(借书证号C(4),单位C(8),姓名C(6),性别C(2),职称C(6),地址C(20))借阅(借书证号C(4),总编号C(6),借书日期D(8))查询每个出版单位出版的书数量。

SQL语句正确的是______。

A. SELECT MAX(出版单位) FROM 图书B. SELECT 出版单位,count(*) FROM 图书GROUP BY 出版单位C. SELECT 出版单位, max(*) FROM 图书D. SELECT 出版单位, 总编号FROM 图书GROUP BY 出版单位16. 3个表同15.请统计每本书的借阅次数(包括0次的)A. SELECT 图书.书名,COUNT(借阅. 总编号) FROM 图书,借阅WHERE 图书.总编号=借阅.总编号GROUP BY借阅.总编号B. SELECT图书.书名,COUNT(借阅. 总编号) FROM 图书,借阅WHERE 图书.总编号(+)=借阅.总编号GROUP BY 图书.书名C. SELECT图书.书名,COUNT(借阅. 总编号) FROM 图书,借阅WHERE 图书.总编号=借阅.总编号(+) GROUP BY 图书.书名D. SELECT 借阅.总编号,COUNT(借阅. 总编号) FROM 图书,借阅WHERE 图书.总编号=借阅.总编号GROUP BY借阅.总编号17. 表结构同上.查询读者为女的数量.sql正确的是A. SELECT count(*) FROM 读者B. SELECT count(*) FROM 读者WHERE性别=’女’C. SELECT count(*) FROM 读者group by性别D. SELECT count(*) FROM 读者ORDERBY 性别五.PL/SQL测试18. You are formulating a SQL statement to retrieve date from Oracle.Which of the following SQL statments are invaild?A. select NAME,Jersey_No whereJersey_No=6;B. select NAME,Jersey_No from PLAYERS;C. select * from PLAYERS whereJersey_No=6;D. select Jersey_No from PLAYERS;19. Inspect the following SQL statment: SELECTCOW_NAME,MOD(CARTON,FILL_STATUS) FROM COW_MILKGROUP BY COW_NAME;Which of following lines contains an error?A.select COW_NAME;B.mod(CARTON,FILL_STATUS);C.from COW_MILK;D.group by COW_NAME;E.There are no errors in this statement;20. You are coding a complex PL/SQL block where several procedures callother procedures.You have one outermost procedure that calls all otherprocedures.If you wanted to prevent the user of outermost procedure fromhaving the procedure fail due to an unanticipated problem,you wouldinclude which of the following exceptions?A.no_data_found;B.others;C.zero_divide;D.too_many_rows;21. You are attempting to develop a PL/SQL application.Which of the following keywords allow you to associate a user-defined error message with an exception condition?A. PragmaB. othersC. raise_application_errorD. exception22. You are processing some data changes in your SQL*PLUS session as part of one transaction. Which of the following choices does not typically indicate the end of a transaction?A.Issuing an update statement.B.Issuing a commit statment.C.Issuing a rollback statment.D.Ending your session23. You have just removed 1,700 rows from a table that were no longer needed.In order to save the changes you've made to the database,which of the following statement are used?A.savepoint.mit.C.rollback.D.set transation.24. You are creating some tables in your database as part of the logical data model. Which of the following constraints have an index associated with them that is generated automatically by Oracle?A.UNIQUEB.FOREIGN KEYC.CHECKD.NOT NULL25. You are using SQL operation in Oracle.All of the following DATE functions return a Date datatype,except one.Which one is it?A.NEW_TIMEST_DAYC.ADD_MONTHSD.MONTHS_BETWEEN.26. You issue a select statment on theBANK_ACCT table containing the order by clause.Which of the following uses of the order by clause would produce an error?A.order by acctno DESC.B.order by 1;C.order by sqrt(1);D.order by acctno ASC;27. You execute the query select 5+4 from DUAL.You have never insertd data into the DUAL table before.Which of the following statement best describes the DUAL talbe?A.Dictionary view containing two schema namesB.Table with one column and one row used in various operationsC.Dictionary view containing two index namesD.Table with two columns and no rows used in various operations28. You issue the following statment:selectDECODE(ACCTNO,123456,'CLOSED',654321,' SEIZED',590395,'TRANSFER','ACTIVE')from BANK_ACCT;if the value for ACCTNO is 503952,what infomation will this statment display?A.ACTIVEB.TRANSFERC.SEIZEDD.CLOSED29. You are entering several dozen rows of data into the BANK_ACCT table.Which of the following statements will enable you to execute the same statment again and again,entering different values for variables at stement runtime?A.insert into BANK_ACCT(ACCTNO,NAME) VALUES(12346,'SMITH');B.insert into BANK_ACCT(ACCTNO,NAME) VALUES(VAR1,VAR2);C.insert into BANK_ACCT(ACCTNO,NAME) VALUES(&VAR1,&VAR2);D.insert into BANK_ACCT(select ACCTNO,NAME from EMP_BANK_ACCTS); 30. You execute the following SQLstatment:select ADD_MONTHS('28-APR-97',120) from dual.What will Oracle return?A.28-APR-03B.28-APR-07C.28-APR-13D.28-APR-1731. On Monday,June 26,2037,at 10:30 at night,you issue the following statement against an Oracle database:ALTER SESSION SETNLS_DATE_FORMAT='DAY MONTHDD,YYYY:HH:MIAM';Then, you issue the following statementSELECT SYSDATE FROM DUAL;What will Oracle return?A.26-JUN-37B.June 26 2037,22:30C.26-JUN-2037D.MONDAY JUNE 26,2037:10:30PM32. You wish to join the data from two tables,A and B,into one result set and display that set in your session.Tables A and B have a common column,called C in both tables.Which of the following choices correctly displays the where caluse you would use if you wantd to see the data in table A where the value in column C=5,even when there was no corresponding value in table B?A.where A.C=5 AND A.C=B.C;B.where A.C=5 AND A.C=B.C(+);C.where A.C=5 AND A.C(+)=B.C(+);D.where A.C=5;33. Each of the following statment is true about referential integrity,except one. Which is it?A.The referencing column in the child table must correspond with a primay key in the parent.B.All values in the referenced column in parent table must be present in the referencing column in the child.C.The datatype of the referenced column in the parent table must be identical to the referencing column in the child.D.All values in the referencing column in the child table must be present in the referenced column in the parent.34. You have a situation where you need to use the NVL() function.ALL the following statement about the nvl() function are true exceptone.Which is it?A.nvl() returns the second value passed if the first value is null.B.nvl() handles values of many different datatypes.C.nvl() returns NULL if the first value is not equal to the second.D.Both the values passed for nvl() must be the same datatype.35. You are developing a stored procedure that handles table data.The %rowtype expression in PL/SQL allows you to declare which ofthe following kinds of variables?A.RecordsB.VARCHAR2sC.PLS_INTEGERsD.NUMBERS36. You create a sequence with the following statement:CREATE SEQUENCE MY_SEQSTART WITH 394INCRMENT BY 12NOMINVALUENOMAXVALUENOCACHENOCYCLEThree users have already issued SQL statment to obtain NEXTVAL,andfour more have issued SQL statment to obtain CURRVAL.If you issue aSQL statment to obtain the NEXTVAL,what will ORACLE return?A.406B.418C.430D.44237. Afer creating a view,you realize that serveral columns were left outWhich of the following statements would you issue in order to add somecolumns to your view?A.alter viewB.create or replace viewC.insert into viewD.create view六.算法题(5分)38. 编写Java代码，打印如下的杨辉三角。