You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?（）A、Report level trigger. B、Group filter. C、Format trigger. D、None of the above.
You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?（）
- A、Report level trigger.
- B、Group filter.
- C、Format trigger.
- D、None of the above.
相关考题：
11 Which of the following statements are correct?1 A company might make a rights issue if it wished to raise more equity capital.2 A rights issue might increase the share premium account whereas a bonus issue is likely to reduce it.3 A bonus issue will reduce the gearing (leverage) ratio of a company.4 A rights issue will always increase the number of shareholders in a company whereas a bonus issue will not.A 1 and 2B 1 and 3C 2 and 3D 2 and 4
50) They may teach very well and more than earn their salaries, but most of them make little or no independent reflections on human problems which involve moral judgment.
______(salary)people who earn more than a few thousand dollars must pay a certain percentage of their salaries.
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?() A. To find the tax percentage for each of the employees.B. To list the name, job id, and manager name for all the employees.C. To find the name, salary, and department name of employees who are not working with Smith.D. To find the number of employees working for the Administrative department and earning less then 4000.E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
Examine the data from the EMP table:The COMMISSION column shows the monthly commission earned by the employee.Which three tasks would require subqueries or joins in order to perform in a single step?（）A. Deleting the records of employees who do not earn commission.B. Increasing the commission of employee 3 by the average commission earned in department 20.C. Finding the number of employees who do NOT earn commission and are working for department 20.D. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.E. Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.F. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
Youaredevelopingabonusreportforthepayrollapplicationtocalculateanddisplaythebonusissuetoeachenvelope.Employeeswithasalaryoflessthan50000$earnabonusof15%andtheemployeeswhoearn50000$ormoreearnout10%bonus.Whichtypeoftriggerwouldyouusetoconditionallyassignabonuspercentage?（）A.Reportleveltrigger.B.Groupfilter.C.Formattrigger.D.Noneoftheabove.
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.
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?() A.B.C.D.
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.
Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?() A.to find the tax percentage for each of the employeesB.to list the name, job_id, and manager name for all the employeesC.to find the name, salary, and the department name of employees who are not working with SmithD.to find the number of employees working for the Administrative department and earning less than 4000E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned
Click the Exhibit button and examine the data from the EMP table.The COMMISSION column shows the monthly commission earned by the employee.Which two tasks would require subqueries or joins in order to be performed in a single step? （）A.listing the employees who earn the same amount of commission as employee 3B.finding the total commission earned by the employees in department 10C.finding the number of employees who earn a commission that is higher than the average commission of the companyD.listing the departments whose average commission is more than 600E.listing the employees who do not earn commission and who are working for department 20 in descending order of the employee IDF.listing the employees whose annual commission is more than 6000
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;
你是公司会计数据库的开发者。数据库包含一个名叫Employees的表。Tom是会计部门的一个成员。Tom的数据库用户帐户对表Employees里的列Salary和Bonus Percentage的SELECT权限被拒绝，被授予对其他列的SELECT权限。Tom现在要求访问Employees表里的所有数据。你该怎么做？（）A、废除Tom数据库用户帐户对表Employees里的列Salary和Bonus Percentage的SELECT权限B、添加Tom到db_datareader角色C、添加Tom到db_accessadmin角色D、授予Tom数据库用户帐户对表Employees里的列Salary和Bonus Percentage的SELECT权限。
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.
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）A、ORDER BY SALARY 5000B、GROUP BY SALARY 5000C、HAVING SALARY 5000D、WHERE SALARY 5000
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;
Examine the data from the EMP table: EMP_ID DEPT_ID COMMISSION 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 200 7 10 8 20 300 The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? （）A、Deleting the records of employees who do not earn commission.B、Increasing the commission of employee 3 by the average commission earned in department 20.C、Finding the number of employees who do NOT earn commission and are working for department 20.D、Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.E、Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.F、Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）A、To find the tax percentage for each of the employees.B、To list the name, job id, and manager name for all the employees.C、To find the name, salary, and department name of employees who are not working with Smith.D、To find the number of employees working for the Administrative department and earning less then 4000.E、To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
单选题You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?（）AReport level trigger. BGroup filter. CFormat trigger. DNone of the above.
多选题Examine the data from the EMP table: EMP_ID DEPT_ID COMMISSION 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 200 7 10 8 20 300 The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? （）ADeleting the records of employees who do not earn commission.BIncreasing the commission of employee 3 by the average commission earned in department 20.CFinding the number of employees who do NOT earn commission and are working for department 20.DInserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.ECreating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.FDecreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
单选题Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_ NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?（）ASELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000;BSELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000 GROUP BY dept_id;CSELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) 5000 AND MAX(salary) 15000;DSELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) 5000 AND MAX(salary) 15000;ESELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) 5000 AND MAX(salary) 15000;
单选题In the past, professors _____.Acould earn as much as doctorsBwere able to earn more than engineersCwere not good at earning moneyDdid not intend to earn money easily
单选题你是公司会计数据库的开发者。数据库包含一个名叫Employees的表。Tom是会计部门的一个成员。Tom的数据库用户帐户对表Employees里的列Salary和Bonus Percentage的SELECT权限被拒绝，被授予对其他列的SELECT权限。Tom现在要求访问Employees表里的所有数据。你该怎么做？（）A废除Tom数据库用户帐户对表Employees里的列Salary和Bonus Percentage的SELECT权限B添加Tom到db_datareader角色C添加Tom到db_accessadmin角色D授予Tom数据库用户帐户对表Employees里的列Salary和Bonus Percentage的SELECT权限。
单选题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?（）ASELECT employee_id Emp_id, emp_name Employee, salary, employee_id Mgr_id, emp_name Manager FROM employees WHERE salary 4000;BSELECT e.employee_id Emp_id, e.emp_name Employee,Csalary,Demployee_id Mgr_id, m.emp_name Manager FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary 4000;
单选题Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）ATo find the tax percentage for each of the employees.BTo list the name, job id, and manager name for all the employees.CTo find the name, salary, and department name of employees who are not working with Smith.DTo find the number of employees working for the Administrative department and earning less then 4000.ETo display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
单选题Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）ATo find the tax percentage for each of the employees.BTo list the name, job id, and manager name for all the employees.CTo find the name, salary, and department name of employees who are not working with Smith.DTo find the number of employees working for the Administrative department and earning less then 4000.ETo display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
单选题Which of the following will those worrying about the trend support?AProfessors working in profitable fields are less reliable.BMore support should be given to musty areas other than profit-generating ones.CProfessors in technology-related fields should earn more than their counterparts do in industry.DPeople working in pharmaceutical and high-tech companies should earn the biggest money.