Interview Questions.

Question 1. What Is Sql Server Management Studio?

Answer :

SQL Server Management Studio (SSMS) is an incorporated environment for gaining access to, configuring, dealing with, administering, and developing all additives of SQL Server and Azure SQL Database.

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

Answer :

SQL Server Management Studio consists of the following popular capabilities:

Supports maximum administrative tasks for SQL Server.
A unmarried, integrated environment for SQL Server Database Engine management and authoring.
Dialogs for coping with gadgets in the SQL Server Database Engine, Analysis Services, and Reporting Services, that permits you to execute your movements without delay, ship them to a Code Editor, or script them for later execution.
Non-modal and resizable dialogs permit get right of entry to to multiple equipment whilst a conversation is open.
A common scheduling conversation that lets in you to carry out action of the management dialogs at a later time.
Exporting and uploading SQL Server Management Studio server registration from one Management Studio surroundings to another.
Save or print XML Showplan or Deadlock files generated by SQL Server Profiler, review them later, or ship them to directors for evaluation.
A new error and informational message container that gives lots extra records, allows you to send Microsoft a comment about the messages, lets in you to replicate messages to the clipboard, and allows you to without problems e mail the messages for your help crew.
An integrated Web browser for quick surfing of MSDN or on-line assist.
Integration of Help from on line groups.
A academic on SQL Server Management Studio that will help you take benefit of the various new capabilities and end up greater productive proper away.
A new interest display with filtering and automated refresh.
Integrated Database Mail interfaces.
SAS Programming Interview Questions
Question 3. What Are The New Scripting Capabilities Of Ssms?

Answer :

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

Dynamic Help for immediate get right of entry to to applicable records whilst you figure.
A wealthy set of templates with the ability to create custom templates.
Support for writing and enhancing queries or scripts with out requiring a connection to a server.
Scripting assist for SQLCMD queries and scripts.
A new interface for viewing XML effects.
Integrated source manipulate for solution and script tasks, helping storing and preserving copies of scripts as they evolve through the years.
Microsoft IntelliSense support for MDX statements.
Question 4. What Are The Tool Windows In Sql Server Management Studio?

Answer :

Tool Windows in SQL Server Management Studio : SQL Server Management Studio affords many effective tool home windows for all levels of development and management. Some equipment can be used on any SQL Server issue, and others are for certain additives handiest.The following  equipment that can be used for all components of SQL Server.

Object Explorer
Solution Explorer
Template Explorer
Dynamic Help
 

SAS Programming Tutorial
Question five. What Is The Purpose Of Object Explorer And Its Features?

Answer :

Purpose of Object Explorer : Browse servers, create and find gadgets, manage facts sources, and view logs. This device is accessed from the View menu.

Object Explorer Features : The Object Explorer thing of SQL Server Management Studio is an included device for viewing and coping with objects in all server kinds. It functions:

Filtering through all or a part of a name, schema, or date.
The asynchronous population of gadgets, with the ability to clear out items based on their metadata.
Access to SQL Server Agent on replication servers for management.
 

PL/SQL and Informatica Interview Questions
Question 6. What Is The Difference Between The Export /import Functions In Sql Studio And Standalone Sql Manager?

Answer :

The Data Export/Import equipment of SQL Studio include some additional features which aren't available in SQL Manager for SQL Server, together with:

export/import records from/to several tables simultaneously;
export/import information from/to tables decided on from special databases on one host;
a command-line application to export/import records using the configuration report with all of the export/import alternatives;
a single registered database repository.
Question 7. What Are The Benefits And Tasks Of Object Explorer?

Answer :

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

Benefits of Object Explorer : Object Explorer affords a hierarchical user interface to view and manage the objects in every instance of SQL Server. The Object Explorer Details pane provides a tabular view of instance gadgets, and the capability to search for unique items. The abilties of Object Explorer range barely depending at the sort of server, but generally include the development features for databases, and control features for all server kinds.

Object Explorer Tasks : 

Open and Configure Object Explorer : Describes the way to open the Object Explorer and configure the alternatives that define the conduct of the explorer. 
Connect to an Instance From Object Explorer : Describes the way to connect Object Explorer to an instance of the Database Engine, Analysis Services, Reporting Services, and Integration Services. 
Manage Objects through Using Object Explorer : Describes a way to manage gadgets represented as nodes inside the Object Explorer hierarchy. 
Object Explorer Details Pane : Describes the Object Explorer Details Pane, a tabular view of all the items inside the server with a person interface to manage them. 
Custom Reports in Management Studio : Describes methods to run custom reviews in SQL Server Management Studio.

Spark SQL Programming Tutorial SSIS(SQL Server Integration Services) Interview Questions
Question 8. Can I Save My Report As Html, Excel Or Word?

Answer :

Yes, open the file through double-clicking on it in the DB Explorer of SQL Manager and pick out the 'Save file as' item within the Navigation bar or toolbar, and specify the format you need to keep to within the "Save as type" discipline

Question nine. What Is Ems Sql Management Studio?

Answer :

EMS SQL Management Studio is a whole answer for database management and development. SQL Studio is an integrated suite of effective database control tools united in a single clean-to-use paintings environment. Developers will recognize its ability to create/edit/drop any database gadgets and will find metadata and information assessment, facts export/import and take a look at records technology tools extremely useful. Database migration, backup and repair equipment can be of super help to DBAs. The Scheduler will automate a massive part of DBA's work.

SSRS(SQL Server Reporting Services) Interview Questions
Question 10. Sql Studio Em Braces A Variety Of Capabilities, But Will I Need Them All? Is There A Simpler Product ?

Answer :

 It may not be immediately obvious why you would want such a lot of one-of-a-kind equipment. We would love to factor out that your revel in will build up day in and day trip, you will face new, more complex duties and you will need more tools to solve them. SQL Studio embraces ALL ought to-have gear for DBAs and developers. And it will be in keeping with your growing knowledge! Besides, when you make yourself familiar with SQL Studio gear, you will be capable of find the most effective, maximum appropriate and dependable solutions on your obligations! We do recognise that our product is used now not simplest through specialists, that is why we covered plenty of Wizards with a purpose to make the activity clean and fun even for a beginner. The Studio interface is designed in order that the thing equipment are called only while wished, not to avert your work. Our experience suggests that most of the people of our customers get used to our products surely rapid, and we've got never acquired any downgrade requests.

DocumentDB SQL Tutorial
Question eleven. What Do I Need To Start Working With Sql Studio?

Answer :

In order to begin working with SQL Studio, you want to down load the installation package from the down load page to be had at our website online. Then run the installation document on a MS Windows pc (see System requirements for info). When the set up is finished, the program is ready for use inside the trial mode. You can examine the trial model for 30 days. This is the time which will make a buying selection.

MYSQL DBA Interview Questions
Question 12. Can I Work With Several Databases Simultaneously?

Answer :

Yes, SQL Studio lets in you to paintings with a vast quantity of databases on the identical time. Once the database is registered at the database source repository correctly, you're prepared to use it.

SAS Programming Interview Questions
Question 13. Why Does Sql Studio Use A Single Registered Database Repository?

Answer :

The single registered database repository permits one database to be accessed with all SQL Studio tools. If to procure our product suites (bundles) formerly, you needed to input the database facts in each tool you used. That in the end brought about huge time losing and typing mistakes. Now the problem is solved within the Studio with the assist of the unmarried registered database repository.

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 difficulty regarding installation on disks having extra than 2Tb of loose space.  The default folder for logs now points to the user's profile.  The community notifications (NetSend) did not work on Windows Vista and more moderen.SQL Studio Agent utilized a hundred% of CPU whilst the venture generated a massive log. Fixed now. The jogging methods are now stopped correctly while updating. Wrong encoding of logs with enabled localization has been constant. Lots of different upgrades and worm-fixes.

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

Answer :

To create a record based totally on a question, you can use the Create Report Wizard in SQL Manager for SQL Server. You want to pick out Master Data band on the second one step of the wizard, double-click on on it or click on the Edit button and specify the question on your report. After that you want to set options in different steps of the wizard and press Finish.

Oracle MySQL 5.6 Database Administrator Interview Questions
Question 16. To Which Devices Can A Backup Be Created And Where Should These Devices Be Located?

Answer :

A backup copy may be created in a logical backup tool, a record, on the tape or in the named pipe. In all the instances the device ought to be placed on the server or inside the nearby community in which the server is mounted. The route to the device is described from the server side. To use the network devices, SQL Server Service ought to be launched from the consumer call that has access to the device.

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 application does no longer have a log document, and the log information is handiest displayed at the screen (in text mode), then SQL Studio can shop these information as a log. To do so, please check the "Save display to log" container whilst growing a task.

DB2 SQL Programming Interview Questions
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 paintings with log files. While creating a Step inside the Task, you may specify the area of the log record of the software to be accomplished. When selecting the equipment from SQL Studio, the location of the log document is stuffed robotically. Log documents of the finished steps are stored in the inner SQL Studio database and are available in the Logs menu.

PL/SQL and Informatica Interview Questions
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 each operations: you could both delete a template from the registered template listing most effective, or delete it additionally from the difficult disk.

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

Answer :

To create a template for the Import tool, you ought to run the Import device (Run you may need to fill in all of the necessary import parameters the use of the Next button. At the remaining wizard step you have to outline the name and region of the newly created template the use of the Tools item.

SQLite Interview Questions