is paid weekly
is adjusted every quarter
is re-examined from year to year
is fixed for the whole contract period
授予用户U1,U2和U3在关系employee的salary属性上的UPDATE权限的语句是A.GRANT ON employee TOU1,U2,U3B.GRANT UPDATE ON employee TO U1,U2,U3C.GRANT UPDATE(salary) ON employeeD.GRANT UPDATE(salary)ON employee TO U1,U2,U3
点击查看答案
回收用户U1,U2和U3在关系employee的salary属性上的UPDATE限的语句是A.REVOKE UPDATE(salary) ON employee(U1,U2,U3)B.REVOKE UPDATE(salary)ON employee FROM U1,U2,U3C.REVOKE UPDATE ON employee FROM U1,U2,U3D.REVOKE UPDATE(salary) FROM U1,U2,U3
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.AB.BC.CD.DE.E
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;
在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
() is the operation to check the quantity, quality and package of the goods according to the contract and the specific standardA、Inspection B、Examination C、Control D、Test
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.