编写一段PowerBuilder中的嵌入式SQL语句,向表employee的Address和Name列分别插入数据“济南”、“王伟”。
应用程序B想要在同一事务中多次读取表EMPLOYEE中的行子集。为了保证每次都能返回相同的行子集,应该使用哪种隔离级别?()
10. abstract public class Employee { 11. protected abstract double getSalesAmount(); 12. public double getCommision() { 13. return getSalesAmount() * 0.15; 14. } 15. } 16. class Sales extends Employee { 17. // insert method here 18. } Which two methods, inserted independently at line 17, correctly complete the Sales class?()
20. public float getSalary(Employee e) { 21. assert validEmployee(e); 22. float sal = lookupSalary(e); 23. assert (sal>0); 24. return sal; 25. } 26. private int getAge(Employee e) { 27. assert validEmployee(e); 28. int age = lookupAge(e); 29. assert (age>0); 30. return age; 31. } Which line is a violation of appropriate use of the assertion mechanism?()
Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?()
现有表Employee,字段:id(int)、firstname(varchar)、lastname(varchar);以下sql语句错误的是()
The EMPLOYEE tables has these columns: You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?()
你正为Wingover公司开发一个Windows应用程序。为了加快开发时间,你从另一个应用程序中继承了一个employee窗口程序首行有一个严格的语句,那么以下不属于这个语句给这个应用程序带来的影响的选项是:()
在oracle数据库中,你想访问EMPLOYEE表中的employee列该列的数据存储在操作系统文件中,你需要在表中增加一列,选择什么数据类型?()
假设类模板Employee有static数据成员count,如从类模板实例化三个模板类。那么有多少个static数据成员?各有什么限制?