ITC Infotech Interview Questions and Answers

First, test and then pass the next.

I did not have a coding test, but the next round included a coding test.

Two were passed, and the next round was conducted on the assignment.

Assignment: right or wrong case study on the assignment.

The main focus is on group discussion.

Q1. Why does the company conduct coding tests?
Ans. 
Coding tests help assess candidates' technical skills and problem-solving abilities.
• Coding tests help evaluate candidates' ability to write efficient and clean code.

• They assess problem-solving skills and logical thinking.

• Coding tests ensure that candidates have the necessary technical skills for the job.

• They help identify candidates who can work well under pressure and meet deadlines.
Answered by AI
Add your answer
Q2. Interview was good questions asking them
Add your answer
Q3. What was tha other option
Ans. 
The other option was to work as a customer service representative.
• Customer service representative role involves handling customer inquiries and resolving issues.

• Requires good communication skills and ability to remain calm under pressure.

• Examples: answering phone calls, responding to emails, assisting customers with product information.
Answered by AI
Add your answer
Q4. First all company was chose a member skills analyse them
Add your answer
Q5. A person was any problem solve them
Add your answer
Q6. What are you strength and weakness as a telecaler
Ans. 
My strength as a telecaller is my excellent communication skills and ability to build rapport with customers. My weakness is sometimes I can be too detail-oriented, which may slow down my call volume.
• Strength: Excellent communication skills

• Strength: Ability to build rapport with customers

• Weakness: Detail-oriented, which may slow down call volume
Answered by AI
Add your answer
Q7. Company has problems how could you motivate the manager
Ans. 
Motivate the manager by addressing the company's problems and offering support and solutions.
• Listen to the manager's concerns and show empathy

• Offer constructive feedback and solutions to address the problems

• Provide resources and support to help the manager overcome challenges

• Recognize and appreciate the manager's efforts and achievements

• Encourage open communication and collaboration within the team
Answered by AI
Add your answer

Q1. Each question answering and group discussion aptitude test pass assignment was response was good
Add your answer

Q1. Hr job was correct a person are rong are right choose them
Add your answer

One coding test happen

Q1. Java questions, spring boot framework questions
Add your answer
Q2. DSA using stream api
Ans. 
Using stream API for Data Structures and Algorithms
• Stream API in Java can be used to perform operations on collections like filtering, mapping, reducing, etc.

• It can be used for implementing various data structures and algorithms efficiently.

• For example, you can use stream API to find the sum of all elements in an array or filter out even numbers from a list.
Answered by AI
Add your answer

Q1. Java questions and spring boot questions
Add your answer
Q2. One program using stream api
Ans. 
Using stream API to filter a list of numbers and find the sum of even numbers
• Use Stream.filter() to filter out even numbers

• Use Stream.mapToInt() to convert stream to IntStream

• Use IntStream.sum() to find the sum of even numbers
Answered by AI
Add your answer

Q1. Projects and scenario based questions
Add your answer
Q2. Targets and logical abilities
Add your answer
Q3. Work related test paper
Add your answer

Q1. Data structures question
Add your answer
Q2. Elaborate explanation of past projects
Add your answer

Q1. How do you optimize Stored procedure
Ans. 
Optimizing stored procedures involves using proper indexing, reducing unnecessary loops, and minimizing database calls.
• Use proper indexing on columns used in WHERE clauses to improve query performance

• Avoid using cursors and loops whenever possible, as they can be inefficient

• Minimize the number of database calls by combining multiple queries into a single query or using temporary tables

• Consider using bulk processing tec...read more
Answered by AI
Add your answer
Q2. How do you optimize SQL query
Ans. 
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Avoid unnecessary joins by using EXISTS or IN clauses instead

• Optimize query structure by using appropriate join types and conditions
Answered by AI
Add your answer
Q3. What is use of returning clause
Ans. 
Returning clause is used to return a value from a function or procedure in PL/SQL.
• Used to return a single value from a function or procedure

• Can be used to return multiple values using OUT parameters

• Helps in passing values back to the calling program
Answered by AI
View 1 more answer
Q4. Disadvantages of triggers
Ans. 
Triggers can lead to performance issues, complexity, and potential for unintended consequences.
• Triggers can make code harder to debug and maintain

• They can lead to cascading effects if not carefully implemented

• Performance can be impacted if triggers are not optimized

• Triggers can introduce dependencies between different parts of the codebase
Answered by AI
Add your answer

Q1. Java program to split alpha-numeric values without using the split method
Ans. 
Split alpha-numeric values in Java without using split method
• Iterate through each character in the input string

• Check if the character is a digit or a letter using Character.isDigit() and Character.isLetter() methods

• Create separate strings for digits and letters and store them in an array
Answered by AI
Add your answer
Q2. SQL query to add a new column to a table and the column value should have a default value and never be null
Ans. 
Use ALTER TABLE statement to add a new column with a default value and set it to NOT NULL
• Use ALTER TABLE table_name ADD column_name data_type DEFAULT default_value NOT NULL;

• Example: ALTER TABLE employees ADD hire_date DATE DEFAULT '2022-01-01' NOT NULL;
Answered by AI
Add your answer