Fidelity Investments Interview Questions, Process, and Tips for Freshers

Q1. A person accesses and inserts data into Database. What should he do so that his changes are visible to others?
Ans. 
The person should commit the changes to the database and refresh the view for others to see.
• Commit the changes to the database

• Refresh the view for others to see

• Ensure proper permissions are set for others to access the data
Answered by AI
Add your answer
Q2. Commit command in SQL
Ans. 
Commit command is used to permanently save changes made in a transaction in SQL.
• Commit command is used to end a transaction and make all changes permanent.

• It is used to save changes made in a transaction to the database.

• If a transaction is not committed, the changes made will be rolled back.

• Syntax: COMMIT;
Answered by AI
Add your answer

Q1. Use case of B tree
Ans. 
B tree is a self-balancing tree data structure used for indexing and searching large datasets efficiently.
• B trees are commonly used in databases and file systems for indexing

• They have a high fanout factor which reduces the height of the tree and improves search performance

• B trees maintain balance by splitting and merging nodes as needed

• Example: In a database, B tree can be used to quickly locate a specific record based
Answered by AI
View 1 more answer
Q2. Algo of quick sort
Ans. 
Quick sort is a divide-and-conquer algorithm that sorts an array by selecting a 'pivot' element and partitioning the array around the pivot.
• Select a pivot element from the array

• Partition the array into two sub-arrays: elements less than the pivot and elements greater than the pivot

• Recursively apply quick sort to the sub-arrays

• Combine the sorted sub-arrays to get the final sorted array
Answered by AI
View 1 more answer

Round duration - 120 minutes
Round difficulty - Medium

Q1. 
Rearrange Alternately
Given an array arr of size N, containing positive and negative integers, rearrange the array such that every non-negative integer is followed by a negative integer and vice-versa.
I...read more
Add your answer
Q2. 
Find Pair With Smallest Difference Problem Statement
Given two unsorted arrays of non-negative integers, arr1 and arr2 with sizes N and M, determine the pair of elements (one from each array) which have t...read more
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

Q1. 
N-th Fibonacci Number Calculation
Determine the N-th Fibonacci number using matrix exponentiation for a given integer 'N'.
Because the result can be huge, compute the answer modulo 10⁹ + 7.
Example:
In...read more
Add your answer

Round duration - 20 minutes.
Round difficulty - Medium

Coding and mcqs

Q1. Technical round about QA process
Add your answer

Q1. Write a star program in any programming language you know? How many for loops required for it?
Ans. 
A star program can be written using nested for loops in any programming language.
• Use two nested for loops to print the rows and columns of the star pattern.

• The number of rows and columns can be determined by the user input or a constant value.

• The star pattern can be created using asterisks or any other character.

• The number of for loops required depends on the complexity of the star pattern.

• For a simple star pattern, on
Answered by AI
Add your answer
Q2. Tell me about yourself and your experience in your past organization
Add your answer