HCLTech Interview Questions, Process, and Tips

Q1. Difference between join and lookup
Ans. 
Join is used to combine rows from two or more tables based on a related column, while lookup is used to retrieve data from a reference table based on a matching key.
• Join combines rows from multiple tables based on a related column

• Lookup retrieves data from a reference table based on a matching key

• Join can result in duplicate rows if there are multiple matches, while lookup returns only the first matching row

• Join is use...read more
Answered by AI
Add your answer
Q2. Diffrence between fact table and dimension table
Ans. 
Fact table contains quantitative data and measures, while dimension table contains descriptive attributes.
• Fact table contains numerical data that can be aggregated (e.g. sales revenue, quantity sold)

• Dimension table contains descriptive attributes for analysis (e.g. product name, customer details)

• Fact table is typically normalized, while dimension table is denormalized for faster queries

• Fact table is usually larger in s
Answered by AI
Add your answer
Q3. Sed command to display last before line
Ans. 
Use sed command to display the line before a specific pattern
• Use 'sed -n '/pattern/{g;1!p;};h' file.txt' to display the line before the pattern

• Replace 'pattern' with the specific pattern you are looking for

• This command will display the line before the pattern in the file
Answered by AI
Add your answer

Java program to sort an array in ascending order and find fourth highest number in an array without using any built in methods

Q1. Tell me about yourself, project, goals
Ans. 
I am a recent graduate engineer with experience in project management and a passion for sustainable design. My goal is to work on innovative projects that positively impact the environment.
• Graduated with a degree in Engineering

• Managed a project to design a sustainable building

• Passionate about environmental impact and sustainability

• Goal is to work on innovative projects in the engineering field
Answered by AI
Add your answer
Q2. Strength weakness
Add your answer

Q1. Find the third largest element in array.
Ans. 
To find the third largest element in an array, we can sort the array in descending order and return the element at index 2.
• Sort the array in descending order.

• Return the element at index 2, which will be the third largest element.
Answered by AI
Add your answer
Q2. String format abc to a|b|c
Ans. 
Use String's replaceAll method to replace all occurrences of ' ' with '|'.
• Use String's replaceAll method with regex to replace all spaces with '|'.

• Example: String str = 'a b c'; str = str.replaceAll(' ', '|');
Answered by AI
Add your answer

Q1. What is you job profile and day to day activities
Ans. 
As a Network Engineer, my job involves designing, implementing, and maintaining computer networks.
• Designing network configurations and architecture

• Installing and configuring network equipment

• Monitoring network performance and troubleshooting issues

• Implementing security measures to protect the network

• Collaborating with other IT professionals to ensure network functionality

• Documenting network configurations and changes
Answered by AI
Add your answer
Q2. OSPF and switching questions
Add your answer

Q1. BGP, OSPF question
Add your answer
Q2. RSTP Ethechannel
Add your answer

Q1. Current salary and location
Add your answer
Q2. Joining date and experience
Add your answer

Q1. Calculate avg value and standard deviation from given data
Ans. 
Calculate avg value and standard deviation from given data
• Calculate the average value by summing all data points and dividing by the total number of data points

• Calculate the standard deviation by finding the square root of the average of the squared differences between each data point and the mean

• Example: Data points - 5, 7, 9, 11. Average = (5+7+9+11)/4 = 8. Standard deviation = sqrt(((5-8)^2 + (7-8)^2 + (9-8)^2 + (11
Answered by AI
Add your answer
Q2. From given graph answer below questions
Add your answer