MSSQL DATABASE INTERVIEW QUESTIONS

What are rows and columns in an MSSQL database table?

How do you insert a new row into an MSSQL table?

How do you select specific columns from a table in MSSQL?

How do you update a specific column value for a row in MSSQL?

How do you delete a row from an MSSQL table?

How do you add a new column to an existing MSSQL table?

How do you retrieve the number of rows in an MSSQL table?

. How do you pivot rows into columns in MSSQL?

How do you create a computed column in an MSSQL table?

Explain a scenario where managing rows and columns efficiently is crucial for a business application in MSSQL and describe how you would implement it.