finalist在线面试题.doc

答题统计:共30道题， 总分30分 答对13道， 得13分， 答题用时34分钟 基本技能SQL & RDB:3/5Servlet:3/7Java SE - Basic:3/7UML:2/4JavaScript:2/7可选技能答题明细:第1题题目分类：SQL & RDBWhich of these statements about a foreign key are true? A.A foreign key can reference a primary key of another table. B.A foreign key can reference an arbitrary group of columns of another table. C.A foreign key can reference a primary key of the same table. D.A foreign key can reference any group of columns of the same table. E.Columns that belong to a foreign key cant have null values.你选的答案： A C E 测试结果： 第2题题目分类：SQL & RDBConsider a table with data as follows:Table Name: EMPColumns:ID NUMBER(4) Primary KeyNAME varchar(20) NOT NullSALARY NUMBER(5)Which of the following SELECT statements produce the same output as SELECT * FROM EMP WHERE SALARY BETWEEN 1000 AND 10000 ? A.SELECT * FROM EMP WHERE SALARY = 1000 AND SALARY 1000 AND SALARY 10000 C.SELECT * FROM EMP WHERE SALARY IN (1000,10000) 你选的答案： A 测试结果： 第3题题目分类：SQL & RDBGiven the following table called Employees with 1 row.EMP_ID | SURNAME | FIRST_NAME | OCCUPATION-10 | Smith | John | programmerYou want to delete this row. Choose the correct DELETE command(s). A.DELETE FROM EMPLOYEES WHERE EMP_ID = 10 B.DELETE FROM EMPLOYEES WHERE EMP_ID = 10 C.DELETE FROM EMPLOYEES WHERE EMP_ID IS (10) D.DELETE FROM EMPLOYEES WHERE EMP_ID IN (10)你选的答案： A D 测试结果： 第4题题目分类：SQL & RDBAssume the following table named cars:color-bluerednullblueWhat is the result of the following query:SELECT COUNT(DISTINCT color) FROM cars A.redbluenull B.211 C.2 D.3你选的答案： C 测试结果： 第5题题目分类：SQL & RDBWhat is TRUE about the UNION command? A.UNION will select distinct values. B.UNION ALL will show all values, regardless if they are unique or not. C.When using the UNION command, all selected columns need to be the same data type respectively D.UNION command and JOIN command are identical.你选的答案： C D 测试结果： 第6题题目分类：ServletWhich of the following statements are TRUE? A.The servlet class files can be kept in a sub-directory of WEB-INF named classes. B.The deployment descriptor file can be kept OUTSIDE the WEB-INF directory as long as it has been properly mapped. C.Files kept in the WEB-INF directory of a web application CANNOT be accessed by a client directly. D.Files kept in the WEB-INF directory of a web application CAN be accessed by a client directly. E.We can not say anything as deployment rules change from server to server.你选的答案： B D 测试结果： 第7题题目分类：ServletGiven the following web.xml for a web application: TestServlet /requestinfo.jsp TestServlet *.a What applies? A.A JSP file cannot be used in a tag. B.A JSP file cannot be used in a tag. C.Although the mapping is valid, a request to /xxx/hello.a will result in an exception. D.A request to /hello.a will be handled by requestinfo.jsp E.A request to /requestinfo.jsp will result in an exception.你选的答案： D 测试结果： 第8题题目分类：Servletselect the possible ways to send an Http redirect ? A.set the Http status code and add the location header to the response B.use the sendRedirect() method of HttpServletResponse C.use the sendRedirect() method of HttpServletRequest D.none of above你选的答案： A B 测试结果： 第9题题目分类：ServletYou are calling your servlet by typing the following address.http:/localhost:8080/ServletTest/MZServlet.mz?paramNameWhat will be the result, returned byServletRequest.getParameter(paramName) call inside your servlet? A.empty string B.null string C.paramName D.exception would be thrown E.the result cannot be predicted and depends on web container你选的答案： B 测试结果： 第10题题目分类：ServletWhich of the following statements are true for the HTTP HEAD method? A.It is identical to the GET method and NEEDS a message-body in the response from the server. B.This method is often used for testing hypertext links for validity, accessibility, and recent modification. C.The HEAD method requests that the origin server delete the resource identified by the Request-URI. D.This method can be used for obtaining meta information about the entity implied by the request. E.It is identical to the GET method except that the server MUST NOT return a message-body in the response.你选的答案： A B E 测试结果： b e 第11题题目分类：ServletGiven the web application deployment descriptor element: param javablackbelt With which line of code could you retrieve the context parameter value? A.Object result = getServletContext().getParameter(param); B.Object result = getServletConfig().getInitParameter(param); C.String result = getServletContext().getInitParameter(param); D.String result = getServletContext().getAttribute(param);你选的答案： C 测试结果： 第12题题目分类：ServletWhich scopes can be used to store attributes in the Servlet based application:Notation: scopeName (CorrespondingType) A.application (ServletContext) B.request (ServletRequest) C.response (ServletResponse) D.session (HttpSession) E.servlet config (ServletConfig)你选的答案： A C D E a b d 测试结果： 第13题题目分类：Java SE - BasicWhen might your program wish to run the garbage collector? A.before it enters a compute-intense section of code B.before it enters a memory-intense section of code C.when it knows there will be some idle time D.before objects are finalized E.All the above F.None你选的答案： A B C D E bcd测试结果： 第14题题目分类：Java SE - BasicThe transient keyword is used as part of which mechanism? A.Design patterns B.Polymorphism C.Reflection D.Serialization你选的答案： D 测试结果： 第15题题目分类：Java SE - BasicWhich of the following can you perform using the File class? A.Change the current directory B.Return the name of the parent directory C.Delete a file D.Find if a file contains text or binary information你选的答案： A B C D 测试结果： 第16题题目分类：Java SE - BasicWhat is the default scope of an instance variable or method? A.public B.protected C.private D.static E.package你选的答案： C 测试结果： 第17题题目分类：Java SE - BasicWhich of the following statements are true for StringBuffers (java.util.StringBuffer )? A.StringBuffer class is used to represent strings that can be modified B.Objects of type StringBuffer are read only C.Objects of type StringBuffer are immutable D.StringBuffer is more efficient than String when performing concatenations in most situations你选的答案： A C D 测试结果： 第18题题目分类：Java SE - BasicWhich code is faster? 1. or 2.?1.1:String string = new String(); 2:int length = 2000; 3:for(int i = 0; ilength; i+) 4: string += Hello world.; 5: 2.1:StringBuffer stringBuffer = new StringBuffer(); 2:int length = 2000; 3:for(int i = 0; ilength; i+) 4: stringBuffer.append(Hello world.); 5: A.Compilation error. B.1. C.2. D.Speeds of 1. and 2. option are not different. Speeds of 1. and 2. are the same.你选的答案： C 测试结果： 第19题题目分类：Java SE - BasicSelect the interfaces/classes that can be ordered using Collections.sort A.ArrayList B.Collections C.Vector D.Set E.List你选的答案： A C E 测试结果： 第20题题目分类：UMLWhich words are UML keywords ? A.include B.volatile C.stereotype D.generic E.extend你选的答案： A D E 测试结果： 第21题题目分类：UMLGiven the following description:Person object completely owns the Address object, so that it doesnt exist outside of the Person object.Which image reflects the scenario described above? A.a B.b C.None of the above.你选的答案： B 测试结果： 第22题题目分类：UMLThe following are UML diagrams: A.Activity diagram. B.Use case diagram. C.Class diagram. D.Database diagram. E.Sequence diagram.你选的答案： A B C E 测试结果： 第23题题目分类：UMLThe purpose of behavioral diagrams is as follows: A.To show the static structure of the system being modeled. B.To show the dynamic behavior between the objects in the system. C.Both the above. D.None of the above.你选的答案： C 测试结果： b第24题题目分类：JavaScriptWhich of the following lines of code will print to the page the text:His name was Henry Sky Philips ? A.document.write(His name was Henry Sky Philips); B.document.write(His name was Henry Sky Philips); C.document.write(His name was Henry Sky Philips); D.document.write(His name was Henry Sky Philips); E.document.write(His name was Henry Sky Philips);你选的答案： C D 测试结果： 第25题题目分类：JavaScriptWhat events will be triggered when mouse button is released without moving the cursor? A.onmouseup and onclick B.onclick and onmouseover C.onmouseover and onmouseup D.onmousemove and onmousedown你选的答案： A 测试结果： 第26题题目分类：JavaScriptThe unescape function is deprecated since JavaScript 1.5. Which of the followin