HCL Infosystems System Engineer Interview Questions and Answers

There were a total of seven sections: verbal ability, logical reasoning, arithmetic problems, verbal reasoning, puzzles, pseudocodes, and essay writing, with each section having its own cutoff scores.

Q1. What is the SQL query to retrieve the person with the highest salary?
Add your answer
Q2. Can you describe the projects you have worked on?
Add your answer
Q3. Write a query to merge 2 tables?
Add your answer
Q4. Tell me about the internship that you have done?
Add your answer
Q5. Behavioural questions
Add your answer

Q1. What is hash technology?
Ans. 
Hash technology is a method used to convert data into a fixed-size string of characters, typically used for data security and integrity.
• Hash technology uses algorithms to generate a unique fixed-size string of characters from input data.

• It is commonly used for data security, password storage, digital signatures, and data integrity verification.

• Examples of hash algorithms include MD5, SHA-1, and SHA-256.
Answered by AI
Add your answer
Q2. What is block chain?
Ans. 
Blockchain is a decentralized, distributed ledger technology used to securely record transactions across multiple computers.
• Decentralized database

• Consensus mechanism

• Immutable record of transactions

• Cryptographic security

• Smart contracts

• Examples: Bitcoin, Ethereum
Answered by AI
Add your answer
Q3. What is DML?
Ans. 
DML stands for Data Manipulation Language, used to manage data in a database.
• DML is a subset of SQL (Structured Query Language) used to insert, update, delete, and retrieve data in a database.

• Examples of DML commands include INSERT, UPDATE, DELETE, and SELECT.

• DML is essential for managing and manipulating data within a database system.
Answered by AI
Add your answer
Q4. Convert binay to decimal and viceversa.
Ans. 
Binary to decimal conversion involves multiplying each digit by 2 raised to the power of its position.
• To convert binary to decimal, start from the rightmost digit and multiply each digit by 2 raised to the power of its position.

• Add all the results together to get the decimal equivalent.

• For example, to convert binary 1011 to decimal: 1*2^3 + 0*2^2 + 1*2^1 + 1*2^0 = 11.
Answered by AI
Add your answer
Q5. Find max number in array?
Ans. 
Iterate through array and compare each element to find the maximum number.
• Iterate through the array using a loop.

• Compare each element to a variable storing the current maximum number.

• Update the variable if a larger number is found.

• Return the maximum number at the end.
Answered by AI
Add your answer
Q6. Write basic html , for inserting image and create table.
Ans. 
Basic HTML code for inserting image and creating a table
• Use <img> tag to insert an image with src attribute

• Use <table>, <tr>, <td> tags to create a table structure

• Specify image source and table content within respective tags
Answered by AI
Add your answer

Its very easy
Basic maths questions learned up to 10
Basic Apptitude questions

Q1. Tell me about your self Hi My name is Vikram Adithya I am an hard working and passionate engineering student currently perceiveing in gokaraju rangaraju institute of engineering and technology .I stay with...read more
Add your answer
Q2. Intervier asked about what kind of problems did you solved in leetcode? I said palindrome factorial matrix multiplication etc . Intervier said every one can solve this
Add your answer
Q3. He asked me about my project role i said I have done documentation in my project he said every one can do that
Add your answer
Q4. He asked me to write project code
Add your answer
Q5. He asked me any questions
Add your answer

Q1. All Linux commands and options
Add your answer
Q2. How to configure NFS, NTP,DNS servers
Add your answer

Q1. Linux Patch Management
Add your answer
Q2. Linux servers updates
Add your answer

Q1. Why you want to join TCS
Add your answer

Duration was 1.5 hrs. Questions were asked on topics like aptitude, reasoning , puzzle solving and verbal ability. Also a topic was given on which candidates were expected to write an essay. Overall the difficulty level was easy to medium.

Q1. Introduce Yourself
Add your answer
Q2. Explain about your projects (mentioned in resume)
Add your answer
Q3. Have you got any certifications on cloud technologies?
Ans. 
Yes, I have certifications in AWS and Azure cloud technologies.
• Certified AWS Solutions Architect

• Microsoft Certified: Azure Administrator Associate

• Completed training courses on Google Cloud Platform
Answered by AI
Add your answer
Q4. What do you do in your free time?
Add your answer
Q5. Explain about Encapsulation (OOPS concept)
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for data hiding, which prevents outside code from directly accessing an object's internal state.

• Access to the data is typically controlled through public methods (getters and setters) defined in the cl...read more
Answered by AI
Add your answer
Q6. Tell about your previous intern/work experience if any
Add your answer
Q7. What is the one thing that you can say about you for which haven't been noticed by others and credited?
Add your answer
Q8. Questions about schooling, CGPA in college
Add your answer

It is very easy, questions on all topics are covered.

Q1. What is abstraction and encapsulation?
Ans. 
Abstraction is hiding unnecessary details while encapsulation is bundling data and methods together.
• Abstraction focuses on showing only essential features of an object while hiding unnecessary details.

• Encapsulation involves bundling the data (attributes) and methods (functions) that operate on the data into a single unit.

• Abstraction allows for easier understanding and management of complex systems.

• Encapsulation helps i...read more
Answered by AI
Add your answer
Q2. Write a sql query to update a record
Ans. 
SQL query to update a record in a database table
• Use the UPDATE statement followed by the table name

• Set the column(s) to be updated using SET keyword

• Specify the new values for the column(s) to be updated

• Use WHERE clause to specify the condition for which record to update
Answered by AI
Add your answer

Q1. Will you able to relocate?
Ans. 
Yes, I am willing to relocate for the right opportunity.
• I am open to relocating for the right job opportunity

• I have relocated for previous positions and am comfortable with the process

• I understand the importance of being flexible and adaptable in the field of engineering
Answered by AI
Add your answer
Q2. Why Infosys?
Ans. 
Infosys is a global leader in technology services and consulting, known for its innovative solutions and commitment to excellence.
• Infosys has a strong reputation for delivering high-quality technology solutions to clients worldwide.

• The company offers a wide range of opportunities for professional growth and development.

• Infosys has a culture of innovation and collaboration, which aligns with my own values and career goa
Answered by AI
Add your answer