FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

SQL SERVER INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
1. What are the componnents SQL SERVER provides while installing?
 
  • Active Directory Services
  • Internet Information Services (IIS)
  • Active Server Pages+ (with the release of .NET)
  • Message Queue Server (MSMQ)
  • COM+
  • Data Access (ActiveX Data Objects+, OLE-DB, ODBC)
  • Security Service
  • Network Load Balancing
  • Cluster Services
Your Name Your Email-ID
Your Answer
 
2. Define Microsoft Exchange Server.
  Microsoft Exchange Server 2000 Provides messaging and collaboration services such as e-mail, videoconferencing, and instant messaging. Provides Active Directory integration.
Your Name Your Email-ID
Your Answer
 
3. Tell me about User Define Function.
  The process of creating UDFs is similar to creating other objects in SQL Server. The CREATE FUNCTION statement allows us to define input parameters and the return parameter type of your custom function.

A user-defined function is a reusable logic set that can be called to perform set actions and return a given result. User-defined functions are similar to stored procedures except that they can return data type results, allowing them to be used in line with T-SQL statements.
Your Name Your Email-ID
Your Answer
 
4. DBCC stand for?
  Database Console Commands (DBCC) is the INDEXDEFRAG statement.
Your Name Your Email-ID
Your Answer
 
5. What are the Active Directory schema objects?
 
  • MS-SQL-SQLServer SQL Server instance.
  • MS-SQL-SQLPublication SQL Server replication publication.
  • MS-SQL-SQLDatabase SQL Server database instance.
  • MS-SQL-OLAPServer SQL Server Analysis Server instance.
Your Name Your Email-ID
Your Answer