结构S_Employee和类C_Employee定义分别如下：<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080114140311337.jpg?sign=12a59d4626b5bcde4446304754100250&t=62d1ee85" /><br /> 请问以下代码执行后，e1，e2，c1，c2的Name和Salary值分别是多少？<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080114141554090.jpg?sign=a50ea15e59341bdf2cf350d75faad403&t=62d1ee85" />..

第1题

[单选题] Click the Exhibit button to examine the data of the EMPLOYEES table. Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）

A、SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;  B、SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;  C、SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary > 4000;  D、SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id", m.emp_name "Manager" FROM employees e SELF JOIN employees m WHERE e.mgr_id = m.employee_id AND e.salary > 4000;  E、SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id" m.emp_name "Manager" FROM employees e JOIN employees m USING (e.employee_id = m.employee_id) AND e.salary > 4000;  

点击查看答案

第2题

[单选题] 您已创建一个名为 CalcSalary，将确定 Certkiller.com 员工的薪酬类的责任。CalcSalary 类包括员工的薪酬递增和递减的方法。下面的代码包含在 CalcSalary 类中：（）public class CalcSalary {// for promotionspublic static bool IncrementSalary (Employee Emp, double Amount){if (Emp.Status == QuarterlyReview.AboveGoals)Emp.Salary += Amount;return true;

A、public delegate bool Salary (Employee Emp, double Amount);  B、public bool Salary (Employee Emp, double Amount);  C、public event bool Salary (Employee Emp, double Amount);  D、public delegate void Salary (Employee Emp, double Amount);  

点击查看答案

第3题

[单选题] Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 HR_MGR 5000 106 Bryan 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）

A、SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;  B、SELECT e.employee_id "Emp_id", e.emp_name "Employee",  C、salary,  D、employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;  

点击查看答案

第4题

[] Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement: SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary > 4000; What is its output?（） Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement: SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary > 4000; What is its output?（）

A、A.A  B、B.B  C、C.C  D、D.D  E、E.E  

点击查看答案

第5题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id =180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp set name = 'James' WHERE employee_id =180; Rollback; At the end of this transaction, what is true?（）

A、You have no rows in the table.  B、You have an employee with the name of James.  C、You cannot roll back to the same savepoint more than once.  D、Your last update fails to update any rows because employee ID 180 was already deleted.  

点击查看答案

第6题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id =180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp set name = 'James' WHERE employee_id =180; Rollback; At the end of this transaction, what is true?（）

A、You have no rows in the table.  B、You have an employee with the name of James.  C、You cannot roll back to the same savepoint more than once.  D、Your last update fails to update any rows because employee ID 180 was already deleted.  

点击查看答案

第7题

[单选题] You work as an application developer at Certkiller .com. You have been given the responsibility of creating a class named CalcSalary that will determine the salaries of Certkiller .com’s staff. The CalcSalary class includes methods to increment and decrement staff salaries. The following code is included in the CalcSalary class： public class CalcSalary { // for promotions public static bool IncrementSalary （Employee Emp， double Amount） { if （Emp.Status == QuarterlyReview.AboveGoals） Emp.Salary += Amount； return true； } else return&#

A、&ensp;public&ensp;delegate&ensp;bool&ensp;Salary&ensp;（Employee&ensp;Emp，&ensp;double&ensp;Amount）；  B、&ensp;public&ensp;bool&ensp;Salary&ensp;（Employee&ensp;Emp，&ensp;double&ensp;Amount）；  C、&ensp;public&ensp;event&ensp;bool&ensp;Salary&ensp;（Employee&ensp;Emp，&ensp;double&ensp;Amount）；  D、&ensp;public&ensp;delegate&ensp;void&ensp;Salary&ensp;（Employee&ensp;Emp，&ensp;double&ensp;Amount）；  

点击查看答案

第8题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employe_id NUMBER, name VARCGAR2(30)); INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id=180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp sey name = 'James' Where employee_id=180; Rollback; At the end of this transaction, what is true?（）

A、You have no rows in the table.  B、You have an employee with the name of James.  C、You cannot roll back to the same savepoint more than once.  D、Your last update fails to update any rows because employee ID 180 was already deleted.  

点击查看答案

第9题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employe_id NUMBER, name VARCGAR2(30)); INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id=180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp sey name = 'James' Where employee_id=180; Rollback; At the end of this transaction, what is true? （）

A、You have no rows in the table.  B、You have an employee with the name of James.  C、You cannot roll back to the same savepoint more than once.  D、Your last update fails to update any rows because employee ID 180 was already deleted.  

点击查看答案

请使用微信扫码支付