Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 48 of 103

Review of Database Concepts & SQL — Question 18

Back to all questions
18
Question

Question 18

Rajveer wants to rename column in display result for his query. Select the appropriate query for the same:

  1. Select Ename, Salary*12 Annual Salary From Emp;
  2. Select Ename, Salary*12 Rename "Annual Salary" From Emp;
  3. Select Ename, Salary*12 Change "Annual Salary" From Emp;
  4. Select Ename, Salary*12 as "Annual Salary" From Emp;
Answer

Select Ename, Salary*12 as "Annual Salary" From Emp;

Reason — The AS keyword is used to give an alias to a column or expression in the SELECT statement. In this case, AS "Annual Salary" is used to rename the column Salary*12 to "Annual Salary" in the display result.