Loading...

SQL Server

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