Infosys Technical Analyst Interview Questions, Process, and Tips

The default keyword is used in programming languages to specify a default value or behavior.

• In switch statements, default is used as a catch-all case when no other case matches

• In function parameters, default values can be specified using the default keyword

• In object destructuring, default values can be assigned using the default keyword

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

Types of subfiles in technical analysis

• Single-page subfiles: display a single page of data at a time

• Multiple-page subfiles: display multiple pages of data at a time

• Controlled subfiles: allow for user interaction and data manipulation

• Window subfiles: display data in a separate window

• Embedded subfiles: display data within a parent file or screen