Database Interview Questions - Tech Mahindra

1. What is synonym?
2. Write a query to create a view in database?
3. Write a query to create a record?
4. What is the purpose of creating a synonym?
5. What does UPDATE command do?
6. What is the use of COMMIT command?
7. How to change the data type of a column in a table after the table has been created?
8. What is the integer data type available in SQL server?