This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Management Studio – 1”.
1. Management Studio is ________ used for development of SQL Server database.
a) Front end tool
b) Back end tool
c) Database engine
d) SQL Server
View Answer
Explanation: Management Studio is a front-end client tool used to manage SQL Server and develop databases.
2. Which panel presents a list of objects under the selected node?
a) Template Explorer
b) Object Explorer
c) Properties window
d) Query Editor
View Answer
Explanation: Object Explorer is used for administering and developing SQL Server database objects.
3. Template Explorer is used to manage ____________
a) T-SQL scripts
b) Registered Servers
c) Properties
d) Query design
View Answer
Explanation: Template Explorer is used to create and manage T-SQL code templates.
4. Which of the following shortcut is used for displaying error list?
a) Ctrl + /
b) Ctrl + |
c) Ctrl + \
d) Ctrl + !
View Answer
Explanation: Error List (Ctrl+\, Ctrl+E) lists multiple errors.
5. _____________ is not available on standard toolbar.
a) Error List
b) Object Explorer
c) Query Editor
d) Properties windows
View Answer
Explanation: The most commonly used tools — Query Editor, Object Explorer, Template Explorer, and Properties windows are available on the standard toolbar.
6. Which command is used to reset default configuration in SSMS?
a) Clear
b) Hide
c) Reset all
d) Reset
View Answer
Explanation: To reset Management Studio to its default configuration (Object Explorer ➪ Tabbed Documents ➪Property Window) use the Window ➪ Reset Window Layout menu command.
7._________ is tool in SSMS used to manage multiple servers.
a) Registered Servers
b) Query Editor
c) Template Explorer
d) Context Explorer
View Answer
Explanation: Using Registered Servers, connection information can be maintained for connections to the Database Engine, Analysis Services, Reporting Services, SQL Server Mobile Edition Databases, and Integration Services.
8. Which of the following is a database object?
a) Tables
b) Triggers
c) Functions
d) All of the mentioned
View Answer
Explanation: SQL Server has many database objects such as service broker, views, tables and many more.
9. Which of the following tool is used for designing schema of the database in SSMS?
a) Query Designer
b) Database Diagrams
c) Table designer
d) Query Editor
View Answer
Explanation: Table Designer is used to create and modify tables (rows and columns).
10. Which of the following pane option is not provided by Query Designer?
a) Diagram pane
b) Grid pane
c) Results pane
d) Query pane
View Answer
Explanation: Query Designer does not provide Query pane for querying database schema.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
- Check SQL Server Books
- Check Information Technology Books
- Practice Programming MCQs
- Apply for Programming Internship