网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

客户需要计算EMP表中所有职工12*salary* commission_pct的值.EMP表结构如下:LAST NAME VARCNAR2(35)NOT NULL SALARY NUMBER(9,2)NOT NULL COMMISION_PCTNUMBER(4,2)哪个语句可以查询计算EMP表中所有职工行?()

  • A、SELECT last_name,12*salary* commission_pct FROM emp
  • B、SELECT last_name,12*salary*(commission_pct,0)FROM emp
  • C、SELECT last_name,12*salary*(nvl(commission_pct,0))FROM emp如果oracle第一个参数为空那么显示第二个参数的值,如果第一个参数的值不为空,则显示第一个参数本来的值
  • D、SELECT last_name,12*salary*(decode(commission_pct,0))FROM emp

参考答案

更多 “客户需要计算EMP表中所有职工12*salary* commission_pct的值.EMP表结构如下:LAST NAME VARCNAR2(35)NOT NULL SALARY NUMBER(9,2)NOT NULL COMMISION_PCTNUMBER(4,2)哪个语句可以查询计算EMP表中所有职工行?()A、SELECT last_name,12*salary* commission_pct FROM empB、SELECT last_name,12*salary*(commission_pct,0)FROM empC、SELECT last_name,12*salary*(nvl(commission_pct,0))FROM emp如果oracle第一个参数为空那么显示第二个参数的值,如果第一个参数的值不为空,则显示第一个参数本来的值D、SELECT last_name,12*salary*(decode(commission_pct,0))FROM emp” 相关考题
考题 客户需要计算EMP表中所有职工12*salary* commission_pct的值.EMP表结构如下:LAST NAME VARCNAR2(35)NOT NULL SALARY NUMBER(9,2)NOT NULL COMMISION_PCTNUMBER(4,2)哪个语句可以查询计算EMP表中所有职工行?() A.SELECT last_name,12*salary* commission_pct FROM empB.SELECT last_name,12*salary*(commission_pct,0)FROM empC.SELECT last_name,12*salary*(nvl(commission_pct,0))FROM emp如果oracle第一个参数为空那么显示第二个参数的值,如果第一个参数的值不为空,则显示第一个参数本来的值D.SELECT last_name,12*salary*(decode(commission_pct,0))FROM emp

考题 如果对关系emp(eno,ename,salary)成功执行下面的SQL语句: CREATE CLUSTER INDEX name_index ON emp(salary) 对此结果的正确描述是A.在emp表上按salary升序创建了一个聚簇索引B.在emp表上按salary降序创建了一个聚簇索引C.在emp表上按salary升序创建了一个唯一索引D.在emp表上按salary降序创建了一个唯一索引

考题 ( 30 )如果对关系 emp ( eno , ename , salray )成功执行下面的 SQL 语句:CREATE CLUSTER INDEX name_index ON emp ( salary )对此结果的正确描述是A) 在 emp 表上按 salary 升序创建了一个唯一索引B) 在 emp 表上按 salary 降序创建了一个唯一索引C) 在 emp 表上按 salary 升序创建了一个聚簇索引D) 在 emp 表上按 salary 降序创建了一个聚簇索引

考题 设某工厂数据库中有两个基本表:车间基本表:DEPT(DNO,DNAME,MGR-NO),其属性分别表示车间编号、车间名和车间主任的职工号.职工基本表:EMP(ENO,ENAME,SEX,SALARY,DNO),其属性分别表示职工号、姓名、性别、工资和所在车间的编号.试用SQL语句完成下列操作:检索“金工车间”的男职工的职工号和姓名.

考题 如果对关系emp(eno,ename,salary)成功执行下面的SQ[.语句:CREATE CLUSTER INDEX name_index 0N emp(salary)对此结果的正确描述是A.在emp表上按salary升序创建了一个唯一索引B.在emp表上按salary降序创建了一个唯一索引C.在emp表上按salary升序创建了一个聚簇索引D.在emp表上按salary降序创建了一个聚簇索引

考题 Evaluate the SQL statement:SELECT LPAD (salary,10,*)FROM EMPWHERE EMP _ ID = 1001;If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?() A. 17000.00B. 17000*****C. ****170.00D. **17000.00E. an error statement

考题 对于基本表EMP(ENO,ENAME,SALARY,DNO),其属性表示职工的工号、姓名、工资和所在部门的编号。基本表DEPT(DNO,DNAME)其属性表示部门的编号和部门名。有一SQL语句: SELECT COUNT (DI STINCT DNO)FROM EMP;其等价的查询语句是______。A.统计职工的总人数B.统计每一部门的职工人数C.统计职工服务的部门数目D.统计每一职工服务的部门数目

考题 对于第7题的两个基本表,有一个SQL语句: UPDATE EMP SET SALARY=SALARY*1.05 WHERE DNO='D6' AND SALARY<(SELECT AVG(SALARY) FROM EMP);其等价的修改语句为______。A.为工资低于D6部门平均工资的所有职工加薪5%B.为工资低于整个企业平均工资的职工加薪5%C.为在D6部门工作、工资低于整个企业平均工资的职工加薪5%D.为在D6部门工作、工资低于本部门平均工资的职工加薪5%

考题 以下两个关系表:Emp(eid,ename,age,did,salary),其各列含义为:职工号,姓名,年龄,部门号,工资Dept(did,dname,mgr_id),其各列含义为:部门号,部门名称,部门经理职工号写出一条SQL语句,查询工资大于10000,且与他所在部门的经理年龄相同的职工姓名。

考题 ● 设有职工表emp(Eno,Ename,Sex,Age)(Eno为职工号,Ename为职工姓名,Sex为性别,Age为年龄)和salary(Eno,Hour,Month,Wage)(Hour为工作时长为多少小时,Month表示几月份,Wage为薪水),建立一个视图V-Salary(Eno,Ename,Hour,Month,Wage),并按Eno升序排序的SQL语句为:(1)CREATE ( )AS SELECT emp.Eno,emp.Ename ,salary.Hour,salary.Month,salary.WageFROM emp, salaryWHERE emp.Eno=salary.EnoORDER BY ENO在此视图上查均月工资在3000以上的职工工资情况的SQL语句为:SELECT Eno,Ename,AVG(Wage)FROM V-SalaryGROUP BY ( )HAVING AVG(Wage)3000( )A. CREATE TABLE V-Salary(emp.Eno,emp.Ename,salary.Hour,salary.Month,salary.Wage)B. CREATE VIEW V-Salary(Eno,Ename,Hour,Month,Wage)C. CREATE TABLE V-Salary(Eno,Ename,Hour,Month,Wage)D. CREATE INDEX V-Salary(Eno,Ename,Hour,Month,Wage)( )A. Eno B.EnameC.Month D.Wage

考题 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;

考题 设有职工基本表:EMP(ENO,ENAME,AGE,SEX,SALARY),其属性分别表示职工号、姓.名、年龄、性别、工资.为每个工资低于1800元的男职工加薪300元,试写出这个操作的SQL语句.

考题 对于:表EMP(ENO,ENAME,SALARY,DNO),其属性表示职工的工号、姓名、工资和所在部门的编号。表DEPT(DNO,DNAME),其属性表示部门的编号和部门名。有以下SQL语句:SELECT COUNT(DISTINCT DNO)FROM EMP其等价的查询语句是()。A、统计职工的总人数B、统计每一部门的职工人数C、统计职工服务的部门数目D、统计每一职工服务的部门数目

考题 若update emp set salary=1000 中缺少where 条件:()A、更改表中所有记录B、更改第一条记录C、记录未更改。D、提示错误:缺少where字句

考题 设有关系模式EMP(职工号,姓名,年龄,技能),假设职工号唯一,每个职工有多项技能,则不是EMP表的主键()。A、职工号B、姓名,技能C、技能D、职工号,技能

考题 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.00B、17000*****C、****170.00D、**17000.00E、an error statement

考题 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.00B、17000*****C、****170.00D、**17000.00E、an error statement

考题 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);

考题 单选题Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?()A No change is required to achieve the desired results.B SELECT ename, sal, 12* (sal+100) FROM emp;C SELECT ename, sal, (12* sal)+100 FROM emp;D SELECT ename, sal +100,*12 FROM emp;

考题 单选题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.00B 17000*****C ****170.00D **17000.00E an error statement

考题 单选题客户需要计算EMP表中所有职工12*salary* commission_pct的值.EMP表结构如下:LAST NAME VARCNAR2(35)NOT NULL SALARY NUMBER(9,2)NOT NULL COMMISION_PCTNUMBER(4,2)哪个语句可以查询计算EMP表中所有职工行?()A SELECT last_name,12*salary* commission_pct FROM empB SELECT last_name,12*salary*(commission_pct,0)FROM empC SELECT last_name,12*salary*(nvl(commission_pct,0))FROM emp如果oracle第一个参数为空那么显示第二个参数的值,如果第一个参数的值不为空,则显示第一个参数本来的值D SELECT last_name,12*salary*(decode(commission_pct,0))FROM emp

考题 单选题如果对关系emp(eno,ename,salary)成功执行下面的SQL语句:CREATECLUSTERINDEXname_indexONemp(salary),其结果是()A 在emp表上按salary升序创建了一个聚簇索引B 在emp表上按salary降序创建了一个聚簇索引C 在emp表上按salary升序创建了一个唯一索引D 在emp表上按salary降序创建了一个唯一索引

考题 单选题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.00B 17000*****C ****170.00D **17000.00E an error statement

考题 单选题对于:表EMP(ENO,ENAME,SALARY,DNO),其属性表示职工的工号、姓名、工资和所在部门的编号。表DEPT(DNO,DNAME),其属性表示部门的编号和部门名。有以下SQL语句:SELECT COUNT(DISTINCT DNO)FROM EMP其等价的查询语句是()。A 统计职工的总人数B 统计每一部门的职工人数C 统计职工服务的部门数目D 统计每一职工服务的部门数目

考题 单选题Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?()A SELECT last_name, 12*salary* commission_pct FROM emp;B SELECT last_name, 12*salary* (commission_pct,0) FROM emp;C SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;D SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

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

考题 单选题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.00B 17000*****C ****170.00D **17000.00E an error statement

考题 单选题Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees? ()A SELECT last_name, 12*salary* commission_pct FROM emp;B SELECT last_name, 12*salary* (commission_pct,0) FROM emp;C SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;D SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;