SQL Server Management Studio Interview Questions & Answers

SQL Server Management Studio Interview Questions

SQL Server Management Studio is designed to monitor and perform various operations/functions on the SQL Server Database. Many organizations are using it for data processing and analysis. Do search in wisdom jobs for SQL Server Management Studio job listings for full time and part time positions updated today. If you are looking for job then go check out interview questions page to get more information on the kind and level of questions you will come across during the interview. Various jobs were present in all over India for this technology which is in high demand. Wisdomjobs interview questions and answers provides you with complete guide on the SQL Server Management Studio questions and answers and makes you prepared for winning job interview.

SQL Server Management Studio Interview Questions And Answers

SQL Server Management Studio Interview Questions
    1. Question 1. What Is Sql Server Management Studio?

      Answer :

      SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server and Azure SQL Database.

    2. Question 2. What Are The General Features Of Sql Server Management Studio?

      Answer :

      SQL Server Management Studio includes the following general features:

      • Supports most administrative tasks for SQL Server.
      • A single, integrated environment for SQL Server Database Engine management and authoring.
      • Dialogs for managing objects in the SQL Server Database Engine, Analysis Services, and Reporting Services, that allows you to execute your actions immediately, send them to a Code Editor, or script them for later execution.
      • Non-modal and resizable dialogs allow access to multiple tools while a dialog is open.
      • A common scheduling dialog that allows you to perform action of the management dialogs at a later time.
      • Exporting and importing SQL Server Management Studio server registration from one Management Studio environment to another.
      • Save or print XML Showplan or Deadlock files generated by SQL Server Profiler, review them later, or send them to administrators for analysis.
      • A new error and informational message box that presents much more information, allows you to send Microsoft a comment about the messages, allows you to copy messages to the clipboard, and allows you to easily e-mail the messages to your support team.
      • An integrated Web browser for quick browsing of MSDN or online help.
      • Integration of Help from online communities.
      • A tutorial on SQL Server Management Studio to help you take advantage of the many new features and become more productive right away.
      • A new activity monitor with filtering and automatic refresh.
      • Integrated Database Mail interfaces.

    3. Question 3. What Are The New Scripting Capabilities Of Ssms?

      Answer :

      New Scripting Capabilities :  The Code Editor component of SQL Server Management Studio contains integrated script editors for authoring Transact-SQL, MDX, DMX, and XML/A. It features:

      • Dynamic Help for immediate access to relevant information while you work.
      • A rich set of templates with the ability to create custom templates.
      • Support for writing and editing queries or scripts without requiring a connection to a server.
      • Scripting support for SQLCMD queries and scripts.
      • A new interface for viewing XML results.
      • Integrated source control for solution and script projects, supporting storing and maintaining copies of scripts as they evolve over time.
      • Microsoft IntelliSense support for MDX statements.

    4. Question 4. What Are The Tool Windows In Sql Server Management Studio?

      Answer :

      Tool Windows in SQL Server Management Studio : SQL Server Management Studio provides many powerful tool windows for all phases of development and administration. Some tools can be used on any SQL Server component, and others are for certain components only.The following  tools that can be used for all components of SQL Server.

      • Object Explorer
      • Solution Explorer
      • Template Explorer
      • Dynamic Help


    5. Question 5. What Is The Purpose Of Object Explorer And Its Features?

      Answer :

      Purpose of Object Explorer : Browse servers, create and locate objects, manage data sources, and view logs. This tool is accessed from the View menu.

      Object Explorer Features : The Object Explorer component of SQL Server Management Studio is an integrated tool for viewing and managing objects in all server types. It features:

      • Filtering by all or part of a name, schema, or date.
      • The asynchronous population of objects, with the ability to filter objects based on their metadata.
      • Access to SQL Server Agent on replication servers for administration.


    6. Question 6. What Is The Difference Between The Export /import Functions In Sql Studio And Standalone Sql Manager?

      Answer :

      The Data Export/Import tools of SQL Studio include some additional features which are not available in SQL Manager for SQL Server, such as:

      • export/import data from/to several tables simultaneously;
      • export/import data from/to tables selected from different databases on one host;
      • a command-line utility to export/import data using the configuration file with all the export/import options;
      • a single registered database repository.

    7. Question 7. What Are The Benefits And Tasks Of Object Explorer?

      Answer :

      Object Explorer : SQL Server Management Studio provides features for managing objects in instances of the Database Engine, Analysis Services, Integration Services, and Reporting Services.

      Benefits of Object Explorer : Object Explorer provides a hierarchical user interface to view and manage the objects in each instance of SQL Server. The Object Explorer Details pane presents a tabular view of instance objects, and the capability to search for specific objects. The capabilities of Object Explorer vary slightly depending on the type of server, but generally include the development features for databases, and management features for all server types.

      Object Explorer Tasks : 

      Open and Configure Object Explorer : Describes how to open the Object Explorer and configure the options that define the behavior of the explorer.
      Connect to an Instance From Object Explorer : Describes how to connect Object Explorer to an instance of the Database Engine, Analysis Services, Reporting Services, and Integration Services.
      Manage Objects by Using Object Explorer : Describes how to manage objects represented as nodes in the Object Explorer hierarchy.
      Object Explorer Details Pane : Describes the Object Explorer Details Pane, a tabular view of all of the objects in the server with a user interface to manage them.
      Custom Reports in Management Studio : Describes ways to run custom reports in SQL Server Management Studio.

    8. Question 8. Can I Save My Report As Html, Excel Or Word?

      Answer :

      Yes, open the report by double-clicking on it in the DB Explorer of SQL Manager and select the 'Save report as' item in the Navigation bar or toolbar, and specify the format you want to save to in the "Save as type" field

    9. Question 9. What Is Ems Sql Management Studio?

      Answer :

      EMS SQL Management Studio is a complete solution for database administration and development. SQL Studio is an integrated suite of powerful database management tools united in one easy-to-use work environment. Developers will appreciate its ability to create/edit/drop any database objects and will find metadata and data comparison, data export/import and test data generation tools extremely helpful. Database migration, backup and restore tools will be of great help to DBAs. The Scheduler will automate a sizeable part of DBA's work.

    10. Question 10. Sql Studio Em Braces A Variety Of Capabilities, But Will I Need Them All? Is There A Simpler Product ?

      Answer :

       It might not be immediately obvious why you would need so many different tools. We would like to point out that your experience will build up day in and day out, you will face new, more complicated tasks and you will need more tools to solve them. SQL Studio embraces ALL must-have tools for DBAs and developers. And it will be in line with your growing expertise! Besides, once you familiarize yourself with SQL Studio tools, you will be able to find the simplest, most suitable and reliable solutions to your tasks! We do realize that our product is used not only by experts, that is why we included plenty of Wizards that will make the job easy and enjoyable even for a newbie. The Studio interface is designed so that the component tools are called only when needed, not to hinder your work. Our experience shows that the majority of our customers get used to our products really fast, and we have never received any downgrade requests.

    11. Question 11. What Do I Need To Start Working With Sql Studio?

      Answer :

      In order to start working with SQL Studio, you need to download the installation package from the download page available at our site. Then run the installation file on a MS Windows workstation (see System requirements for details). When the installation is finished, the program is ready to be used in the trial mode. You can evaluate the trial version for 30 days. This is the time for you to make a purchasing decision.

    12. Question 12. Can I Work With Several Databases Simultaneously?

      Answer :

      Yes, SQL Studio allows you to work with an unlimited number of databases at the same time. Once the database is registered at the database source repository correctly, you are ready to use it.

    13. Question 13. Why Does Sql Studio Use A Single Registered Database Repository?

      Answer :

      The single registered database repository allows one database to be accessed with all SQL Studio tools. If you purchased our product suites (bundles) previously, you had to enter the database information in each tool you used. That eventually led to massive time wasting and typing errors. Now the problem is solved in the Studio with the help of the single registered database repository.

    14. Question 14. What's New In Sql Management Studio For Sql Server?

      Answer :

      Added new services in SQL Management Studio for SQL Server: Check Database, Indices Management, Shrink Database and Update Statistics.There was an issue concerning installation on disks having more than 2Tb of free space.  The default folder for logs now points to the user's profile.  The network notifications (NetSend) did not work on Windows Vista and newer.SQL Studio Agent utilized 100% of CPU when the task generated a large log. Fixed now. The running processes are now stopped correctly when updating. Wrong encoding of logs with enabled localization has been fixed. Lots of other improvements and bug-fixes.

    15. Question 15. How Can I Create A Report Based On A Query?

      Answer :

      To create a report based on a query, you can use the Create Report Wizard in SQL Manager for SQL Server. You need to choose Master Data band on the second step of the wizard, double-click on it or click the Edit button and specify the query for your report. After that you need to set options in other steps of the wizard and press Finish.

    16. Question 16. To Which Devices Can A Backup Be Created And Where Should These Devices Be Located?

      Answer :

      A backup copy can be created in a logical backup device, a file, on the tape or in the named pipe. In all the cases the device should be placed on the server or in the local network where the server is installed. The path to the device is defined from the server side. To use the network devices, SQL Server Service should be launched from the user name that has access to the device.

    17. Question 17. The External Application That Is Executed In One Of The Tasks Does Not Have A Log File, But Only A Screen Log. How Can I Save The Data From The Screen?

      Answer :

      If a utility does not have a log file, and the log information is only displayed on the screen (in text mode), then SQL Studio can save these data as a log. To do so, please check the "Save screen to log" box when creating a task.

    18. Question 18. It Is Important Form E To Get The Information From Log Files Of Applications Executed By The Task Scheduler? Does Sql Studio Save These Log Files?

      Answer :

      Yes, SQL Studio has a convenient tool to work with log files. While creating a Step in the Task, you can specify the location of the log file of the application to be executed. When choosing the tools from SQL Studio, the location of the log file is filled automatically. Log files of the performed steps are saved in the internal SQL Studio database and are available within the Tasks | Logs menu.

    19. Question 19. If I Delete A Template From The List In Sql Studio, Will It Be Deleted From The Hard Disk?

      Answer :

      Template Manager allows you to perform both operations: you can either delete a template from the registered template list only, or delete it also from the hard disk.

    20. Question 20. How Can I Create A New Template For Import ?

      Answer :

      To create a template for the Import tool, you should run the Import tool (Run | Data Import for SQL Server). Then you will need to fill in all the necessary import parameters using the Next button. At the last wizard step you should define the name and location of the newly created template using the Tools | Save Template menu item.

Popular Interview Questions

All Interview Questions

Sql Server Management Studio Practice Test

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status