Exams Attended

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

MSSQL Interview Questions and Answers

  Difficulty Level: AllBeginnerIntermediateExperienced/Expert

Ques 1. What is Microsoft SQL Server?

Ques 2. How to download Microsoft SQL Server 2005 Express Edition?

Ques 3. System Requirements for SQL Server 2005 Express Edition?

Ques 4. Why I am getting "The Microsoft .Net Framework 2.0 in not installed" message?

Ques 5. How to download and install Microsoft .NET Framework Version 2.0?

Ques 6. What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN?

Ques 7. How to install SQL Server 2005 Express Edition?

Ques 8. What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS)?

Ques 9. How do you know if SQL Server is running on your local system?

Ques 10. How to connect SQL Server Management Studio Express to SQL Server 2005 Express?

Ques 11. How to download and install Microsoft SQL Server Management Studio Express?

Ques 12. How to download and install SQL Server 2005 Books Online?

Ques 13. How to run Queries with SQL Server Management Studio Express?

Ques 14. How to run SQL Server 2005 Books Online on your local system?

Ques 15. How to use Transact-SQL statements to access the database engine?

Ques 16. How to create new databases with "CREATE DATABASE" statements?

Ques 17. How to create new table with "CREATE TABLE" statements?

Ques 18. How to insert and update data into a table with "INSERT" and "UPDATE" statements?

Ques 19. How to read data in a table with "SELECT" statements?

Ques 20. How to create a login account in MS SQL Server to access the database engine using "CREATE LOGIN" statements?

Ques 21. How to create a user to access a database in MS SQL Server using "CREATE USER" statements?

Ques 22. How to create a view and a stored procedure in MS SQL Server using "CREATE VIEW/PROCEDURE" statements?

Ques 23. How to grant a permission in MS SQL Server using "GRANT EXECUTE" statements?

Ques 24. How to delete database objects with "DROP" statements in MS SQL Server?

Ques 25. What is a database in MS SQL Server?

Ques 26. What is the simplest way to create a new database in MS SQL Server?

Ques 27. How to set the current database in MS SQL Server?

Ques 28. How to delete a database in MS SQL Server?

Ques 29. Why I am getting this error when dropping a database in MS SQL Server?

Ques 30. How to get a list all databases on the SQL server?

Ques 31. Where is my database stored on the hard disk in MS SQL Server?

Ques 32. How to create database with physical files specified in MS SQL Server?

Ques 33. How to rename databases in MS SQL Server?

Ques 34. Why I am getting this error when renaming a database in MS SQL Server?

Ques 35. What are database states in MS SQL Server?

Ques 36. How to set a database state to OFFLINE in MS SQL Server?

Ques 37. How to move database physical files in MS SQL Server?

Ques 38. How to set database to be READ_ONLY in MS SQL Server?

Ques 39. How to set database to be SINGLE_USER in MS SQL Server?

Ques 40. What are system databases in MS SQL Server?

Ques 41. What is a database table?

Ques 42. What are DDL (Data Definition Language) statements for tables in MS SQL Server?

Ques 43. How to create new tables with "CREATE TABLE" statements in MS SQL Server?

Ques 44. How To Get a List of All Tables with "sys.tables" View in MS SQL Server?

Ques 45. How To Get a List of Columns using the "sys.columns" View in MS SQL Server?

Ques 46. How To Get a List of Table Columns using the "sp_columns" Stored Procedure in MS SQL Server?

Ques 47. How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?

Ques 48. How To Generate CREATE TABLE Script on an Existing Table in MS SQL Server?

Ques 49. How to create new tables with "SELECT ... INTO" statements in MS SQL Server?

Ques 50. How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD" in MS SQL Server?

©2022 WithoutBook