Fidelity International Programmer Analyst Interview Questions and Answers

Exceptions are unexpected events that occur during the execution of a program, disrupting the normal flow of the program.

• Exceptions are used to handle errors and other exceptional conditions in a program.

• They allow the program to respond to unexpected situations and prevent the program from crashing.

• Examples of exceptions include division by zero, file not found, and out-of-memory errors.

DI and IoC are design patterns used in Spring Boot to achieve loose coupling and improve testability.

• DI (Dependency Injection) is a design pattern where the dependencies of a class are injected from the outside rather than created within the class itself.

• IoC (Inversion of Control) is a design principle where the control of object creation and lifecycle is inverted from the class to an external entity.

• Spring Boot u...read more

A constraint is a rule or limitation that must be followed in a system or process.

• Constraints restrict the actions or behaviors of users or systems.

• Constraints can be related to data validation, business rules, or system limitations.

• Examples of constraints include password length requirements, maximum file size limits, and budget constraints.

Joins are used in databases to combine rows from two or more tables based on a related column between them.

• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the rig...read more

Left outer join is a type of join operation that returns all records from the left table and the matched records from the right table.

• Left outer join combines rows from two tables based on a related column between them.

• It includes all the rows from the left table, even if there are no matches in the right table.

• Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by eliminating duplicate data

• Normalization improves data integrity by ensuring that each piece of data is stored in only one place

• There are different levels of normalization, such as First Nor...read more

A sub-query is a query nested within another query in SQL to retrieve data from multiple tables.

• Used to retrieve data from multiple tables

• Can be used in SELECT, INSERT, UPDATE, or DELETE statements

• Must be enclosed in parentheses

Serialization is the process of converting an object into a stream of bytes to store or transmit data.

• Serialization is used to save the state of an object and recreate it when needed.

• In Java, serialization is achieved by implementing the Serializable interface.

• Example: ObjectOutputStream and ObjectInputStream classes are used for serialization in Java.