Translate to your language...

Showing posts with label Trigger. Show all posts
Showing posts with label Trigger. Show all posts

25 April 2014

2+ yrs .Net Interview Questions and Answers for Quick Reference

Hai Friends,

In the continuation of the series of the Interview Questions in the Microsoft Technologies, I am posting few more questions which will be helpful for the Quick reference in learning the concepts related to WCF, Assembly,  SQL Server,Interface & Abstract Class etc.


1. What is the difference between Web Services and WCF.

Ans. 

A. WCF Services = Web Services + Remoting + Security + Reliability + Messaging Queue

B. Not only that, hosting is also one of the powerful feature in WCF where the service can be hosted in Self Hosting, Hosting in Windows Services, Hosting on another Service etc.

C. Supports DataContractSerializer which is fast and can serialize fields and properties.

D. Integrated Logging mechanism.


2. What are the different ways of hosting a WCF service.
Ans.

A. Hosting on Console application

B. Hosting on Windows application

C. Hosting on Windows services

D. Hosting on IIS

E. Hosting on WAS(Windows Activation Service) 


3. Explain the different types of triggers in SQL Server.
Ans.

A. DDL Trigger- Trigger fires on DDL Commands

B. DML Trigger- Trigger fires on DML Commands

C. InsteadOf Trigger- Trigger fires on View updation


4. Difference between BasicHttpBinding and WSHttpBinding.
Ans.

A. BasicHttpBinding does not enable message level security while the WSHttpBinding enables Message level as well as Transport level security.

B. BasicHttpBinding has the default windows authentication while the WSHttpBinding support WS* authentication and security.

C. BasicHttpBinding only supports HTTP to access the service while WSHttpBinding suppors HTTP and HTTPS(secure)

D. Data which travels through the BasicHttpBinding is in XML format and no encryption allowed while the data travels through WSHttpBinding goes in Encrypted format.


5. What are the different types of assemblies available in .NET?
Ans.

A. Private Assembly

B. Shared Assembly

C. Satellite Assembly


6. What is a strong name and how do you give a strong name to an assembly?
Ans.

Unique identification of an assembly called as strong name. By strong name we can differentiate the assemblies which are having the same name.

We can generate the Strong name using the command:

SN -K dllName

7. What is InsteadOf trigger.
Ans.
 

To update the Views, InsteadOf trigger is used. This is the only use of InsteadOf trigger. There is no use except this.


8. Can we use Insert/Update statements in views in SQL SERVER?

Ans. 

No, In general, View made to works only on the Query/Select command. So we can't have DML commands inside the View. So no Insert/update operations are allowed.

But there is a provision where we can make the views as updatable by using the DML statements inside the views but it is more complicated when there are views which are created by using the joins in the queries.
So its not preferable to make the view as updatable.

9. What are abstract classes and Interface and what the difference between the two.
Ans.

When the class does not provides the full functionality, the class must be declared as the abstract class.

There are 2 types of abstract classes-

A. Partial Abstract Class (Abstract Class)- Class which can support the abstract members(methods, properties) as well as concrete members(methods, properties), the class can be declared as the abstract class.

Abstract class works based on the child class memory. We can't create the object of the abstract class, only the reference can be created for the abstract class.

All the abstract members must be overrides in the child class using the Override keywords.


B. Fully Abstract class (Interface) - The collection of abstract members (methods, properties) is called as interface.

Interface contains all the abstract members.


When you have limited scope for the functionality, Abstract class is better but when there is the requirement to implement the global functions, interface is best way to do.

e.g. When u have some feature which can be implemented in several classes and classes are interrelated, use Abstract class but when the feature can be application level and used by various independent classes, use Interface.


10. What are the advantages of Interface over abstract classes?
Ans.

When you have some feature which can be implemented in several classes and classes are interrelated, use Abstract class but when the feature can be application level and used by various independent classes, use Interface.

Interfaces are more rigid than Abstract classes.

e.g. let's say, i have a method called Show() to show the message in various classes, we can have interface for this. Now let's say, I have implemented this interface in 100 classes where I want to use the Show() method to show some message.

Tomorrow there is some requirement to have the new Print Functionality to let's say in 50 various classes. Now the one way is to add this Print() in the same interface so that we can just implement it to those classes. But what about the rest 50, where we don't want this print.. So this is drawback of Interface.

That is the reason the Single Responsibility principle and then the interface Segregation Principle came where a class/interface should have only one responsibility. Like in the above example, there are more responsibility and got the problem.

Abstract class is best when the scope is limited. Let's say I want to calculate the Area of few shapes. So we can say that this is limited as few classes can use this so we can create the abstract class with the abstract method called Area and then implement to those classes by inheriting the abstract class.

The scope of the Abstract class is till the immediate child class. So you can't use it in grand child or grandparent classes.


11. What is a sealed class?
Ans.
When the class provides full functionality, we can declare the class as Sealed Class. Full functionality means, the class doesn't need anything from outside like loading the external files etc. The sealed class can’t be inherited and can't be extended. We can create the object of sealed class so instantiation of the sealed class is possible.when the class is self-dependent, the class be made as sealed class. 
Overall when we want the class prevented to be inherited, we can declare the class as sealed class. Also If we want that our method should not be overridable, we can create the methods as sealed method.
E.g.If you see the definitions of the datatypes, they all are sealed by default becasue they cant be extended.
public sealed class String : IComparable, ICloneable, IConvertible, IComparable<string>, IEnumerable<char>, IEnumerable, IEquatable<string>
{
  // Summary:
  //     Represents the empty string. This field is read-only.
  public static readonly string Empty;

  // Summary:
  //     Initializes a new instance of the System.String class to the value indicated
  //     by a specified pointer to an array of Unicode characters.
  //
  // Parameters:
  //   value:
  //     A pointer to a null-terminated array of Unicode characters.
  //
  // Exceptions:
  //   System.ArgumentOutOfRangeException:
  //     The current process does not have read access to all the addressed characters.
  //
  //   System.ArgumentNullException:
  //     value is null.
  //
  //   System.ArgumentException:
  //     value specifies an array that contains an invalid Unicode character, or value
  //     specifies an address less than 64000.
  [CLSCompliant(false)]
  [SecurityCritical]
  public String(char* value);
.... 
Here we can see that String class is of Sealed type.We can create the object of the sealed class as:
String obj = new String();
bu we cant inherit these classes as they are not inheritable.


12. What kind of authentication mechanism you have used in your WCF project.
Ans.

There are various authentication modes which can be used for the WCF service like-

A. No Authentication- When the service doesn't requires any authentication and its public to access and use, this type of authentication mode is used.

B. Windows Authentication – This type of service depends on the windows credential so if the user is having the windows credentials, they can use and access the service.

C. Form Authentication – This type of authentication requires certain and valid user name and password to access the service.

D. Certificate Based – There are the secure cervices where each request needs certain authentication mechanism which can be the 3rd party like .X509 certificates to validate the access requests.

E. Custom Authentication- This can be mixed with two or more authentication mechanism.

F. Token Based Authentication – Depends on the token provided by the service provider. So based on the token, the client can access the service.


13. How do you configure a WCF Service to use Network Authentication?

Ans. 

We need to set the remote settings for this.

Below is the reference url:


14. What is Garbage Collection? How is Garbage Collector invoked in .NET?
Ans.

When the heap memory is filled with the objects and there is no memory left to accommodate the new object, Garbage collector gets called by the CLR. So it's an activity which is initiated by the run time (CLR). When the garbage collector gets called, it tries to find out each referenced objects which are in use by the applications. The objects which are not reachable, it marks them to delete. Based on the reachable objects, the garbage collector prepares the object graph, which has the reference of each reachable object. Now based on the object graph which contain the object generations too, the Garbage collector checks for the generation 0 objects and marks them for deletion and move rest of the objects to generation 1. The heap memory gets compacted for the new object and new object gets placed in the heap memory.

This is the uncertain and un-deterministic process as the Garbage collector doesn't know when it will be called. Its all based on the capacity memory of the heap. When the heap memory get filled and a new object is initiated, the runtime (CLR) calls the Garbage collector.


15. Can you force Garbage Collector to be invoked from c# code?
Ans.

Yes, When we have something called the unmanaged objects(C++, VC++,VB 6.0), then we need to explicitly release the memory. To do this, we can use the Dispose() method to free-up these object.

Sometimes, we need to force the garbage collector to be called to free-up the memory, so we can use the GC.Collect() method to do so.


16. How is var keyword used in .NET.Difference between var and dynamic keywords.
Ans. 

var keyword is newly introduces with the .net 3.5 and it is used to make the assignment for any type of data. It can store any type of data irrespective of its datatype.

So when we don't know that what type of data, the certain process will return, we can use the var keyword.

e.g.

var connection = new SqlConnection(connectionString);

Here the connection variable can store the SQLConnection type.
Dynamic keyword is newly introduces with the .net 4.0 version and is used to keep not only the any type of data but also the reference will be constant.

For the var, the type is made at the compile time while in case of Dynamic; the type is inferred in runtime.

e.g.

var customer = new Customer();

customer.GetCustomers();

Here the compiler will check for the GetCustomers()method. If the GetCustomers() method doesn't exists, it will show error during the compilation.
But for the dynamic,

dynamic  customer = new Customer();

customer.GetCustomers();

Here the compiler will not check for the GetCustomers() method during the compilation. But at the run-time, if the method is not available, it will throw error.
So the main use of dynamic is when we don't want the compiler should check for certain errors during compilation. It will skip the error if they are of dynamic type. 


17. Difference between Stored Procedures and Functions.
Ans.

Stored Procedure and Functions are the database objects which are the pre-compiled names SQL statements.

A. Stored procedure can take in as well as Out parameters while function can take only in parameters'.

B. Stored Procedure may or may not return the value while the Function must return a value. Returning a value in stored procedure depends on the input parameter. If the input parameter is of type out, then it will return the value.

C. We can use the function inside the stored procedure but stored procedure can't be used inside a function.


18. What are the different types of contracts available in WCF
Ans.

A. Service Contract- In Interface

B. Operation Contract - For Operations

C. Data Contract -Based on custom type

D. Message Contract - For Custom message

E. Fault Contract - For Error or Exception Handling


19. What is the static variable and what are the static variables in dot net.
Ans.

When the variable is shared by multiple class members (method, properties etc), we can make that variable as Static (in VB.Net Shared). To access these variables, we don't need to create the object of the class. We can directly call the static class members using the Class name. These variables get loaded when the class gets loaded in to the memory.

20. If I have 2 interfaces with same method same parameter and same return type. Both interface implemented from one Class. Then how can i call to these methods.
Ans.

Two interfaces with the same methods and same parameters can be implemented using the external interface functionality, rather than internal interface.
By default, when we implement the interface, we need to implement all the method to the implemented class.
But if the methods are same, then we can take the help of explicit interface as:
interface inf1
{
 void Print();
 void Show();
}
interface inf2
{
 void Print();
 void Show();
}
Now we will implement these interfaces in a single class:
class MyChildClass: inf1, inf2

{
 public void inf1.Print() // explicit interface call
 {
  //implement Print() method details for the first interface
 }
 public void inf1.Show()
 {
  //implement Show() method details for the first interface
 }
 public void inf2.Print()
 {
  //implement Print() method details for the second interface
 }
 public void inf2.Show()
 {
  //implement Show() method details for the second interface
 }
}

21. Can method overloading and overriding possible in simultaneously in program.
Ans.

Yes, both overloading and overriding concept can be implemented simultaneously between the parent can child classes as:
Class MyBaseClass

{
 public void Print()
 {
   // Print method implementation
 }
 public void Print(string fileName) // overloaded method
 {
   // Print method implementation with the file name
 }
 public virtual void Print()
 {
   // Print method implementation
 }
}
Class ChildClass:MyBaseClass
{
 public override void Print() // overriding implementation
 {
   // Print method implementation
 }
}


22. What is the use of "using" keyword?
Ans.

"using" keyword is used in 2 scenarios:
1. To write the namespace as:
using System.Data.SqlClient;

2. To clean up the memory automatically after the use of object as:
using(var f = new SqlCommand())
{
 // some other iomplementation
}

The above code will delete the memory used by the 'f' object after the completion of the transaction.

23. What is dispose and finalize method and how it works
Ans.

Finalize and Dispose methods comes under the System.GC namespace and used to free up the memory occupied the objects. Garbage collector uses these objects to free up the memory.
When there is no enough memory to allocate the new object in the Heap, Garbage collector gets called automatically to free up the memory. It mainly creates the object graph and finds the objects which are not used since longer time. Based on the generations, it removes the objects.
Dispose method is called manually by programmer to remove the objects.
It uses IDisposable interface which has the Dispose method and this can be implemented in the code.

Sr .Net Consultant | MCP Certified | Microsoft Technologies(.Net with Sql Server, MVC, AngularJS

My photo
Kuala Lumpur, Kuala Lumpur, Malaysia
Overall 17.0+ years of experience in software industry as a Programmer/Developer/Architect with Web & Windows application development and Maintenance, including analysis, design, coding, testing and documentation. • Proficient in Microsoft Technologies i.e. Visual Studio with .Net Framework. • Excellent analytical, problem solving, communication, interpersonal skills with the ability to handle multiple tasks or projects working independently or in a team. • Consistent attention to detail with an ability to analyze and interpret the implication of decisions to minimize bugs and create user-friendly applications. • Experience of Collaborating with Clients and Team Members. Ability to convey Technical Information at all levels. • Ability to work with team/management to ensure successful execution of project management tasks including scheduling, scope management, outside dependency coordination and priorities resolution. • Experience in working with global clients like UK, USA, Europe, Australia etc. and teams located remotely (e.g. Sydney, Australia, USA, and Sweden). • Worked with the Swedish client ManpowerGroup at onsite client location Stockholm, Sweden.