单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）ASELECT ename, salary*12 ‘Annual Salary’ FROM employees;BSELECT ename, salary*12 “Annual Salary” FROM employees;CSELECT ename, salary*12 AS Annual Salary FROM employees;DSELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees
单选题
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
参考解析
解析：
暂无解析
相关考题：
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.
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.
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;
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
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.
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.
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.
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 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.
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
单选题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.AArgonauts, with an annual salary of $550,000 and was theBArgonauts, earning $550,000 per year and it was theCArgonauts for a yearly wage of $550,000, being theDArgonauts, with annual pay of $550,000 per year, which was theEArgonauts for an annual salary of $550,000, the
单选题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"?（）ANo change is required to achieve the desired results.BSELECT ename, sal, 12* (sal+100) FROM emp;CSELECT ename, sal, (12* sal)+100 FROM emp;DSELECT ename, sal +100,*12 FROM emp;
单选题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?（）AThe two statements produce identical results.BThe second statement returns a syntax error.CThere is no need to specify DESC because the results are sorted in descending order by default.DThe two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
单选题Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）AORDER BY SALARY 5000BGROUP BY SALARY 5000CHAVING SALARY 5000DWHERE SALARY 5000
单选题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?（）AThe tuned plan is not added to the SQL plan baseline.BThe tuned plan is added to the fixed SQL plan baseline as a fixed plan.CThe tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.DThe tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
单选题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?（）AThe two statements produce identical results.BThe second statement returns a syntax error.CThere is no need to specify DESC because the results are sorted in descending order by default.DThe two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
单选题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?（）ASELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;BSELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;CSELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;DSELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
单选题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.