IT Interview Questions

ADO.NET and Database Questions

1. What is the role of the DataReader class in ADO.NET connections?
   It returns a read-only, forward-only rowset from the data source.  A DataReader provides fast access when a forward-only sequential read is needed.




2. What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
   SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix.  OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.
   

Assembly Questions

1. How is the DLL Hell problem solved in .NET?
   Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.
2. What are the ways to deploy an assembly?
   An MSI installer, a CAB archive, and XCOPY command.
3. What is a satellite assembly?
   When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.

What is meant by LATCH?
Latch is a D- type flip-flop used as a temporary storage device controlled by a timing signal, which can store 0 or 1. The primary function of a Latch is data storage. It is used in output devices such as LED, to hold the data for display.

What is 1st / 2nd / 3rd / 4th generation processor?
The processor made of PMOS / NMOS / HMOS / HCMOS technology is called 1st / 2nd / 3rd / 4th generation processor, and it is made up of 4 / 8 / 16 / 32 bits.

Can you be able to identify between Straight- through and Cross- over cable wiring?
Straight-through is type of wiring that is one to to one connection Cross- over is type of wiring which those wires are got switchedWe use Straight-through cable when we connect between NIC Adapter and Hub. Using Cross-over cable when connect between two NIC Adapters or sometime between two hubs.

This is a pretty popular brain teaser with many companies.

On the shelf you have 10 identical bottles of identical pills (let’s say there’s a hundred pills in each bottle). However, one of those 10 bottles contains cheap knockoff pills. The only way to differentiate fake pills from real pills is the weight - while real pills weigh 1 g each, the knockoff pills are only 0.9 g. You have one scale that shows the exact weight (down to the mg) of whatever is weighed.

How can you tell which bottle contains fake pills with just 1 weighing?