Consider a relation student has Student_id, Student_name, Student_age, Student_Income, Student_address.
| Student | ||||
| Student_id | Student_name | Student_age | Student_Income | Student_address |
| 11 | Sam | 23 | 80k | ABC, Hyderabad, India |
| 12 | Ram | 25 | 50k | DBC, Mumbai, India |
| 13 | Balaji | 25 | 100k | ABC, Warangal, India |
| 14 | Jan | 24 | 60k | ABC, London, England |
| 15 | Anne | 18 | 50k | DBC, Mumbai, India |
| 16 | Don | 19 | 90k | ABC, Hyderabad, India |
Query:
SELECT Student_name AS Name FROM student;
Which of the following option true for a given SQL query?
1
Retrieve selected columns
2
Renaming of columns
3
Remove primary key from the table
4
Remove an attribute