Chetu Developer Associate Interview Questions and Answers

Q1. Basics of oops, .net framework and .net core
Add your answer
Q2. Sql query for student department id
Ans. 
SQL query to retrieve student department id.
• Use SELECT statement to retrieve data

• Specify the columns to be selected, including the department id column

• Specify the table where the student data is stored

• Use WHERE clause to filter the results based on student information
Answered by AI
Add your answer
Q3. Solid principles and design patterns
Add your answer

Q1. Asked to code palindrome
Add your answer
Q2. Code duplicate string from main string and get index of sub string
Ans. 
Code to find index of sub string in main string and duplicate the sub string
• Use a loop to iterate through the main string and check for the sub string

• If sub string is found, duplicate it and store the index

• Return the index of the duplicated sub string
Answered by AI
Add your answer

Q1. Manager asked me to code the count index of substring and sum of substring
Add your answer
Q2. Questions as HR informed, it was worst and all interviews were scheduled at night time.he was more technical than the second round team lead instead of asking manager round
Add your answer

1st round is aptitude and pesudocode

Q1. Mostly python questions
Add your answer
Q2. List questions and basic to mediumprogram
Add your answer

In first round 4 coding question like 1 dsa 2 database and one is api and question is very simple . coding round was conducted in hackerrank

Q1. DSA QUESTION LIKE TREE AND GRAPH
Add your answer
Q2. DP AND SORTING APPROACH
Add your answer

Again same but dsa question and oops concept in deep level

Q1. Rest Apis questions
Add your answer

Q1. Core java and OOPS and LLD
Add your answer

Q1. What is Common Term Expression?
Add your answer
Q2. What is Overloading and Overriding?
Ans. 
Overloading is having multiple methods in the same class with the same name but different parameters. Overriding is implementing a method in a subclass that is already defined in the parent class.
• Overloading allows a class to have multiple methods with the same name but different parameters.

• Overriding is when a subclass provides a specific implementation of a method that is already defined in its parent class.

• Example o...read more
Answered by AI
Add your answer
Q3. Examples of Server side session Management? Types of Session State?
Ans. 
Server side session management involves storing user data on the server to maintain state. Types include in-process, out-of-process, and database.
• In-process session state: Data stored in memory on the same server as the application.

• Out-of-process session state: Data stored in a separate server or service, such as a state server or Redis cache.

• Database session state: Data stored in a database, such as SQL Server or MySQ...read more
Answered by AI
Add your answer
Q4. How to Debug Stored Procedures?
Ans. 
Debugging stored procedures involves using tools like SQL Server Management Studio, setting breakpoints, and analyzing query execution.
• Use SQL Server Management Studio to debug stored procedures

• Set breakpoints in the stored procedure code to pause execution at specific points

• Analyze query execution using tools like SQL Profiler to identify issues

• Use PRINT or SELECT statements to output intermediate results for debuggin...read more
Answered by AI
Add your answer
Q5. What is Compile time binding and Runtime Binding?
Ans. 
Compile time binding occurs during compilation while runtime binding occurs during execution.
• Compile time binding is also known as early binding, where the method to be called is determined at compile time based on the type of the object.

• Runtime binding is also known as late binding, where the method to be called is determined at runtime based on the actual type of the object.

• Compile time binding is faster as it is don...read more
Answered by AI
Add your answer

Q1. Something based on hashet
Add your answer
Q2. Same with this too
Add your answer

Basic questions were given..bar graphs,pie charts

Q1. Security related scenarios.
Add your answer
Q2. Integration types and usecases.
Ans. 
Integration types include point-to-point, middleware, and API-based integrations for connecting different systems.
• Point-to-point integration involves direct connections between two systems.

• Middleware integration uses a middle layer to connect multiple systems.

• API-based integration utilizes APIs to connect systems and exchange data.

• Examples: Salesforce to SAP integration, Salesforce to MailChimp integration, Salesforce
Answered by AI
Add your answer

Q1. About project of previous company
Add your answer
Q2. Check palindrome and odd of given number
Add your answer