Q. Which command is used to reset default configuration in SSMS?

View solution

Q. ________ is tool in SSMS used to manage multiple servers.

View solution

Q. Which of the following is a database object?

View solution

Q. Which of the following tool is used for designing schema of the database in SSMS?

View solution

Q. Which of the following pane option is not provided by Query Designer?

View solution

Q. SMO in SQL Server stands for ___________

View solution

Q. Which of the following feature is not provided by SSS 2008?

View solution

Q. Ctrl+K+K shortcut refers to ___________

View solution

Q. Which of the following shortcut is used to clear all bookmarks?

View solution

Q. __________menu allows user to set up some keyboard shortcuts.

View solution

Q. Which menu is used to restore windows to their original locations?

View solution

Q. Which of the following is used to build sql statements without writing code?

View solution

Q. ______________ is schematic drawing used for representing relationships in database.

View solution

Q. The _________ database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

View solution

Q. Which of the following is a large object data type?

View solution

Q. Data types in SQL Server are organized into how many categories?

View solution

Q. Exact Numeric data type is ___________

View solution

Q. ntext data type falls under which category?

View solution

Q. A column of type __________ may contain rows of different data types.

View solution

Q. You want to track date and time of the last write access per row. Select the suitable option among the below.

View solution