Chetu
20+ Credent Infotech Interview Questions and Answers
Q1. What is the difference between delete and truncate?
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
Q2. What is the significance of Sql joins in database management
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
Q3. What is OOP’s Concept and how using in DotNet
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
Q4. What is Mvc and what is the role in DotNet
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
Q5. What are the types of joins in Ms Sql
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.
Q6. What is store procedure in Ms Sql
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
Q7. difference between union and union all.
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
Q8. Primary key and foreign key difference.
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
Q9. What are the sealed classes?
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() }
Q10. what is interface ?
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
Q11. abstract class with example
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(); }
Q12. Java script difference b/w java script and jQuery anonymous function in java
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.
Q13. Consept of this use and benifit?
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.
Q14. C# reverse string program without using in build feature
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
Q15. Deference between foreach and map ?
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
Q16. What is inheritance?
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
Q17. Why use routing?
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.
Q18. Described Thunk and saga ?
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
Q19. Constructor type casting its types
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;
Q20. Life cycle method?
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
Q21. Remove space from given dataframe and concat the first and last name and add new column to dataframe.
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.
Q22. Create simple ANN network using Tensorflow.
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.
Q23. Create the virtual environment using cmd.
Q24. Can you draft a notice based on a current situation provided to you?
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
Q25. Build xg bost model(actaul code)
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
Q26. What is oops. What is .net core What is Mssql. What is joins. What is union. What is procedures
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
Q27. What is Dispatcher servlet
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
Q28. All oops concept
Object-oriented programming concepts like inheritance, encapsulation, polymorphism, and abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorphism: Ability to present the same interface for different data types.
Abstraction: Hiding the complex implementation details and showing only the necessary features.
Top HR Questions asked in Credent Infotech
Interview Process at Credent Infotech
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month