i
HCLTech
Filter interviews by
I applied via Company Website and was interviewed before Dec 2023. There was 1 interview round.
Oracle Applications are a suite of business applications software that help organizations manage their business processes.
Oracle Applications include modules for customer relationship management (CRM), enterprise resource planning (ERP), supply chain management (SCM), and more.
They are designed to automate and streamline business processes, improve efficiency, and provide real-time insights.
Examples of Oracle Applicati...
Value sets are a collection of related values that can be used to define a set of acceptable values for a field or parameter.
Value sets help ensure data consistency and accuracy by restricting the possible values that can be entered.
They can be used in database fields, dropdown lists, or parameters in programming languages.
For example, a value set for a 'gender' field may include values like 'Male', 'Female', and 'Othe
An index in PL/SQL is a database object that improves performance by allowing faster retrieval of data from tables.
Indexes are created on columns in a table to speed up the retrieval of rows based on the values in those columns.
They work similar to an index in a book, allowing the database to quickly locate the rows that match a certain criteria.
Indexes can significantly reduce the time it takes to retrieve data, espec...
Different types of joins in PL/SQL include inner join, outer join (left, right, full), cross join, and self join.
Inner join: Returns rows when there is at least one match in both tables.
Outer join: Returns all rows from one table and only matching rows from the other table (left, right, full).
Cross join: Returns the Cartesian product of the two tables.
Self join: Joins a table to itself.
Functions in PL/SQL are named blocks of code that can accept parameters, perform a task, and return a value.
Functions are created using the CREATE FUNCTION statement.
Functions can accept input parameters and return a single value.
Functions can be called from SQL statements or other PL/SQL blocks.
Functions can be used to encapsulate reusable logic and improve code readability.
Example: CREATE FUNCTION calculate_area(leng...
I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.
I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.
I applied via Naukri.com and was interviewed before Oct 2019. There were 3 interview rounds.
I applied via Referral and was interviewed before Oct 2020. There were 3 interview rounds.
I applied via Company Website and was interviewed before Mar 2021. There were 3 interview rounds.
Java assesment.
I applied via tcs and was interviewed before Jun 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Jul 2020. There were 3 interview rounds.
I appeared for an interview before Nov 2020.
Round duration - 90 minutes
Round difficulty - Medium
Timing was around 10am
It was quite a normal online examination kind of environment
People from the company were there to invigilate
All were quite nice and helpful in case the exam got stuck
An alien dropped its dictionary while visiting Earth. The Ninja wants to determine the order of characters used in the alien language, based on the given list of wor...
Determine the order of characters in an alien language based on a list of words.
Create a graph data structure to represent the relationships between characters in the words.
Perform a topological sort on the graph to find the order of characters.
Return the smallest lexicographical order of characters as the result.
Given an array of integers arr
of size N
and an integer K
, determine if there are any duplicate elements within a distance of K
from each other in the array. Return "true...
Check if there are any duplicate elements within a distance of K from each other in the array.
Iterate through the array and keep track of the indices of elements using a hashmap.
For each element, check if it already exists in the hashmap within distance K.
Return true if a duplicate is found within distance K, otherwise return false.
Round duration - 30 minutes
Round difficulty - Medium
Timing was 2pm when it started
Interviewer was polite
Ninja enjoys working with numbers, and Alice challenges him to find the Kth largest value from a given list of numbers.
The first line contains an integer 'T...
The task is to find the Kth largest element in a given list of numbers for each test case.
Read the number of test cases 'T'
For each test case, read the number of elements 'N' and the Kth largest number to find 'K'
Sort the array in descending order and output the Kth element
Round duration - 20 minutes
Round difficulty - Easy
Timing was 9 am onwards
Interviewer was good enough
Tip 1 : Focus on specialization of any one skill and keep a basic knowledge of all the skills you mention in your resume
Tip 2 : Gain confidence in presenting yourself by practicing well before
Tip 3 : Gain a basic knowledge of the company you go for selection
Tip 1 : Resume should be simple and precise but pretty smart to cover your skills
Tip 2 : Mention what you really know,no false things
I appeared for an interview before Dec 2020.
Round duration - 60 Minutes
Round difficulty - Easy
This round consisted of 1 question from DSA with easy level of difficulty and then the rest of the questions were asked from DBMS and SQL.
Find the number of trailing zeroes in the factorial of a given number N
.
The first line contains an integer T
representing the number of test cases.
Each of the...
Count the number of trailing zeros in the factorial of a given number N.
Iterate through each test case and calculate the factorial of N.
Count the number of trailing zeros by dividing the factorial by 10 until the remainder is not 0.
Return the count of trailing zeros for each test case.
ACID properties in DBMS ensure data integrity and consistency.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that all operations in a transaction are completed successfully or none at all.
Consistency ensures that the database remains in a valid state before and after the transaction.
Isolation ensures that multiple transactions can run concurrently without affecting each other.
Durabi...
Normalization is organizing data in a database to reduce redundancy and improve data integrity. Denormalization is adding redundant data to improve read performance.
Normalization is the process of organizing data in a database to reduce redundancy and dependency by dividing the data into multiple tables and defining relationships between them.
Denormalization is the process of adding redundant data to one or more tables...
Use the mysqldump command to take a backup of a table in MySQL.
Use the mysqldump command followed by the database name and table name to take a backup of a specific table.
Specify the username and password for the MySQL database using the -u and -p flags.
Redirect the output of the mysqldump command to a file to save the backup.
Round duration - 60 Minutes
Round difficulty - Medium
This round had questions revolving around Java and Selenium. Core concpets of Selenium were very frequent in
this interview.
JIT compiler stands for Just-In-Time compiler, which compiles code during runtime instead of ahead of time.
JIT compiler converts bytecode into machine code on-the-fly
Improves performance by optimizing frequently executed code
Examples include Java HotSpot, .NET CLR
Packages in Java help organize and manage classes and interfaces, provide access control, and prevent naming conflicts.
Organize classes and interfaces into a single unit for better maintainability
Provide access control by using access modifiers like public, private, protected, and default
Prevent naming conflicts by using unique package names
Facilitate modular programming and code reusability
Assert commands in Selenium are used to verify the expected result of a test case, while verify commands are used to check for the presence of an element without halting the test execution.
Assert commands halt the test execution if the verification fails, while verify commands continue with the test execution even if the verification fails.
Assert commands are used to validate the expected result of a test case, while v...
Selenium Grid is used for parallel testing across multiple browsers, devices, and operating systems.
Use Selenium Grid when you need to run tests in parallel to save time.
It is useful for testing on multiple browsers, devices, and operating systems simultaneously.
Helps in reducing test execution time by distributing tests across multiple nodes.
Useful for large test suites that require testing on various configurations.
C...
Different types of waits in Selenium WebDriver include Implicit Wait, Explicit Wait, and Fluent Wait.
Implicit Wait: Waits for a certain amount of time before throwing a NoSuchElementException.
Explicit Wait: Waits for a certain condition to occur before proceeding further in the code.
Fluent Wait: Waits for a condition to be true with a specified polling frequency and timeout.
Round duration - 30 Minutes
Round difficulty - Easy
This is a cultural fitment testing round .HR was very frank and asked standard questions. Then we discussed about my role.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
based on 1 interview
Interview experience
Software Engineer
23.3k
salaries
| ₹1.9 L/yr - ₹8 L/yr |
Technical Lead
21.5k
salaries
| ₹7 L/yr - ₹28 L/yr |
Senior Software Engineer
16k
salaries
| ₹4.5 L/yr - ₹17 L/yr |
Lead Engineer
15.8k
salaries
| ₹4.1 L/yr - ₹14 L/yr |
Analyst
14.6k
salaries
| ₹0.8 L/yr - ₹6.6 L/yr |
TCS
Wipro
Accenture
Cognizant