SQL SERVER INTERVIEW QUESTION & ANSWERS
| 6. |
Can we have more than one default instance for SQL Server 2008? |
| |
No. Only one instance can be the default. All others are named instances. |
| 7. |
How can we change the password for SQL Server Service? |
| |
The easiest way is to use Enterprise Manager to change the password on SQL Server. Additionally, you need to change the password on the domain. It is important to keep the passwords synchronized. |
| 8. |
You are using SQL Server 2008 as the back-end database for your Web site application that is available on the Internet. What version and licensing do you need? |
| |
To support unlimited connections, SQL Server 2008 requires processor licensing. Upgrade pricing for licensing is approximately 50 percent off regular pricing. Upgrade pricing also includes competitive upgrades from products such as those from Oracle and Sybase. The Internet Connector license option is no longer available; Internet Connector license owners may upgrade to processor licensing at regular upgrade prices. |
| 9. |
Explain Local vs. Remote Installation. |
| |
SQL Server offers both local and remote installation options. Local options install SQL Server on the local machine; remote options install SQL Server on a remote machine.
In order to properly install SQL Server on a remote machine, it’s necessary that you have administrative rights on the remote machine. Be sure you have the appropriate rights to the computer on which we are installing SQL before you begin the installation process. |
| 10. |
Can we run SQL Server 2008 and SQL Server 2005 on the same machine? |
| |
Yes. They can run concurrently. The SQL Server 2005 instance becomes the default instance. |
