20+ Chetu Interview Questions and Answers for Freshers

Delete removes specific rows while truncate removes all rows from a table.

• Delete is a DML command while truncate is a DDL command.

• Delete is slower than truncate as it logs each row deletion while truncate only logs the deallocation of data pages.

• Delete can be rolled back while truncate cannot be rolled back.

• Delete can have a WHERE clause to specify which rows to delete while truncate removes all rows.

• Delete does not reset the identity of the table while truncate resets the id...read more

Sql joins are used to combine rows from two or more tables based on a related column between them.

• Joins are essential for retrieving data from multiple tables in a database

• Types of joins include inner join, outer join, left join, and right join

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

OOP stands for Object-Oriented Programming, a programming paradigm based on the concept of objects.

• OOP focuses on creating objects that contain data and methods to manipulate that data.

• In DotNet, OOP is implemented using classes and objects. Classes define the blueprint for objects, while objects are instances of classes.

• Encapsulation, inheritance, and polymorphism are key principles of OOP that are utilized in DotNet development.

• Example: In DotNet, you can create a class 'Ca...read more

MVC stands for Model-View-Controller. It is a design pattern used in DotNet for separating concerns in an application.

• Model represents the data and business logic of the application.

• View is responsible for displaying the user interface.

• Controller handles user input and updates the model and view accordingly.

• MVC helps in achieving separation of concerns, making the code more organized and maintainable.

• Example: In a DotNet MVC application, the model could be a class representin...read more

Types of joins in Ms Sql include inner join, left join, right join, and full outer join.

• Inner join: Returns rows when there is at least one match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in one of the tables.

A stored procedure in MS SQL is a precompiled collection of SQL statements that can be saved and reused.

• Stored procedures can improve performance by reducing the amount of data sent over the network.

• They can be used to encapsulate business logic and provide a layer of security by controlling access to data.

• Stored procedures can accept input parameters and return output parameters or result sets.

• Example: CREATE PROCEDURE GetEmployeeDetails AS SELECT * FROM Employees WHERE Depa...read more

Union combines and removes duplicates while Union All combines all rows.

• Union is used to combine the result sets of two or more SELECT statements into a single result set with no duplicates.

• Union All is used to combine the result sets of two or more SELECT statements into a single result set with all rows.

• Union is slower than Union All because it has to remove duplicates.

• Union requires that the number and order of columns in all SELECT statements be the same.

• Union All does no...read more

Primary key uniquely identifies a record while foreign key refers to a primary key in another table.

• Primary key is a column or set of columns that uniquely identifies a record in a table

• Foreign key is a column or set of columns that refers to a primary key in another table

• Primary key cannot have null values while foreign key can have null values

• Primary key is used to enforce data integrity while foreign key is used to establish relationships between tables

Sealed classes are classes that cannot be inherited and are used to restrict class hierarchy.

• Sealed classes are declared using the 'sealed' keyword.

• They can have abstract members but cannot be instantiated.

• They are useful in creating exhaustive when expressions.

• They restrict the inheritance hierarchy and prevent unintended subclassing.

• Example: sealed class Shape { abstract fun draw() }

An interface is a contract that specifies the methods and properties that a class must implement.

• An interface defines a set of methods and properties that a class must implement

• Interfaces are used to achieve abstraction and polymorphism

• Interfaces can be used to define contracts between different parts of a system

• A class can implement multiple interfaces

• Example: The IDisposable interface in C# is used to ensure that an object releases any unmanaged resources it is using when i...read more

Abstract class is a class that cannot be instantiated and can only be inherited by other classes.

• An abstract class can have abstract and non-abstract methods.

• Abstract methods have no implementation and must be implemented by the child class.

• Non-abstract methods can have implementation and can be inherited by the child class.

• An abstract class can have constructors and variables.

• Example: abstract class Animal { abstract void makeSound(); }

JavaScript anonymous functions in jQuery are used to create functions without a name, while JavaScript functions are named functions.

• JavaScript functions are named and can be reused multiple times.

• jQuery anonymous functions are used for event handling and callbacks.

• JavaScript functions can be defined using the function keyword, while jQuery anonymous functions are created using the $ symbol.

The question is unclear and lacks context.

• Please provide more information or rephrase the question.

• Without context, it is difficult to understand what is being asked.

• It is important to communicate clearly in technical interviews.

Reverse a string in C# without using built-in features

• Create a character array from the input string

• Use two pointers to swap characters at the beginning and end of the array

• Continue swapping until the pointers meet in the middle

foreach is used to iterate over an array and perform an action on each element, while map creates a new array by applying a function to each element of an existing array.

• foreach does not return a new array, while map does

• foreach can only perform an action on each element, while map can transform each element

• foreach is useful for performing side effects, while map is useful for creating a new array with transformed elements

Inheritance is a mechanism in object-oriented programming where a new class is created by inheriting properties of an existing class.

• Inheritance allows code reusability and promotes code organization.

• The existing class is called the parent or superclass, and the new class is called the child or subclass.

• The child class inherits all the properties and methods of the parent class and can also add new properties and methods.

• For example, a class 'Animal' can be a parent class, an...read more

Routing is used to direct network traffic efficiently and securely.

• Routing helps to find the best path for data packets to travel.

• It enables load balancing and fault tolerance.

• Routing protocols like OSPF, BGP, and EIGRP are used to manage routing tables.

• Routing can be static or dynamic depending on the network requirements.

Thunk and saga are middleware libraries used in Redux for handling asynchronous actions.

• Thunk is a function that wraps an expression to delay its evaluation.

• Saga is a generator function that allows for complex control flow and error handling.

• Thunk is simpler and easier to use, while Saga is more powerful and flexible.

• Example: Thunk can be used to dispatch an action after an API call is complete.

• Example: Saga can be used to handle multiple API calls and dispatch actions based ...read more

Constructor type casting involves converting one data type to another in a constructor.

• Constructor type casting is used to convert one data type to another in a constructor.

• It can be done implicitly or explicitly depending on the languages.

• For example, in Java, you can explicitly cast a data type in a constructor like this: int num = (int) doubleNum;

Life cycle methods are functions that are called at different stages of a component's life cycle in React.

• There are three categories of life cycle methods: mounting, updating, and unmounting.

• Mounting methods are called when a component is being created and inserted into the DOM.

• Updating methods are called when a component's state or props change.

• Unmounting methods are called when a component is being removed from the DOM.

• Examples of life cycle methods include componentDidMoun...read more

Remove spaces from dataframe, concatenate first and last name, and add new column.

• Use str.replace() to remove spaces from dataframe columns.

• Use str.cat() to concatenate first and last name.

• Use df['new_column'] = concatenated_names to add new column.

Creating a simple Artificial Neural Network (ANN) using Tensorflow.

• Import the necessary libraries like tensorflow and numpy.

• Define the input layer, hidden layers, and output layer.

• Compile the model with appropriate loss function and optimizer.

• Train the model using training data.

• Evaluate the model using test data.

Yes, I can draft a notice based on a current situation provided to me.

• I would need to understand the current situation and the purpose of the notice

• I would gather all relevant information and ensure accuracy

• I would use clear and concise language and follow any applicable legal requirements

• I would review and revise the notice as necessary

• Examples: notice of termination, notice of breach of contract, notice of change in policy

Building an xgboost model involves training a gradient boosting algorithm for classification or regression tasks.

• Install xgboost library using pip install xgboost

• Import necessary libraries like xgboost, numpy, and pandas

• Prepare the data by splitting into training and testing sets

• Instantiate an xgboost classifier or regressor object

• Fit the model on the training data using the fit method

• Make predictions on the test data using the predict method

Answers to common technical questions asked in a .NET Software Developer interview.

• OOPs stands for Object-Oriented Programming, a programming paradigm that uses objects to represent real-world entities.

• .NET Core is a cross-platform, open-source framework for building modern applications.

• MS SQL is a relational database management system used to store and retrieve data.

• Joins are used to combine data from two or more tables based on a related column.

• Union is used to combine the ...read more

Dispatcher servlet is the front controller of Spring MVC framework.

• It receives all incoming requests and delegates them to appropriate handlers.

• It uses HandlerMapping to map requests to appropriate handlers.

• It uses HandlerAdapter to invoke the appropriate handler method.

• It uses ViewResolver to resolve the view for the response.

• It is configured in web.xml or through Java configuration.

• Example: DispatcherServlet dispatcherServlet = new DispatcherServlet(context);

• Example: org.sp...read more