亚信笔试题翻译后的Word文档下载推荐.docx

1、3、Consider the following application: 1. class Q6 2. public static void main（String args） 3 Holder h=new Holder（）; 4 h.held=100; 5 h.bump（h）; 6 System.out.println（h.held）; 7. 8. 9.10. class Hoder11. public int held;12 public void bump（Holder theHolder）theHolder.held+;13. What value is printed out at

2、 line 6?/思考如下应用，第六行的输出结果是什么？ A、0 B、1C、100D、1014、The demonstrate（s） belongs to “has a” relationship?/选项中哪一项或哪些项是has-a关系？A、 public interface Person public class Employee extends PersonB、 public interface Shape public inter face Recrandle extends ShapeC、 public interface Colorable public calss Shape im

3、plements ColorableD、 public class Species public class Animalprivate Species speciesE、 interface Componet class Container implements Componentprivate Component children;5、Consider the following code:/思考如下代码 1.for（int i=0;i2;i+）2. for（int j=0;j 4000;B.select e.emploee_id ,e.emp_name,e.salary,m.employ

4、ee_id ,m.emp_name from employees e join employees m where e.mgr_id=m.mgr_id and e.salary4000;C. select e.emploee_id from employees e join employees m on （e.mgr_id=m.employee_id） and e.salaryD.select e.emploee_id m.emp_name from employees e self join employese m where e.mgr_id=m.employee_id and e.sal

5、aryE.select e.emploee_id from employees e join employese m USING （e.mgr_id=m.employee_id） and e.salary14. Which two statements about sequences are true ?（choose two）答案是对于序列（sequence）的叙述中,哪两个语句是正确的.（请选择两个正确选项）A.You use a NEXTVAL pseudo column to look at the next possible value that would be generated

6、 from a sequence,without actually retrieving the value用NEXTVAL作为虚拟列, 查看序列生成的下一个的值,而不用检索整个序列 B. You use a CURRVAL pseudo column to look at the current value just generated from a sequence,without affecting the further values to be generated from the sequence用CURRVAL作为虚拟列, 查看序列当前生成的值,而不会影响序列产生下一个值C. Y

7、ou use a NEXTVAL pseudo column to obtain the next possible value that would be generated from a sequence,by actually retrieving the value from the sequence用NEXTVAL作为虚拟列，通过检索序列去获得序列将产生的下一个值D. You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified databa

8、se coumn用currval作为虚拟列，从一个将被一个指定的数据库列使用的序列来产生一个值E、if a sequence starting from a value 100and incremented by 1 is used by more than one application,then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence如果一个序列从100开始，并且步进为1，并被不同的应

9、用使用，然后序列产生的105会被赋给这些应用的列F、You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence使用reuse语句的时候，序列会从上一次产生的最大值（结果）开始产生新的序列15. In which teo cases would you use an outer join?下面哪两种情况你使用外连接?（请选择两个正确答案）（ ）A.The tables being joined

10、 have NOT NULL columns连接的表间都没有空的列B.The tables being joined have only matched data连接的表间只有相匹配的数据C.The columns being joined have NULL values连接的列有空值D. The tables being joined have only unmatched data连接的表间只有不匹配的数据E. The tables being joined have both matched and unmatched data连接的表有相匹配的数据和不相匹配的数据F. Only wh

11、en the tables have a primary Key-foreign key relationship只能在表间存在有主外键的联系16.which two statements complete a transaction?（choose two） 下面哪两个句子完成了事物处理? A. DELETE employees; B. DESCRIBE employees; c. ROLLBACK TO SAVAPOINT C; D. GRANT SELECT ON employees TO SCOTT; E. ALTER TABLE employees SET UNUSED COLUMN

12、 sal; F. SELECT MAX（sal） FROM employees WHERE department_id = 20;17.Click the Exhibit button and exam the data in the EMPLOYEES table.which three subqueries work?（choose three ） 点击展示按钮并且检验EMPLOYEES表里的数据,下面哪三个子查询正确（有效）? A. SELECT * FROM employees where salary （SELECT MIN（salary） GROUP BY department_i

13、d）; B SELECT * WHERE salary = （SELECT AVG（salary） C SELECT distinct department_id FROM employees WHERE salary ANY（SELECT AVG（salary） FROM employees GROUP BY department_id）; D SELECT department_id FROM employees WHERE salary ALL（SELECT AVG（salary） FROM employees GROUP BY department_id）; E SELECT last_name FROM employees WHERE salary ANY（SELECT MAX（salary） F SELECT department_id WHERE salary GROUP BY AVG（salary）; 18. your production database is running in the ARCHIVELOG mode and the ARCn process is functional.you have two online redo log groups.Which thr