SQL SERVER INTERVIEW QUESTION & ANSWERS
| 26. |
Tell me the no.of editions in SQL SERVER 2008. |
| |
- SQL Server Express Edition
- SQL Server Workgroup Edition
- Web Edition
- Standard Edition
- Enterprise Edition
- Developer Edition
|
| 27. |
Explain Full-Text Search Services. |
| |
Full-text indexing and special query syntax let you effectively search large text blocks for patterns, word forms, proximities, and other elements. SQL Server 2008 provides some compelling enhancements to the full-text set of services. They include features such as improved full-text index management and performance enhancements. |
| 28. |
Tell me the SQL Server dependencies or integrations. |
| |
- Team Foundation Server
- Systems Management Server/System Center Configuration Manager
- Office SharePoint Server
- Office Project Server
- Operations Manager Server
- BizTalk Server
- ADO.NET
|
| 29. |
Is this secure to install SQL SERVER on C DRIVE? |
| |
No. Because if Operating System has badsector on C DRIVE and we wish to format at that time, we cannot recover the formatted data.
|
| 30. |
What do you know about SQL Server management Studio? |
| |
This is the primary SQL Server client. Introduced in SQL Server 2005, this utility replaces the
Enterprise Manager and Query Analyzer tools found in SQL Server 2000 and earlier versions. Using this one tool, we should be able to handle the majority of administrative and development tasks.
We will find the SQL Server Management Studio in the SQL Server program group in the Start menu. When we launch it, we will be prompted to log in. This is not required, but if we do log in, the tool will populate its Object Browser with catalog information and we will be able to perform tasks within SQL Server Management Studio without further authentication. How we authenticate will depend on the security setting that we choose when we installed the server. |
