Infosys Technical Analyst Interview Questions, Process, and Tips

Comparing strings, counting duplicate characters using hash map, and finding the third highest salary from emp table in SQL.

• Use a hash map to count duplicate characters in a string.

• Compare strings by using built-in string comparison functions or algorithms.

• To find the third highest salary in SQL, you can use a subquery or window function like ROW_NUMBER().

String pool is a mechanism in programming languages where strings are stored in a shared memory area to save memory and improve performance.

• String pool helps in reducing memory usage by storing only one copy of each unique string.

• Strings in the pool can be easily shared among different parts of the program.

• In Java, string literals are automatically stored in the string pool.

• Example: String str1 = "Hello"; String str2 =...read more

The flow of a Springboot Application involves the initialization of the application context, handling HTTP requests, processing business logic, and returning responses.

• Initialization of the application context using annotations like @SpringBootApplication

• Handling HTTP requests through controllers annotated with @RestController

• Processing business logic in service classes annotated with @Service

• Interacting with databases...read more

Hive tables store data in HDFS while external tables reference data stored outside HDFS.

• Hive tables store data in HDFS, while external tables reference data stored outside HDFS.

• External tables are useful when data needs to be shared across different Hive instances or when data is already stored in a different location.

• Hive tables are managed by Hive and are deleted when the table is dropped, while external tables are n...read more

Data warehouse (DWH) is structured and optimized for querying and analysis, while data lake is a vast repository for storing raw data in its native format.

• DWH is used for structured data and is optimized for querying and analysis.

• Data lake stores raw data in its native format, allowing for more flexibility and scalability.

• DWH is typically used for business intelligence and reporting purposes.

• Data lake is suitable for s...read more

Find the element that appears only once in an array of strings

• Use XOR operation to find the element that appears only once

• Iterate through the array and XOR each element to find the unique element

• Example: ['apple', 'banana', 'apple', 'orange', 'banana'] should return 'orange'