单选题According to the contract, the salary of the employee _____.A is paid weeklyB is adjusted every quarterC is re-examined from year to yearD is fixed for the whole contract period

题目
单选题
According to the contract, the salary of the employee _____.
A

is paid weekly

B

is adjusted every quarter

C

is re-examined from year to year

D

is fixed for the whole contract period

相似考题

1.The salary as ()the contract will be transferred monthly to the representative’s account.A、inB、atC、onD、within

2.阅读以下说明C++代码，将应填入(n)处的字句写在对应栏内。[说明]本程序实现了雇员信息管理功能，其中封装了雇员信息及其设置、修改、删除操作。已知当输入为“Smith 31 2960.0”时，程序的输出是：姓名：Smith 年龄：31 工资：2960姓名：Smith 年龄：31 工资：3500姓名：Mary 年龄：23 工资：2500[C++程序]include ＜iostream.h＞include ＜string.h＞class employee{char *name; //雇员姓名short age; //年龄float salary;//工资public:employee();void set_name(char *);void set_age(short a) {age=a;}void set_salary(float s) {salary=s;}(1);~ employee(){delete[] name;}};employee::employee() { name="";age=0;salary=0.0;void employee::set_name(char *n){ name=new char[strlen(n)+1];(2) (name,n);}void employee::print(){ cout＜＜"姓名":"＜＜name＜＜" 年龄:"＜＜agc＜＜" 工资:" ＜＜salary＜＜endl;}void main(){ char *na;short ag=0;float sa=0;(3);na=new char[10];cin＞＞na＞＞ag＞＞sa;emp.set_name(na);emp.set_age(ag);emp.set_salary(sa);emp.print();(4) (3500.0);emp.print();(5);emp.set_name("Mary");emp.set_age(23);emp.set_salary(2500.0);emp.print();}

3.Examine the data in the EMPLOYEES and EMP_HIST tables:The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.Which statement accomplishes this task?（）A.B.C.D.

4.授予用户U1，U2和U3在关系employee的salary属性上的UPDATE权限的语句是【 】UPDATE(salary) ON employee TO U1，U2，U3

更多“According to the contract, the salary of the employee _____.”相关问题

  • 第1题：

    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)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.

    B.

    C.

    D.

    E.


    参考答案：C

  • 第2题：

    Evaluate the SQL statement:What is the result of the statement?()

    A. The statement produces an error at line 1.

    B. The statement produces an error at line 3.

    C. The statement produces an error at line 6.

    D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

    E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.


    参考答案：E

  • 第3题：

    回收用户U1，U2和U3在关系employee的salary属性上的UPDATE限的语句是

    A．REVOKE UPDATE(salary) ON employee(U1，U2，U3)

    B．REVOKE UPDATE(salary)ON employee FROM U1，U2，U3

    C．REVOKE UPDATE ON employee FROM U1，U2，U3

    D．REVOKE UPDATE(salary) FROM U1，U2，U3


    正确答案：B
    解析：回收用户U1，U2和U3在关系employee的salary属性上的UPDATE权限的语句是REVOKEUPDATE(salary)ONemployeeFROMU1，U2，U3。

  • 第4题：

    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;


    参考答案：C

  • 第5题：

    （） is the operation to check the quantity, quality and package of the goods according to the contract and the specific standard

    • A、Inspection 
    • B、Examination 
    • C、Control 
    • D、Test

    正确答案:A

  • 第6题：

    Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）

    • A、17000.00
    • B、17000*****
    • C、****170.00
    • D、**17000.00
    • E、an error statement

    正确答案:E

  • 第7题：

    Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）

    • A、17000.00
    • B、17000*****
    • C、****170.00
    • D、**17000.00
    • E、an error statement

    正确答案:D

  • 第8题：

    单选题
    在Oracle中，你需要创建索引提高薪水审查的性能，该审查要对员工薪水提高12个百分点后进行分析处理，下面哪个createindex命令能解决此问题（）。
    A

    CREATE INDEX my_idx_1 ON employee（salary*1.12）

    B

    CREATE UNIQUE INDEX my_idx_1 ON employee（salary）

    C

    CREATE BITMAP INDEX my_idx_1 ON employee（salary）

    D

    CREATE INDEX my_idx_1 ON employee（salary）REVERSE


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
    A

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary

    B

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent

    C

    SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary

    D

    You cannot find the information because there is no common column between the two tables.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement?（）
    A

    The statement produces an error at line 1.

    B

    The statement produces an error at line 3.

    C

    The statement produces an error at line 6.

    D

    The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

    E

    The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200.   The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：   SQL>UPDATE EMPLOYEE  SET SALARY = 2000   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：   SQL>UPDATE EMPLOYEE  SET SALARY = 2400   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’   SQL>UPDATE EMPLOYEE  SET SALARY = 2900   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）
    A

     Flashback Drop

    B

     Flashback Table

    C

     Flashback Database

    D

    Flashback Version Query


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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;


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Examine the data in the EMPLOYEES and EMP_HIST tables:EMPLOYEESNAME DEPT_ID MGR_ID JOB_ID SALARYEMPLOYEE_ID101 Smith 20 120 SA_REP 4000102 Martin 10 105 CLERK 2500103 Chris 20 120 IT_ADMIN 4200104 John 30 108 HR_CLERK 2500105 Diana 30 108 IT_ADMIN 5000106 Smith 40 110 AD_ASST 3000108 Jennifer 30 110 HR_DIR 6500110 Bob 40 EX_DIR 8000120 Ravi 20 110 SA_DIR 6500EMP HISTEMPLOYEE_ID NAME JOB_ID SALARY101 Smith SA_CLERK 2000103 Chris IT_CLERK 2200104 John HR_CLERK 2000106 Smith AD_ASST 3000108 Jennifer HR_MGR 4500The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.Which statement accomplishes this task?（）

    A. UPDATE emp_hist SET employee_id, name, job_id, salary = (SELECT employee_id, name, job_id, salary FROM employees) WHERE employee_id IN (SELECT employee_id FROM employees);

    B. MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT VALUES (e.employee id, e.name, job id, e.salary);

    C. MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE emp hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);

    D. MERGE INTO emp_hist eh USING employees e WHEN MATCHED THEN UPDATE emp_hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);


    参考答案：B

  • 第14题：

    授予用户U1，U2和U3在关系employee的salary属性上的UPDATE权限的语句是

    A．GRANT ON employee TOU1，U2，U3

    B．GRANT UPDATE ON employee TO U1，U2，U3

    C．GRANT UPDATE(salary) ON employee

    D．GRANT UPDATE(salary)ON employee TO U1，U2，U3


    正确答案：D
    解析：授予用户U1，U2和U3在关系employee的salary属性上的UPDATE权限的语句是GRANT UPDATE(salary) ON employee TO U1，U2，U3。

  • 第15题：

    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

    B.B

    C.C

    D.D

    E.E


    参考答案：A

  • 第16题：

    在Oracle中,你需要创建索引提高薪水审查的性能,该审查要对员工薪水提高12个百分点后进行分析处理,下面哪个createindex命令能解决此问题()。

    A.CREATE INDEX my_idx_1 ON employee（salary*1.12）

    B.CREATE UNIQUE INDEX my_idx_1 ON employee（salary）

    C.CREATE BITMAP INDEX my_idx_1 ON employee（salary）

    D.CREATE INDEX my_idx_1 ON employee（salary）REVERSE


    参考答案：A

  • 第17题：

    Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）

    • A、The database manager will rollback the transaction in both applications.
    • B、The database manager will rollback the transaction in one of the two applications.
    • C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
    • D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

    正确答案:B

  • 第18题：

    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;

    正确答案:C

  • 第19题：

    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 false； } //for demotions public static bool DecrementSalary （Employee Emp， double Amount） { if （Emp.Status == QuarterlyReview.AboveGoals） Emp.Salary -= Amount； return true； } else return false； } } You would like to invoke the IncrementSalary and DecrementSalary methods dynamically at runtime from the sales manager application， and decide to create a delegate named SalaryDelegate to invoke them. You need to ensure that you use the appropriate code to declare the SalaryDelegate delegate.What is the correct line of code？（）

    • 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）；

    正确答案:A

  • 第20题：

    单选题
    您在公司的数据库中成功创建了名为SALARY的表。您现在要通过向引用EMPLOYEES表的匹配列的SALARY表添加FOREIGNKEY约束条件来建立EMPLOYEES表与SALARY表之间的父/子关系。尚未向SALARY表添加任何数据。应执行以下哪条语句（）
    A

    ALTER TABLE salary ADD CONSTRAINT fk_employee_id_01 FOREIGN KEY（employee_id）REFERENCES employees（employee_id）

    B

    ALTER TABLE salary ADD CONSTRAINT fk_employee_id_ FOREIGN KEY BETWEEN salary（employee_id）AND employees（employee_id）

    C

    ALTER TABLE salary FOREIGN KEY CONSTRAINT fk_employee_id_REFERENCES employees（employee_id）

    D

    ALTER TABLE salary ADD CONSTRAINT fk_employee_id_FOREIGN KEY salary（employee_id）=employees（employee_id）


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    According to the contract, the salary of the employee _____.
    A

    is paid weekly

    B

    is adjusted every quarter

    C

    is re-examined from year to year

    D

    is fixed for the whole contract period


    正确答案： C
    解析：
    细节题。文章一开始交待“Salary: Your starting salary is $15,000,This is reviewed annually”。annually每年的，年度的。由此可知，每一个员工的起薪是15,000，这个薪水每年会变。C项为同义转换，from year to year 相当于annually，为正确答案。A、B、D三项均不正确。

  • 第22题：

    单选题
    （） is the operation to check the quantity, quality and package of the goods according to the contract and the specific standard
    A

    Inspection 

    B

    Examination 

    C

    Control 

    D

    Test


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    您已创建一个名为 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);


    正确答案： C
    解析： status 意思 是“状态”。
    你可以用 变量 status 表示 某种状态。
    例如：
    成功，失败
    真，假 1，2，3，4，
    .. 状态1,状态2,状态3,状态4,....

  • 第24题：

    单选题
    Examine the data in the EMPLOYEES and EMP_HIST tables: EMPLOYEES 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 IT_ADMIN 5000 106 Smith 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 EMP HIST EMPLOYEE_ID NAME JOB_ID SALARY 101 Smith SA_CLERK 2000 103 Chris IT_CLERK 2200 104 John HR_CLERK 2000 106 Smith AD_ASST 3000 108 Jennifer HR_MGR 4500 The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table. Which statement accomplishes this task?（）
    A

    UPDATE emp_hist SET employee_id, name, job_id, salary = (SELECT employee_id, name, job_id, salary FROM employees) WHERE employee_id IN (SELECT employee_id FROM employees);

    B

    MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT VALUES (e.employee id, e.name, job id, e.salary);

    C

    MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE emp hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);

    D

    MERGE INTO emp_hist eh USING employees e WHEN MATCHED THEN UPDATE emp_hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);


    正确答案： B
    解析： 暂无解析

相关内容