Interview Questions
1. What are the Type of SQL instances and maximum no. of instances that can be installed on a server?
There are two types of Instances.
- Default instance
- Named Instance
Each computer can run a maximum of 50 instances of the Database Engine. One instance can be the default instance.
The default instance has no name. If a connection request specifies only the name of the computer, the connection is made to the default instance.
A named instance is one where you specify an instance name when installing the instance.
A connection request must specify
both the computer name and instance name in order to connect to the instance.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment