Floating FB popout byF5debug

Windows Phone development explained step by step with a 31 days series with source code and example in detal!!!
Detailed interview question and answers on .Net Framework, ASP.Net, C#, SQL Server, OOPS and WCF!!!
A free download to the community, which has the step by step tutorial on Learning SQL Server Integration Services!!!
A free download to the community, which has the step by step tutorial on Learning Windows Phone Development!!!

SQL Server Integration Services (SSIS) – Part 19 – ActiveX Script task container

  This is part 19 of the series of article on SSIS. It describes using ActiveX Script task container in SSIS package. Introduction In this article we are going to see on how to use ActiveX Script task container in SSIS packaging. Here we take some simple example of executing a VB Script at runtime using the ActiveX Script task container. This task container is mostly used on when we move the SQL 2000 DTS objects to SSIS packaging. So this task container is used to customize our process of writing script and executing those scripts at runtime. Let’s see a simple example of how to ... [More]

SQL Server Integration Services (SSIS) – Part 18 – Bulk Insert task in SSIS

  This is part 18 and the article of the series of article on SSIS. In this article, we are going to learn how to bulk insert in SSIS. Introduction In this article we are going to see on how to use Bulk Insert task in SSIS, This task as name specifies uses the BULK insert of the values to the destination. Destination can be any of the data source as we have like OLEDB, excel, etc. Let’s jump into this and see on how to use this task and how to configure the same using SSIS packaging. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx [mo... [More]

SQL Server Integration Services (SSIS) – Part 17 – Create/Delete a table in SQL using SSIS

  This is part 17 of the series of article on SSIS and shows how to create/delete a table in SQL using SSIS. Introduction In this article we are going to see on how to run a query from SSIS. Mainly create or delete a table from SSIS package. We have a task called Execute SQL Task in SSIS which helps us to do this task. Let’s see on how to use this task and create a table using SSIS. This task will be mainly used in scenario like if at all we need to check if table exists or not and to create a table using this task. You can look into my series of article on SSIS at the url - http://f5... [More]

SQL Server Integration Services (SSIS) – Part 16 – Sequential Container Task in SSIS

  This is part 16 of the series of article on SSIS where I shall show how to work with sequential Container Task in SSIS. Introduction In this article we are going to see on how to use a Sequential Task container. This container is used in areas where the process needs to follow certain tasks sequentially. Sequential Task groups the tasks into multiple control flows and executes the process sequentially. We can use this task widely based on our requirement like, disabling a sequence when it should not process, use it when managing multiple tasks at a same time in one location. We can e... [More]

SQL Server Integration Services (SSIS) – Part 15 – Conditional Split Task in SSIS

  Introduction In this article we are going to see on how to use a Conditional Split task based on the decision. Conditional tasks transformation will be used to split the data based on some condition and save the result set in different destinations. This task will be very useful at cases like to insert some passed test cases data to Database and the failed test cases data to the text file or sending a mail to the administrator. [more] Steps: Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once th... [More]

SQL Server Integration Services (SSIS) – Part 14 – Folder Structure in SSIS

  This is part 14 of the series of article on SSIS. In this article I shall describe the folder structure used in Deploying the SSIS package and the usage of those folders. Introduction In this article we are going to see on the folder structure used in deploying the SSIS package and the usage of those folders. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx [more]   SSIS Folder Structure When ever we create a SSIS package and we completed with our development task and finally to deploy the package we need to follow some folde... [More]

SQL Server Integration Services (SSIS) – Part 13 – Backup Database task in SSIS and Send Mail

  This is part 13 of the series of article on SSIS Introduction In this article we are going to see on how to use a Backup Database task to create an execution plan in SSIS to take a database backup. This task will be very helpful for the DBA’s to maintain the database automatically by creating the package and using it across the servers. This task has many options to do a Full, Differential backups based on our requirement we can go ahead and use the respective option. Let’s jump into the steps on how to create and use the backup database task You can look into my series of article o... [More]

SQL Server Integration Services (SSIS) – Part 12 – For Loop task in SSIS Packages

  This is part 12 of the series of article on SSIS Introduction In this article we are going to see on how to use a For Loop container task in SSIS packaging. For loop task is the looping implementation of a task by which the task will evaluate an expression and loops through the process and until the evaluation goes to False. We will see through the steps on using this container and how to configure the properties associated with this task. You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx [more] Steps Follow steps 1 to 3 on my first... [More]

SQL Server Integration Services (SSIS) – Part 11 – Send Mail in SSIS Packages

  This is part 11 of the series of article on SSIS Introduction In this article we are going to see on how to send a mail from SSIS using the SMTP services. This send mail concept is used in real time when the packages are automated and to notify the end user at certain circumstances about the execution process or also about any failure in process or any things need to be skipped as the business needs.  We have an option here as Send Mail Task which is used to perform the task which have been discussed. Let’s discuss in detail about this task. This article will show on how to set... [More]

SQL Server Integration Services (SSIS) – Part 10 – Check Points in SSIS Packages

  This is part 10 of the series of article on SSIS Introduction In this article we will look into the Check point’s usage in SSIS package. Check points are nothing but a structure where we can restart the package at the point where it fails without having to restart from the first step. This feature is an added advantage for SSIS packaging which provides a better performance in order to achieve complex tasks. Check point saves the configuration details in a XML file which acts as the source for the later execution section. The package once restarted the default point is restored ... [More]

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter
F5debug | Interview Questions and Answers on .Net Framework, OOPS, ASP.Net, C#.Net, SQL Server, WCF Series – Part 9

Floating FB popout byF5debug

Interview Questions and Answers on .Net Framework, OOPS, ASP.Net, C#.Net, SQL Server, WCF Series – Part 9

 

Question 81 - What are the Types of Inheritance?

  • Implementation inheritance refers to the ability to use a base class's properties and methods with no additional coding.
  • Interface inheritance refers to the ability to use just the names of the properties and methods, but the child class must provide the implementation.
  • Visual inheritance refers to the ability for a child form (class) to use the base forms (class) visual representation as well as the implemented code.


Question 82 - What is Multiple Inheritance?

C# does not support multiple implementation inheritance. A class cannot be derived from more than one class, However, a class can be derived from multiple interfaces.


Question 83 - What are the examples of Multiple Inheritance?

Imagine a class named TransmitData, whose function is to transmit data, and another class named ReceiveData, whose function is to receive data. Now imagine that you want to create a class named SocketPort, whose function is to transmit and receive data. In order to accomplish this, you would want to derive SocketPort from both TransmitData and ReceiveData.


Question 84 - What are the Advantages of Inheritance?

  • Once a behavior (method) or property is defined in a super class(base class),that behavior or property is automatically inherited by all subclasses (derived class).
  • Code reusability increased through inheritance.
  • Inheritance provide a clear model structure which is easy to understand without much complexity Using inheritance, classes become grouped together in a hierarchical tree structure Code are easy to manage and divided into parent and child classes.


Question 85 - What is an Encapsulation?

  • Encapsulation is a process of hiding all the internal details of an object from the outside world.
  • Encapsulation is the ability to hide its data and methods from outside the world and only expose data and methods that are required
  • Encapsulation gives us maintainability, flexibility and extensibility to our code.
  • Encapsulation makes implementation inaccessible to other parts of the program and protect from whatever actions might be taken outside the function or class.
  • Encapsulation provides a way to protect data from accidental corruption
  • Encapsulation hides information within an object
  • Encapsulation is technique or process of making fields in a class private and providing access to the fields using public methods
  • Encapsulation allows us to create a "black box" and protects an objects internal state from corruption by its clients.
  • The idea of encapsulation comes from the need to cleanly distinguish between the specification and the implementation of an operation and the need for modularity.

Question 86 - What are the examples of Encapsulation?

  • Let's say you have an object named Bike and this object has a method named start(). When you create an instance of a Bike object and call its start() method you are not worried about what happens to accomplish this, you just want to make sure the state of the bike is changed to 'running' afterwards. This kind of behavior hiding is encapsulation and it makes programming much easier.
  • Video Recorder, which has a record, play, pause buttons is another example of encapsulation, so VCR is encapsulated into a single object where the internals can change but stays the same for users interface point of view.
  • Medical Capsules i.e. one drug is stored in bottom layer and another drug is stored in Upper layer these two layers are combined in single capsule.


Question 87 - What is an Abstraction?

  • Abstraction means to show only the necessary details to the client of the object.
  • Abstraction is about paying attention to the details that are relevant and ignoring the rest.
  • It refers to act of representing essential features without including background details / explanations.


Question 88 - What are the examples of Abstraction?

  • Do you know the inner details of the Monitor of your PC? What happen when you switch ON Monitor? No Right, Important thing for you is weather Monitor is ON or NOT.
  • When you change the gear of your vehicle are you really concern about the inner details of your vehicle engine? No but what matter to you is that Gear must get changed that’s it!!
  • Let’s say you have a method "CalculateSalary" in your Employee class, which takes EmployeeId as parameter and returns the salary of the employee for the current month as an integer value. Now if someone wants to use that method. He does not need to care about how Employee object calculates the salary? An only thing he needs to be concern is name of the method, its input parameters and format of resulting member. This is abstraction; show only the details which matter to the user.
  • TV Remote Button in that number format and power buttons and other buttons there just we are seeing the buttons, we don't see the button circuits .i.e buttons circuits and wirings all are hidden.


Question 89 - Difference between Encapsulation and Abstraction ?

Encapsulation

Abstraction

Hiding the internal details or mechanics of how an object does something.

It focus on what the object does instead of how it does it.

Binding data and member functions together inside a single unit.

Hiding the complexities of your type from outside world.

Eg: VCR Example

Eg: Monitor Example


Question 90 - What is an Abstract Class?

  • It is a class that cannot be instantiated, it exists extensively for inheritance and it must be inherited.
  • Abstract classes cannot be used to instantiate objects; because abstract classes are incomplete
  • Abstract classes may contain only definition of the properties or methods.
  • Derived classes that inherit the abstract class needs to implements it's properties or methods.
  • An abstract class is essentially a blueprint for a class without any implementation.
  • An abstract class is a class that must be inherited and have the methods overridden.
        • An abstract class cannot be a sealed class.
        • An abstract method cannot be private.
        • An abstract member cannot be static.
  • An abstract method cannot have the modifier virtual. Because an abstract method is implicitly virtual.
  • The access modifier of the abstract method should be same in both the abstract class and its derived class. If you declare an abstract method as protected, it should be protected in its derived class. Otherwise, the compiler will raise an error.

Disclaimer – F5debug Interview Questions & Answers Series:

You may recopy extracts from these pages ("the material") to individual third party websites or to any intranet websites, but only if:

You acknowledge www.f5debug.net as the source of the material. Such acknowledgment should include reference to www.f5debug.netin the copy of the material and should also include “© Karthikeyan Anbarasan, www.f5debug.net ". You inform the third party that these conditions apply to him/her and that he/she must comply with them.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter