SQL Server interview questions part 17
SQL Server interview questions part 17
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which panel presents a list of objects under the selected node ?
Correct Answer is : Object Explorer
2. Template Explorer is used to manage ____________
Correct Answer is : T-SQL scripts
3. Which of the following shortcut is used for displaying error list ?
Correct Answer is : Ctrl + \
4. _____________ is not available on standard toolbar.
Correct Answer is : Error List
5. Which command is used to reset default configuration in SSMS ?
Correct Answer is : Reset
6. _________ is tool in SSMS used to manage multiple servers.
Correct Answer is : Registered Servers
7. Which of following is database object?
Correct Answer is : All of the mentioned
8. Which of the following tool is used for designing schema of the database in SSMS ?
Correct Answer is : Table designer
9. Which of the following pane option is not provided by Query Designer ?
Correct Answer is : Query pane
10. SMO in SQL Server stands for ___________
Correct Answer is : SQL Server Management Object
11. Which of the following feature is not provided by SSS 2008 ?
Correct Answer is : Automatic formatting
12. Ctrl+K+K shortcut refers to ___________
Correct Answer is : Add or remove a bookmark
13. Which of the following shortcut is used to clear all bookmarks ?
Correct Answer is : Ctrl+K+L
14. __________menu allows user to set up some keyboard shortcuts.
Correct Answer is : Tools
15. Which menu is used to restore windows to their original locations ?
Correct Answer is : Windows
16. Which of the following is used to build sql statements without writing code ?
Correct Answer is : Query Designer
17. Which of the following is not database object ?
Correct Answer is : PowerShell
18. ______________ is schematic drawing used for representing relationships in database.
Correct Answer is : Database Diagrams
19. The _________ database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.
Correct Answer is : msdb
20. The query given below will give an error. Which one of the following has to be replaced to get the desired output? SELECT ID, name FROM 1_Order WHERE instructor=1;
Correct Answer is : _Order
