网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.A
Argonauts, with an annual salary of $550,000 and was theB
Argonauts, earning $550,000 per year and it was theC
Argonauts for a yearly wage of $550,000, being theD
Argonauts, with annual pay of $550,000 per year, which was theE
Argonauts 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"?（）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 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.
考题
单选题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
考题
单选题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.
考题
单选题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.
考题
单选题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 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.
热门标签
最新试卷