单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）A SELECT ename, salary*12 ‘Annual Salary’ FROM employees;B SELECT ename, salary*12 “Annual Salary” FROM employees;C SELECT ename, salary*12 AS Annual Salary

题目
单选题
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
A

SELECT ename, salary*12 ‘Annual Salary’   FROM employees;

B

SELECT ename, salary*12 “Annual Salary”   FROM employees;

C

SELECT ename, salary*12 AS Annual Salary   FROM employees;

D

SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”)   FROM employees

相似考题

1.You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）A. The tuned plan is not added to the SQL plan baseline.B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

2.The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.Which SQL statement displays the desired results? （）A. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;B. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;C. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;D. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;

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

4.The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario?（）A. The optimizer adds the new plan to the plan history.B. The optimizer selects the new plan for the execution of the SQL statement.C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

更多“Which SQL statement generates the alias Annual Salary for th”相关问题

  • 第1题：

    Evaluate these two SQL statements:What is true about them?()

    A. The two statements produce identical results.

    B. The second statement returns a syntax error.

    C. There is no need to specify DESC because the results are sorted in descending order by default.

    D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


    参考答案：A

  • 第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题：

    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）

    • A、The two statements produce identical results.
    • B、The second statement returns a syntax error.
    • C、There is no need to specify DESC because the results are sorted in descending order by default.
    • D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

    正确答案:A

  • 第4题：

    单选题
    After his 1962 season, in which he set a record for on-base percentage, Mitch McAlister left his old team and signed with the Springfield Argonauts, with an annual salary, of $550,000 and was the highest salary in professional baseball at that time.
    A

    Argonauts, with an annual salary of $550,000 and was the

    B

    Argonauts, earning $550,000 per year and it was the

    C

    Argonauts for a yearly wage of $550,000, being the

    D

    Argonauts, with annual pay of $550,000 per year, which was the

    E

    Argonauts for an annual salary of $550,000, the


    正确答案： E
    解析：
    Ａ项逻辑错误；Ｂ项“it”指代不明；C项不符合逻辑表达；D项“annual pay…per year”的表达是重复的，故本题选Ｅ项。

  • 第5题：

    单选题
    Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
    A

    SELECT ename, salary*12 ‘Annual Salary’   FROM employees;

    B

    SELECT ename, salary*12 “Annual Salary”   FROM employees;

    C

    SELECT ename, salary*12 AS Annual Salary   FROM employees;

    D

    SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”)   FROM employees


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

  • 第6题：

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

    B

    GROUP BY SALARY > 5000

    C

    HAVING SALARY > 5000

    D

    WHERE SALARY > 5000


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

  • 第7题：

    单选题
    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）
    A

    The two statements produce identical results.

    B

    The second statement returns a syntax error.

    C

    There is no need to specify DESC because the results are sorted in descending order by default.

    D

    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


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

  • 第8题：

    单选题
    Evaluate these two SQL statements: What is true about them?（）
    A

    The two statements produce identical results.

    B

    The second statement returns a syntax error.

    C

    There is no need to specify DESC because the results are sorted in descending order by default.

    D

    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


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

  • 第9题：

    Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

    A.

    B.

    C.

    D.


    参考答案：C

  • 第10题：

    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

  • 第11题：

    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

  • 第12题：

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


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

  • 第13题：

    单选题
    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEESORDER BY 2 DESC; What is true about them?（）
    A

    The two statements produce identical results.

    B

    The second statement returns a syntax error.

    C

    There is no need to specify DESC because the results are sorted in descending order by default.

    D

    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


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

  • 第14题：

    单选题
    You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）
    A

    The tuned plan is not added to the SQL plan baseline.

    B

    The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

    C

    The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

    D

    The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.


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

  • 第15题：

    单选题
    The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）
    A

    SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;

    B

    SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;

    C

    SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;

    D

    SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;


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

相关内容