Loading...

SQL Server

Management Studio is ________ used for development of SQL Server database.
  1. Front end tool
  2. Back end tool
  3. Database engine
  4. SQL Server
Which panel presents a list of objects under the selected node ?
  1. Template Explorer
  2. Object Explorer
  3. Properties window
  4. Query Editor
Template Explorer is used to manage ____________
  1. T-SQL scripts
  2. Registered Servers
  3. Properties
  4. Query design
Which of the following shortcut is used for displaying error list ?
  1. Ctrl + /
  2. Ctrl + |
  3. Ctrl + \
  4. Ctrl + !
_____________ is not available on standard toolbar.
  1. Error List
  2. Object Explorer
  3. Query Editor
  4. Properties windows
Which command is used to reset default configuration in SSMS ?
  1. Clear
  2. Hide
  3. Reset all
  4. Reset
_________ is tool in SSMS used to manage multiple servers.
  1. Registered Servers
  2. Query Editor
  3. Template Explorer
  4. Context Explorer
Which of following is database object?
  1. Tables
  2. Triggers
  3. Functions
  4. All of the mentioned
Which of the following tool is used for designing schema of the database in SSMS ?
  1. Query Designer
  2. Database Diagrams
  3. Table designer
  4. Query Editor
Which of the following pane option is not provided by Query Designer ?
  1. Diagram pane
  2. Grid pane
  3. Results pane
  4. Query pane