Q.1
SMO in SQL Server stands for ___________
  • a) Server Management Object
  • b) Service Management Object
  • c) SQL Management Object
  • d) SQL Server Management Object
Q.2
Which of the following feature is not provided by SSS 2008?
  • a) Automatic formatting
  • b) IntelliSense
  • c) Code Outlining
  • d) SQLCMD
Q.3
Ctrl+K+K shortcut refers to ___________
  • a) Refresh IntelliSense
  • b) Add or remove a bookmark
  • c) Enable all bookmarks
  • d) Move to the next bookmark
Q.4
Which of the following shortcut is used to clear all bookmarks?
  • a) Ctrl+K+L
  • b) Ctrl+K+O
  • c) Ctrl+K+B
  • d) Ctrl+K+P
Q.5
__________menu allows user to set up some keyboard shortcuts.
  • a) Edit
  • b) File
  • c) Tools
  • d) None of the Mentioned
Q.6
Which menu is used to restore windows to their original locations?
  • a) Edit
  • b) File
  • c) Tools
  • d) Windows
Q.7
Which of the following is used to build sql statements without writing code?
  • a) Registered Servers
  • b) Query Designer
  • c) Template Explorer
  • d) Context Explorer
Q.8
Which of the following is not a database object?
  • a) Database Diagrams
  • b) Stored Procedures
  • c) PowerShell
  • d) Index
Q.9
______________ is schematic drawing used for representing relationships in database.
  • a) Trigger
  • b) Database Diagrams
  • c) Table designer
  • d) Query Editor
Q.10
The _________ database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.
  • a) model
  • b) msdb
  • c) master
  • d) temp
0 h : 0 m : 1 s