Are you an experienced C# developer looking to join IBM? This article is designed to help you prepare for your IBM C# interview by providing a wide range of interview questions and expertly explained answers. Tailored specifically for professionals with 5 years of experience, this comprehensive collection covers essential topics such as C# language features, the .NET framework, object-oriented programming, database connectivity, and more. Dive into this valuable resource to boost your knowledge, build confidence, and excel in your IBM C# interview.
What is an interface in C#?
An interface in C# is a reference type that defines a contract for classes to follow. It specifies a set of methods, properties, and events that the implementing class must provide. Interfaces provide a way to achieve multiple inheritances in C#.
Example:
public interface IShape
{
void Draw();
double CalculateArea();
}
public class Circle : IShape
{
public void Draw()
{
Console.WriteLine("Drawing a circle");
}
public double CalculateArea()
{
// Calculate and return the area of the circle
return Math.PI * radius * radius;
}
}
When do we use interfaces?
Interfaces are used when we want to define a contract that multiple classes can adhere to. It is commonly used for achieving abstraction, providing a common set of methods across different classes, and facilitating loose coupling between components.
What is inheritance? Why do we use inheritance?
Inheritance is a mechanism in object-oriented programming where one class inherits properties and behaviors from another class. It allows the creation of hierarchical relationships between classes. We use inheritance to promote code reuse, enhance modularity, and establish an "is-a" relationship between classes.
How many types of access modifiers are there in C#?
C# provides five access modifiers: public, private, protected, internal, and protected internal.
When do we use the private modifier?
The private access modifier is used to restrict access to members within the same class. It ensures that the member is only accessible from within the class itself and not from any derived classes or external code.
Example:
public class MyClass
{
private int myPrivateField;
private void MyPrivateMethod()
{
// Code here
}
}
What is method overloading in C#?
Method overloading allows us to define multiple methods with the same name but different parameters in the same class. The compiler determines which method to invoke based on the arguments provided during the method call.
Example:
public class Calculator
{
public int Add(int a, int b)
{
return a + b;
}
public double Add(double a, double b)
{
return a + b;
}
}
What is method overriding?
Method overriding is a feature in C# that allows a derived class to provide its own implementation of a method that is already defined in the base class. It is used to achieve polymorphism and to specialize behavior in derived classes.
Example:
public class Shape
{
public virtual void Draw()
{
Console.WriteLine("Drawing a shape");
}
}
public class Circle : Shape
{
public override void Draw()
{
Console.WriteLine("Drawing a circle");
}
}
How do we use exception handling in C#?
Exception handling in C# is done using try-catch-finally blocks. The code that may raise an exception is placed inside the try block, and any potential exceptions are caught and handled in the catch block. The finally block is used to execute code that should always run, regardless of whether an exception occurs or not.
Example:
try
{
// Code that may raise an exception
}
catch (Exception ex)
{
// Handle the exception
}
finally
{
// Code that always executes
}
What are the blocks available in a try-catch in C#?
The blocks available in a try-catch statement in C# are:
- try: Contains the code that may raise an exception.
- catch: Catches and handles the exception.
- finally: Contains code that always executes, whether an exception occurs or not.
When does the catch block execute?
The catch block executes when an exception is thrown inside the try block that matches the type of the caught exception. It is responsible for catching and handling the exception.
Explain the difference between constant and static?
- Constants: A constant is a value that cannot be changed once it is assigned. It is declared using the `const` keyword and must be initialized at the time of declaration. Constants are resolved at compile-time.
- Static Variables: A static variable is associated with a class rather than an instance of the class. It is declared using the `static` keyword and retains its value throughout the program's execution. Static variables are shared among all instances of the class.
Example:
public class MyClass
{
public const int MyConstant = 10; // Constant
public static int MyStaticVariable = 5; // Static Variable
}
Tell me the difference between constant and readonly variables?
- Constants: Constants are compile-time constants and their values are known and fixed at compile-time. They are implicitly static and can only be of a value type or string.
- Readonly Variables: Readonly variables are runtime constants, and their values can be assigned at runtime. They are initialized either at the time of declaration or within the constructor. Readonly variables can be of any type, including reference types.
Example:
public class MyClass
{
public const int MyConstant = 10; // Constant
public readonly int MyReadonlyVariable; // Readonly Variable
public MyClass()
{
MyReadonlyVariable = 5;
}
}
What is an abstract class?
An abstract class is a class that cannot be instantiated and serves as a base for deriving other classes. It may contain abstract methods (without implementation) that must be overridden in derived classes. Abstract classes provide a way to define common behavior and enforce certain rules for subclasses.
When do we use the `async` and `await` keywords?
The `async` and `await` keywords are used in asynchronous programming in C#. `async` is used to declare a method as asynchronous, and `await` is used to asynchronously wait for the completion of a task. They are commonly used when performing time-consuming operations, such as network requests or file operations, without blocking the main execution thread.
Example:
public async Task GetDataAsync()
{
// Perform asynchronous operations
await DoSomethingAsync();
await DoAnotherTaskAsync();
}
Can you explain about garbage collection?
Garbage collection is an automatic memory management feature in .NET. It is responsible for reclaiming memory that is no longer in use by the application. The garbage collector identifies and collects objects that are no longer reachable, freeing up memory resources and improving performance. Developers do not need to manually deallocate memory for objects managed by the garbage collector.
Why are we using XAML?
XAML (eXtensible Application Markup Language) is used in WPF (Windows Presentation Foundation) for designing user interfaces and separating UI code from business logic. It provides a declarative way to define UI elements and their properties.
How many controls are there in WPF?
WPF offers a wide range of controls that can be used to build user interfaces. There are numerous controls available, including TextBox, Button, ComboBox, ListBox, Grid, etc.
Is it possible to create controls in code-behind in C#?
Yes, it is possible to create controls dynamically in the code-behind file using C#. For example, you can create a Button control and add it to a container like a Grid programmatically.
Button button = new Button();
button.Content = "Click me";
grid.Children.Add(button);
What are the major properties (cases) we are using in ListView?
Some of the major properties commonly used in a ListView control include ItemsSource (to bind a collection of data), ItemTemplate (to define the appearance of each item), SelectedItem (to get or set the currently selected item), and IsItemClickEnabled (to enable item click events).
What are the types of resources available?
In XAML, there are several types of resources available, including StaticResource (used for one-time resource lookup), DynamicResource (used for dynamic resource lookup), and ThemeResource (used for theme-based resource lookup).
How many types of styles are available in XAML?
In XAML, there are three types of styles available:
- Explicit Styles: These are defined with a specific x:Key and applied to elements explicitly using the StaticResource markup extension.
- Implicit Styles: These are defined without a key and are automatically applied to all elements of a certain type within a scope.
- Default Styles: These are predefined styles that are applied to all elements of a specific type by default.
We have a Label, what is the purpose of horizontal alignment and vertical alignment?
- The HorizontalAlignment property of a Label control determines how the content is horizontally aligned within the control. The options include Left, Center, Right, and Stretch.
- The VerticalAlignment property determines how the content is vertically aligned within the control. The options include Top, Center, Bottom, and Stretch.
What is the purpose of MVVM?
MVVM (Model-View-ViewModel) is a software architectural pattern used in WPF applications. It separates the concerns of the user interface (View), application data and behavior (ViewModel), and the underlying data model (Model). It promotes separation of concerns and facilitates testability and maintainability of the codebase.
What are the types of databases available in MVVM?
In MVVM, the type of database used depends on the specific requirements of the application. MVVM is an architectural pattern and is not limited to a specific database technology. Common databases used with MVVM include SQL databases (e.g., SQL Server, MySQL) and NoSQL databases (e.g., MongoDB, Firebase).
What are the things we hold in MVVM?
In MVVM, we have three main components:
- Model: It represents the data and business logic of the application.
- View: It defines the user interface and visual elements.
- ViewModel: It acts as an intermediary between the View and Model, providing data binding and commanding capabilities. The ViewModel holds data and exposes it to the View, as well as handles user interactions and updates the Model accordingly.
What are the types of binding mode?
The types of binding modes in WPF (Windows Presentation Foundation) are:
- OneWay: Updates the target property when the source property changes.
- TwoWay: Updates the source property when the target property changes and vice versa.
- OneTime: Updates the target property with the initial value from the source property but doesn't track subsequent changes.
When do we use OneTime binding mode?
OneTime binding mode is used when you want to initialize the target property with the value from the source property, but you don't need to track subsequent changes.
How to connect a view and view model in WPF?
In WPF, you can connect a view and view model by setting the `DataContext` property of the view to an instance of the corresponding view model. This can be done in XAML or code-behind. For example:
XAML:
<Window x:Class="MyApp.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:local="clr-namespace:MyApp"
Title="MainWindow">
<Window.DataContext>
<local:MainViewModel />
</Window.DataContext>
<!-- Rest of the XAML code -->
</Window>
What is the binding context?
The binding context refers to the object or data source to which a control is bound. It provides the properties or data that the control displays or interacts with.
Why do we use converters in XAML?
Converters in XAML are used to convert data from one format to another during the binding process. They allow you to perform custom logic to transform the data before it is displayed or assigned to a property.
Example of a converter:
Here's an example of a converter in WPF that converts a boolean value to a visibility value:
public class BooleanToVisibilityConverter : IValueConverter
{
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
bool isVisible = (bool)value;
return isVisible ? Visibility.Visible : Visibility.Collapsed;
}
public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
{
throw new NotImplementedException();
}
}
What is a custom control in XAML?
A custom control in XAML is a control that is created by deriving from an existing control or from the `Control` class. It allows you to define custom behaviors, properties, and styles for a specific control type.
How many types of layout panels are there in XAML?
There are several types of layout panels available in XAML, including:
- Grid
- StackPanel
- WrapPanel
- DockPanel
- Canvas
- UniformGrid
What is a trigger in WPF, and how many types of triggers are there?
In WPF, a trigger is a mechanism that allows you to change the appearance or behavior of a control based on certain conditions. There are mainly three types of triggers:
- Property Trigger
- Data Trigger
- Event Trigger
What is INotifyPropertyChanged?
INotifyPropertyChanged is an interface in C# that is used to notify clients (usually UI controls) that a property value has changed. It is commonly used in data binding scenarios to keep the UI in sync with the underlying data.
What is the difference between DBMS and RDBMS?
DBMS (Database Management System) refers to a system that manages databases, while RDBMS (Relational Database Management System) is a specific type of DBMS that organizes data into tables with relationships between them.
What is a primary key in a table?
A primary key is a unique identifier for a record in a table. It ensures that each row in the table is uniquely identifiable. In SQL, you can define a primary key using the `PRIMARY KEY` constraint.
What is a foreign key?
A foreign key is a column in a table that establishes a link or relationship with the primary key of another table. It is used to maintain referential integrity and enforce relationships between tables.
How do you join two tables?
In SQL, you can use the `JOIN` clause to combine rows from two or more tables based on a related column. Common types of joins include `INNER JOIN`, `LEFT JOIN`, `RIGHT JOIN`, and `FULL JOIN`.
Example:
SELECT * FROM table1 JOIN table2 ON table1.column = table2.column
When do we use the SELECT statement in SQL?
The SELECT statement is used to retrieve data from one or more tables in a database. It is commonly used to query and fetch specific data based on specified criteria.
Example:
SELECT * FROM table_name WHERE condition;
What is the syntax of creating a table?
The syntax for creating a table in SQL is as follows:
Example:
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
...
);
How to delete a row with student ID 5 from the Student table?
To delete a specific row from a table, you can use the `DELETE` statement with the `WHERE` clause.
Example:
DELETE FROM Student WHERE student_id = 5;
Which keyword is used to delete an entire table?
To delete an entire table, you can use the `DROP` statement followed by the table name.
Example:
DROP TABLE table_name;
What is the difference between DELETE and TRUNCATE?
The `DELETE` statement is used to delete specific rows from a table, while the `TRUNCATE` statement is used to remove all rows from a table, essentially resetting it.
What keyword is used to delete a single row?
The `DELETE` statement is used to delete a single row or multiple rows based on the specified condition.
Example:
DELETE FROM table_name WHERE condition;
What is a stored procedure and its use?
A stored procedure is a prepared SQL code that can be saved and reused. It allows you to encapsulate logic and execute complex database operations with parameters.
What is the syntax of creating a procedure?
The syntax for creating a stored procedure in SQL is as follows:
Example:
CREATE PROCEDURE procedure_name
AS
BEGIN
-- SQL statements here
END
What is a temporary table?
A temporary table is a table that exists temporarily in the database and is automatically dropped when the session or connection ends. It is useful for storing intermediate results during complex operations.
How do you execute a procedure in SQL?
You can execute a stored procedure in SQL using the `EXECUTE` or `EXEC` keyword followed by the procedure name.
Example:
EXEC procedure_name;
How to execute a procedure with parameters?
When executing a procedure with parameters, you need to pass the values for the parameters in the `EXECUTE` statement.
Example:
EXEC procedure_name @parameter1 = value1, @parameter2 = value2;
How to connect SQL Server with a WPF application?
To connect SQL Server with a WPF application, you can use the ADO.NET framework and provide the appropriate connection string to establish a connection to the database.
What properties are available in a connection string?
The connection string for SQL Server includes properties such as server name, database name, authentication mode, username, password, and additional connection options.
What are the possibilities of exceptions in SQL Server connectivity using ADO.NET?
Possible exceptions when connecting to SQL Server using ADO.NET include `SqlException` for errors related to SQL Server, `InvalidOperationException` for invalid operation errors, and `IOException` for input/output errors.
What things should you check before connecting SQL Server with a WPF application?
Before connecting SQL Server with a WPF application, you should ensure that the SQL Server is running, the necessary permissions are set for the database, and the connection string is correct.
If I am going to get data from SQL to a WPF application, do I need to check if the internet is connected or not? What is the basis?
No, checking the internet connection is not required when retrieving data from SQL Server to a WPF application. The communication happens over the local network within the SQL Server and the application.
How many types of queries are available?
In SQL, there are several types of queries including `SELECT` (retrieve data), `INSERT` (insert data), `UPDATE` (modify data), and `DELETE` (remove data).
What is the difference between the `<div>` and `<table>` tags in HTML?
The `<div>` tag is a block-level element used for grouping and styling content, while the `<table>` tag is used to display tabular data in rows and columns.
If I need to add a link in HTML, what tag should I use?
To add a link in HTML, you should use the `<a>` tag (anchor tag) along with the `href` attribute to specify the URL or destination.
Example:
<a href="https://example.com">Link Text</a>
How many types of CSS are available in HTML?
There are three types of CSS in HTML: inline CSS (using the `style` attribute), internal CSS (within the `<style>` tag in the `<head>` section), and external CSS (using a separate CSS file).
All the very best
)%20(2).png "Tech Mahindra C# and SQL Interview Questions for 2023")
