單項選擇題

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 clause should you use to exclude group results?（）

A.WHERE
B.HAVING
C.RESTRICT
D.GROUP BY
E.ORDER BY

多項選擇題

Which two statements are true about constraints? （）

A.The UNIQUE constraint does not permit a null value for the column.
B.A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
C.The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
D.The NOT NULL constraint ensures that null values are not permitted for the column.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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

你可能感興趣的試題

Which clause should you use to exclude group results?（）

Which two statements are true about constraints? （）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久