finalist在线面试题.docVIP

答题统计: 共30道题， 总分30分 答对13道， 得13分， 答题用时34分钟 基本技能 SQL RDB:?? 3/5 Servlet:?? 3/7 Java SE - Basic:?? 3/7 UML:?? 2/4 JavaScript:?? 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 = 10000 B. SELECT * FROM EMP WHERE 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 | OCCUPATION10 ?????| 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:colorbluerednullblueWhat 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 an