New : »Puzzles Questions
SQL SERVER INTERVIEW QUESTION & ANSWERS
|1.||What are the componnents SQL SERVER provides while installing?|
|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.|
|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.
|4.||DBCC stand for?|
|Database Console Commands (DBCC) is the INDEXDEFRAG statement.|
|5.||What are the Active Directory schema objects?|