IT Interview Questions

  21. What is a Join in SQL Server? -
Join actually puts data from two or more tables into a single result set.

  22. Can you explain the types of Joins that we can have with Sql Server? -
There are three types of joins: Inner Join, Outer Join, Cross Join

  23. When do you use SQL Profiler? -
SQL Profiler utility allows us to basically track connections to the SQL Server and also determine activities such as which SQL Scripts are running, failed jobs etc..

31. What are the authentication modes in SQL Server? -
Windows mode and mixed mode (SQL & Windows).

  32. Where do you think the users names and passwords will be stored in sql server? -
They get stored in master db in the sysxlogins table.

  33. What is log shipping?
Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1.  Are private class-level variables inherited?  -
Yes, but they are not accessible, so looking at it you can honestly say that they are not inherited. But they are.
   2. Why does DllImport not work for me? -
All methods marked with the DllImport attribute must be marked as public static extern.

   3. Why does my Windows application pop up a console window every time I run it? -
Make sure that the target type set in the project properties setting is set to Windows Application, and not Console Application. If you’re using the command line, compile with /target:winexe, not /target:exe.

  11. What is the difference between a struct and a class in C#? -
From language spec: The list of similarities between classes and structs is as follows. Longstructs can implement interfaces and can have the same kinds of members as classes. Structs differ from classes in several important ways; however, structs are value types rather than reference types, and inheritance is not supported for structs. Struct values are stored on the stack or in-line. Careful programmers can sometimes enhance performance through judicious use of structs. For example, the use of a struct rather than a class for a Point can make a large difference in the number of memory allocations performed at runtime. The program below creates and initializes an array of 100 points. With Point implemented as a class, 101 separate objects are instantiated-one for the array and one each for the 100 elements.

# What is datagrid?
The DataGrid Web server control is a powerful tool for displaying information from a data source. It is easy to use; you can display editable data in a professional-looking grid by setting only a few properties. At the same time, the grid has a sophisticated object model that provides you with great flexibility in how you display the data.