Add office photos
Engaged Employer

Chetu

3.3
based on 1.1k Reviews
Video summary
Filter interviews by

20+ Credent Infotech Interview Questions and Answers

Updated 21 Nov 2024
Popular Designations

Q1. What is the difference between delete and truncate?

Ans.

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

Add your answer

Q2. What is the significance of Sql joins in database management

Ans.

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

Add your answer

Q3. What is OOP’s Concept and how using in DotNet

Ans.

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

Add your answer

Q4. What is Mvc and what is the role in DotNet

Ans.

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

Add your answer
Discover Credent Infotech interview dos and don'ts from real experiences

Q5. What are the types of joins in Ms Sql

Ans.

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.

Add your answer

Q6. What is store procedure in Ms Sql

Ans.

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

Add your answer
Are these interview questions helpful?

Q7. difference between union and union all.

Ans.

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

Add your answer

Q8. Primary key and foreign key difference.

Ans.

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

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q9. What are the sealed classes?

Ans.

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() }

Add your answer

Q10. what is interface ?

Ans.

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

Add your answer

Q11. abstract class with example

Ans.

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(); }

Add your answer

Q12. Java script difference b/w java script and jQuery anonymous function in java

Ans.

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.

Add your answer

Q13. Consept of this use and benifit?

Ans.

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.

View 1 answer

Q14. C# reverse string program without using in build feature

Ans.

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

Add your answer

Q15. Deference between foreach and map ?

Ans.

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

Add your answer

Q16. What is inheritance?

Ans.

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

Add your answer

Q17. Why use routing?

Ans.

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.

Add your answer

Q18. Described Thunk and saga ?

Ans.

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

Add your answer

Q19. Constructor type casting its types

Ans.

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;

Add your answer

Q20. Life cycle method?

Ans.

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

Add your answer

Q21. Remove space from given dataframe and concat the first and last name and add new column to dataframe.

Ans.

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.

Add your answer

Q22. Create simple ANN network using Tensorflow.

Ans.

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.

Add your answer

Q23. Create the virtual environment using cmd.

Add your answer

Q24. Can you draft a notice based on a current situation provided to you?

Ans.

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

Add your answer

Q25. Build xg bost model(actaul code)

Ans.

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

Add your answer

Q26. What is oops. What is .net core What is Mssql. What is joins. What is union. What is procedures

Ans.

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

Add your answer

Q27. What is Dispatcher servlet

Ans.

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

Add your answer

Q28. All oops concept

Ans.

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.

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Credent Infotech

based on 10 interviews
Interview experience
4.1
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

4.0
 • 376 Interview Questions
4.1
 • 279 Interview Questions
3.9
 • 157 Interview Questions
4.1
 • 148 Interview Questions
3.9
 • 140 Interview Questions
3.8
 • 135 Interview Questions
View all
Top Chetu Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter