Saturday, December 17, 2011

C# MVC WCF .NET SQL Questions

  

Q. Explain Manifest and Metadata of an Assembly

[Answers]

Q.

What are Generics ?

[Answers]

 

Q.

Explain performance of Generics.

 

 

Q.

Difference between Arraylist and List?

 

 

Q.

Converting Arraylist to List.

 

 

Q.

Converting List to Arraylist

 

 

Q.

What is the CLR?

 

 

Q.

What is the CTS?

 

 

Q.

What is the CLS?

 

 

Q.

What is IL?

 

 

Q.

What does 'managed' mean in the .NET context?

 

 

Q.

What is reflection?

 

 

Q.

What is an assembly?

 

 

Q.

How can I produce an assembly?

 

 

Q. What are different types of assembly
Q.

What is the difference between a private assembly and a shared assembly?

Q.

How do assemblies find each other?

Q.

How does assembly versioning work?

Q.

What is an Application Domain?

Q.

How does an AppDomain get created?

Q.

What is garbage collection?

Q.

Is it true that objects don't always get destroyed immediately when the last reference goes away?

Q.

Why doesn't the .NET runtime offer deterministic destruction?

Q.

Does non-deterministic destruction affect the usage of COM objects from managed code?

Q.

Finalize methods should be avoided. Should I implement Finalize on my class?

Q.

Do I have any control over the garbage collection algorithm?

Q.

How can I find out what the garbage collector is doing?

Q.

What is serialization?

Q.

Does the .NET Framework have in-built support for serialization?

Q.

BinaryFormatter?

Q. Can I customise the serialization process?
Q.

Why is XmlSerializer so slow?

Q.

Why do I get errors when I try to serialize a Hashtable?

Q. XmlSerializer is throwing a generic "There was an error reflecting MyClass" error. How do I find out what the problem is?
Q.

What are attributes?

Q. How to do Attribute programming?
Q.

Can I create my own metadata attributes?

Q.

What is Code Access Security (CAS)?

Q.

How does CAS work?

Q.

Who defines the CAS code groups?

Q.

How do I define my own code group?

Q.

How do I change the permission set for a code group?

Q. Can I create my own permission set?
Q.

I can't be bothered with all this CAS stuff. Can I turn it off?

Q.

Can I look at the IL for an assembly?

Q.

Can source code be reverse-engineered from IL?

Q.

How can I stop my code being reverse-engineered from IL?

Q. Can I write IL programs directly?
Q.

Can I do things in IL that I can't do in C#?

Q.

Is COM dead?

Q. Is DCOM dead?
Q.

Can I use COM components from .NET programs?

Q.

Can I use .NET components from COM programs?

Q.

Is ATL redundant in the .NET world?

Q.

How does .NET remoting work?

Q. How can I get at the Win32 API from a .NET program?
Q. How do I read from a text file?
Q.

How do I write to a text file?

Q.

How do I read/write binary files?

Q.

How do I delete a file?

Q.

Are regular expressions supported?

Q.

How do I download a web page?

Q.

How do I use a proxy?

Q.

Is DOM supported?

Q.

Is SAX supported?

Q.

Is XPath supported?

Q. THREADING
Q.

Is multi-threading supported?

Q.

How do I spawn a thread?

Q.

How do I stop a thread?

Q.

How do I use the thread pool?

Q.

How do I know when my thread pool work item has completed?

Q.

How do I prevent concurrent access to my data?

Q.

Is there built-in support for tracing/logging?

Q.

Can I redirect tracing to a file?

Q.

Can I customise the trace output?

Q. What platforms support .NET?
Q.

What are the fundamental differences between value types and reference types?

Q.

Structs are largely redundant in C++. Why does C# have them?

Q.

How would you define an Anonymous Functions? What is the difference between Anonymous Methods and Lambda Expressions?

Q.

How does an Enumerator (IEnumerable & IEnumerator) work ? How does an Iterator work in C# 2.0 ?

Q.

What is Garbage Collection ? How does it work ? What are generations in GC ?

Q.

What is the role of an Extension Method ? When would you use it ?

Q.

What is a Lambda Expression ? Where would you use it ?

Q.

How would you define a new custom event ?

Q. Difference between Debug and Release
Q. How would you choose between a pure abstract base class and an interface
Q.

What is MVC how does it differ from MVP ?

Q.

1. What is Dependency Injection / Inversion of Control ?

Q.

1. What Design Patterns are you familiar with ?

Q. What’s the implicit name of the parameter that gets passed into the class’ set method?
Q. How do you inherit from a class in C#?
Q. Does C# support multiple inheritance?  HOW ?
Q. When you inherit a protected class-level variable, who is it available to?
Q. Are private class-level variables inherited?
Q. Describe the accessibility modifier protected internal.
Q. C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write?
Q. What’s the top .NET class that everything is derived from?
Q. How’s method overriding different from overloading?
Q. What does the keyword virtual mean in the method definition?
Q. Can you declare the override method static while the original method is non-static?
Q. Can you override private virtual methods?
Q. Can you prevent your class from being inherited and becoming a base class for some other classes?
Q. Can you allow class to be inherited, but prevent the method from being over-ridden?
Q. What’s an abstract class?
Q. When do you absolutely have to declare a class as abstract (as opposed to free-willed educated choice or decision based on UML diagram)?
Q. What’s an interface class?
Q. Why can’t you specify the accessibility modifier for methods inside the interface?
Q. Can you inherit multiple interfaces?
Q. And if they have conflicting method names?
Q. What’s the difference between an interface and abstract class?
Q. How can you overload a method?
Q. If a base class has a bunch of overloaded constructors, and an inherited class has another bunch of overloaded constructors, can you enforce a call from an inherited constructor to an arbitrary base constructor?
Q. What’s the difference between System.String and System.StringBuilder classes?
Q. What’s the advantage of using System.Text.StringBuilder over System.String?
Q. Can you store multiple data types in System.Array?
Q. What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?
Q. How can you sort the elements of the array in descending order?
Q. What’s the .NET datatype that allows the retrieval of data by a unique key?
Q. What’s class SortedList underneath?
Q. Will finally block get executed if the exception had not occurred?
Q. What’s the C# equivalent of C++ catch (…), which was a catch-all statement for any possible exception?
Q. Can multiple catch blocks be executed?
Q. Why is it a bad idea to throw your own exceptions?
Q. What’s a delegate?
Q. What’s a multicast delegate?
Q. How’s the DLL Hell problem solved in .NET?
Q. What are the ways to deploy an assembly?
Q. What’s a satellite assembly?
Q. What namespaces are necessary to create a localized application?
Q. What’s the difference between // comments, /* */ comments and /// comments?
Q. How do you generate documentation from the C# file commented properly with a command-line compiler?
Q. What’s the difference between <c> and <code> XML documentation tag?
Q. Is XML case-sensitive?
Q. What debugging tools come with the .NET SDK?
Q. What does the This window show in the debugger?
Q. What does assert() do?
Q. What’s the difference between the Debug class and Trace class?
Q. Why are there five tracing levels in System.Diagnostics.TraceSwitcher?
Q. Where is the output of TextWriterTraceListener redirected?
Q. How do you debug an ASP.NET Web application?
Q. What are three test cases you should go through in unit testing?
Q. Can you change the value of a variable while debugging a C# application?
Q. Explain the three services model (three-tier application).
Q. What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
Q. What’s the role of the DataReader class in ADO.NET connections?
Q. What is the wildcard character in SQL? Let’s say you want to query database with LIKE for all employees whose name starts with La.
Q. What does Dispose method do with the connection object
Q. What connections does Microsoft SQL Server support?
Q. Which one is trusted and which one is untrusted?
Q. Why would you use untrusted verificaion?
Q. What does the parameter Initial Catalog define inside Connection String
Q. What’s the data provider name to connect to Access database?
Q. What is a pre-requisite for connection pooling?
Q. What’s the implicit name of the parameter that gets passed into the class’ set method?
Q. How do you inherit from a class in C#?
Q. Does C# support multiple inheritance?
Q. When you inherit a protected class-level variable, who is it available to?
Q. Are private class-level variables inherited?
Q. Describe the accessibility modifier protected internal.
Q. C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write?
Q. What’s the top .NET class that everything is derived from?
Q. How’s method overriding different from overloading?
Q. What does the keyword virtual mean in the method definition?
Q. Can you declare the override method static while the original method is non-static?
Q. Can you override private virtual methods?
Q. Can you prevent your class from being inherited and becoming a base class for some other classes?
Q. Can you allow class to be inherited, but prevent the method from being over-ridden?
Q. What’s an abstract class?
Q. When do you absolutely have to declare a class as abstract (as opposed to free-willed educated choice or decision based on UML diagram)?
Q. What’s an interface class?
Q. Why can’t you specify the accessibility modifier for methods inside the interface?
Q. Can you inherit multiple interfaces?
Q. And if they have conflicting method names?
Q. Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process.
Q. What’s the difference between Response.Write() andResponse.Output.Write()?
Q. What methods are fired during the page load?
Q. Where does the Web page belong in the .NET Framework class hierarchy?
Q. Where do you store the information about the user’s locale?
Q. What’s the difference between Codebehind="MyCode.aspx.cs" andSrc="MyCode.aspx.cs"?
Q. What’s a bubbled event?
Q. Suppose you want a certain ASP.NET function executed on MouseOver overa certain button. Where do you add an event handler?
Q. What data type does the RangeValidator control support?
Q. Explain the differences between Server-side and Client-side code?
Q. What type of code (server or client) is found in a Code-Behind class?
Q. Should validation (did the user enter a real date) occur server-side or client-side? Why?
Q.
What does the "EnableViewState" property do? Why would I want it on or off?
Q. What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
Q.

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

Q. you give an example of what might be best suited to place in the Application_Start and Session_Start subroutines? 
Q. Can you explain what inheritance is and an example of when you might use it?
Q. Whats an assembly? 
Q. Describe the difference between inline and code behind
Q. Explain what a diffgram is, and a good use for one?
Q. . Whats MSIL, and why should my developers need an appreciation of it if at all?
Q. Which method do you invoke on the DataAdapter control to load your generated dataset with data?
Q. Can you edit data in the Repeater control?
Q. Which template must you provide, in order to display data in a Repeater control?
Q. How can you provide an alternating color scheme in a Repeater control?
Q. What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?
Q. What base class do all Web Forms inherit from?
Q. Name two properties common in every validation control?
Q. . What tags do you need to add within the asp:datagrid tags to bind columns manually?
Q. What tag do you use to add a hyperlink column to the DataGrid?
Q. What is the transport protocol you use to call a Web service?
Q. What does WSDL stand for?
Q. What is UDDI
Q. What is SOAP
Q. To test a Web service you must create a windows application or Web application to consume this service?
Q. How many classes can a single .NET DLL contain?
Q. Can you write a class without specifying namespace? Which namespace does it belong to by default??
Q. You are designing a GUI application with a window and several widgets on it. The user then resizes the app window and sees a lot of grey space, while the widgets stay in place. What’s the problem?
Q. How can you save the desired properties of Windows Forms application?
Q. So how do you retrieve the customized properties of a .NET application from XML .config file?
Q. Can you automate this process?
Q. My progress bar freezes up and dialog window shows blank, when an intensive background process takes over.
Q. What’s the safest way to deploy a Windows Forms app?
Q. Why is it not a good idea to insert code into InitializeComponent method when working with Visual Studio?
Q. What’s the difference between WindowsDefaultLocation and WindowsDefaultBounds?
Q. What’s the difference between Move and LocationChanged? Resize and SizeChanged?
Q. How would you create a non-rectangular window, let’s say an ellipse?
Q. How do you create a separator in the Menu Designer?
Q. How’s anchoring different from docking? page 16
Q. What is Code Refactoring?
Q. What does the term immutable mean?
Q. ASP.Net Web Matrix ?
Q. IIS port number? How We get it ?
Q. Diffrence between Abstract and Interface ?
Q. Explain State management in Asp.net
Q. Diffrence between Viewstate and Session ?
Q. How to Write to XML File?
Q. What is Boxing & Unboxing ?
Q. Define three test cases you should go through in unit testing ?
Q. What debugging tools come with the .NET SDK ?
Q. What does assert() method do ?
Q. What is DiffGram ?
Q. Diffrence Between ServerSide and ClientSideCode ?
Q. Something about Session ?
Q. What is Server.Transfer and Response.Redirect ?
Q. Server Control and User Control ?
Q. ACID in transactions ?
Q. what is Connection pool ? What is the default value and can we change the value
Q. What is correlated sub-query?
Q. What is PostBack & Callback?
Q. What is Cursor ?
Q. What is AUTOEVENTWIREUP?
Q. Diffrence between Code Directory and Bin Directory ?
Q. Diffrence between DataReader and DataAdapter ?
Q. Does SQLClient and OLEdb class share the same function ?
Q. Difference between Data reader and Dataset ?
Q. Diffrence between function and StoreProcedure ?
Q.

How to do direct csv importing in SQL Stored procedure only

Q. How to do SQL table to CSV file using only stored procedure
Q.

Getting list of files in a folder using SQL SP

REMOTING
Q. What’s a Windows process?
Q. What’s typical about a Windows process in regards to memory allocation?
Q. Why do you call it a process? What’s different between process and application in .NET, not common computer usage, terminology?
Q. What distributed process frameworks outside .NET do you know?
Q. What are possible implementations of distributed applications in .NET?
Q. When would you use .NET Remoting and when Web services?
Q. What’s a proxy of the server object in .NET Remoting?
Q. What are remotable objects in .NET Remoting?
Q. What are channels in .NET Remoting?
Q. What security measures exist for .NET Remoting in System.Runtime.Remoting?
Q. What is a formatter?
Q. Choosing between HTTP and TCP for protocols and Binary and SOAP for formatters, what are the trade-offs?
Q. What’s SingleCall activation mode used for?
Q. What’s Singleton activation mode? A
Q. How do you define the lease of the object?
Q. Can you configure a .NET Remoting object via XML file?
Q. How can you automatically generate interface for the remotable object in .NET with Microsoft tools?
Q.
How IIs process for the ASP.Net Requests?
Answer ...
Q.

what is the difference between the Adapter Pattern and Proxy Patterns?its seems both are almost similar?

Answer...
Q. Explain SaaS Answer ...
Q.
What is Builder Pattern
Answer..
Q.
What is Lazy design pattern?
Answer...
Q.
What is prototype pattern in C#
Answer...
Q.
Comparison / Difference .net framework 2.0-3.5-4.0
Answer...
Q.
Explain Behavioural Design Pattern
Answer...
Q.
what are different types of Proxy Pattern in C#
Answers
Q.
What is structural design pattern
Answers