AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Fidelity Investments
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Fidelity Investments Oracle Database Administrator Interview Questions and Answers
Fidelity Investments Oracle Database Administrator Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Aug 2021. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Data pump, golden gate and performs tuning
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Anonymous
(1 Question)
- Q1. Tell me about yourself
- Ans.
I am a passionate software engineer with experience in developing web applications using various technologies.
Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular
Proficient in backend development with Node.js and databases like MySQL and MongoDB
Familiar with version control systems like Git and deployment tools like Docker
(1 Question)
- Q1. Tell me about yourself
- Ans.
I am a software engineer with 5 years of experience in developing web applications using Java, Spring Boot, and Angular.
5 years of experience in software development
Proficient in Java, Spring Boot, and Angular
Strong problem-solving skills
Experience working in Agile development environment
Passionate about learning new technologies
Sachin Aglave
Interview Questionnaire
4 Questions
- Q1. Tell me about your internship, B.Tech project(BTP), CV
- Q2. Implement LRU cache.
- Ans.
Implement LRU cache
LRU stands for Least Recently Used
It is a cache eviction policy that removes the least recently used item
It can be implemented using a doubly linked list and a hash map
Newly accessed items are moved to the front of the list
When the cache is full, the item at the end of the list is removed
- Q3. What is virtual memory? Will we need virtual memory even if we have infinite amount of RAM?
- Ans.
Virtual memory is a memory management technique that allows a computer to use more memory than it physically has.
Virtual memory uses a combination of RAM and hard disk space to store data.
It allows programs to use more memory than is physically available.
If a program tries to access memory that is not currently in RAM, it will be swapped in from the hard disk.
Even if we had infinite RAM, virtual memory would still be n...
- Q4. Given an array, Find out maximum length of subarray where max of subarray <= 2*min of subarray
- Ans.
Find maximum length of subarray where max <= 2*min.
Iterate through array and keep track of max and min values.
Update max length when condition is met.
Time complexity: O(n)
Interview Preparation Tips
Experience: No CPI cut off and It was open for all departments.
Round: Test
Experience: In muliple choice question Mostly questions were base on maths, probability, c programs, algorithms, Systems. If you are prepared then Questions were not that much tough. Keep strong concepts of Operating systems. For subjective part, Some problems were from maths proofs, some were from probability, some were from algo. We had to write algorithms. etc
Duration: 180 minutes
Round: Problem Statement
Experience: Questions were doable.
Round: Interview
Experience: Everyone was cool, They made me feel comfortable and then started asking questions.
Tips: If you have good rank in online coding competition, do mention it in CV.Most of the students think that GS asks only probability-puzzles. They did not asked me any question on probability or puzzle. Everything they asked was based on Algorithms problems and Operating system. I think it depends on team for which they are hiring. Most important point is don’t lose hope because you have low CPI or you are not good at something. Keep Operating systems fundamental concepts strong.
General Tips: We should balance in Placement and Compititive online coding. Keep in mind Placements and Compititive online coding are some what different things. Keep on improving our mistakes on daily basis. I would strongly suggest you to do introspection daily it will help you to find out your weaknesses and strong points, where we are going wrong etc. There are two thing on which we shoud focus.1. Preparation (I have told everything requered for preparation).2. Get output of all hard work. How to keep our mind on 100% output while the actual exam(placement).For this, I used to go for physical exercise daily in the morning and medidate for 20-30 minutes. Along with exercise i used to do Sudarshan Kriya(Art of Living). Meditation has lot of power :).
Skill Tips: Keep your OS fundamentals strong. To improve codgin skills practice as many problems as you can. Regularly participate in online coding competitions it really helps to solve or approach any new problem. Many time instead of correct answer the approach to solve the problems is very important. How you think, How you approach the problem is checked in interview.
Skills: Coding Skills, Operating Systems , Problem solving skills
College Name: IIT Guwahati
Motivation: The name GS itself enogh for motivation.
Skills evaluated in this interview
I was interviewed before Mar 2021.
(3 Questions)
Round duration - 60 minutes
Round difficulty - Medium
Technical round with questions on DSA and OS.
- Q1.
LRU Cache Design Problem Statement
Design and implement a data structure for a Least Recently Used (LRU) cache that supports the following operations:
get(key)- Retrieve the value associated with the...
- Ans.
Design and implement a Least Recently Used (LRU) cache data structure that supports get and put operations with a specified capacity.
Implement a doubly linked list to keep track of the order of keys based on their usage.
Use a hashmap to store key-value pairs for quick access and updates.
When a key is accessed or updated, move it to the front of the linked list to mark it as the most recently used.
When the cache reaches...
- Q2.
Maximum of All Subarrays of Size K
Given an array of non-negative integers and an integer K representing the length of a subarray, your task is to determine the maximum elements for each subarray of size ...
- Ans.
Find the maximum elements for each subarray of size K in a given array.
Iterate through the array and maintain a deque to store the indices of elements in decreasing order.
Pop elements from the deque that are out of the current window.
Keep track of the maximum element in each subarray of size K.
Return the maximum elements for each subarray.
- Q3. What is virtual memory?
- Ans.
Virtual memory is a memory management technique that allows a computer to compensate for physical memory shortages by temporarily transferring data from RAM to disk storage.
Virtual memory allows programs to use more memory than is physically available on the system.
It helps in multitasking by allowing multiple programs to run simultaneously without running out of memory.
Virtual memory uses a combination of RAM and disk...
Interview Preparation Tips
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.
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.
Generic topics that were trending at the time
(1 Question)
- Q1. Puzzle round - aptitude
(1 Question)
- Q1. Technical Round - coding related questions
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Mar 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. All were Ds and algo questions?
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Questions on angular framework,.net core , dependency injection,legacy .net, session management , agile ceremonies.
I applied via Recruitment Consultant and was interviewed in Dec 2020. There was 1 interview round.
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed before Mar 2021. There was 1 interview round.
(2 Questions)
- Q1. Java and OOPS Associated Questions
- Q2. Spring and Basic Programming Like Sort, Searching
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Frequency of each word ina sentence
- Ans.
To find the frequency of each word in a sentence.
Split the sentence into words
Create a dictionary to store word frequency
Iterate through the words and update the dictionary
Return the dictionary
Skills evaluated in this interview
Tell us how to improve this page.
Fidelity Investments Interviews By Designations
- Fidelity Investments Software Engineer Interview Questions
- Fidelity Investments Software Developer Interview Questions
- Fidelity Investments Intern Interview Questions
- Fidelity Investments Lead Software Engineer Interview Questions
- Fidelity Investments Senior Software Engineer Interview Questions
- Fidelity Investments Apprentice Interview Questions
- Fidelity Investments Analyst Interview Questions
- Fidelity Investments Executive Graduate Trainee Interview Questions
- Show more
Interview Questions for Popular Designations
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Database Architect Interview Questions
- Mysql Database Administrator Interview Questions
- Oracle Application Database Administrator Interview Questions
- SQL Server Database Administrator Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Fidelity Investments Oracle Database Administrator Reviews and Ratings
based on 1 review
Rating in categories
|
Lead Software Engineer
963
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
906
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Process Specialist
296
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Principal Software Engineer
229
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Process Specialist
196
salaries
| ₹0 L/yr - ₹0 L/yr |
Vanguard
Blackrock
Charles Schwab
JPMorgan Chase & Co.
- Home >
- Interviews >
- Fidelity Investments Interview Questions >
- Fidelity Investments Oracle Database Administrator Interview Questions
