单项选择题

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

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

What is true about sequences?（）

A. Once created, a sequence belongs to a specific schema.
B. Once created, a sequence is linked to a specific table.
C. Once created, a sequence is automatically available to all users.
D. Only the DBA can control which sequence is used by a certain table.
E. Once created, a sequence is automatically used in all INSERT and UPDATE statements.

单项选择题

In which scenario would index be most useful?（）

A. The indexed column is declared as NOT NULL.
B. The indexed columns are used in the FROM clause.
C. The indexed columns are part of an expression.
D. The indexed column contains a wide range of values.

单项选择题

The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）

A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%'ESCAPE'\';
B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_'ESCAPE'\';
D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id '%SA_';