CapitalOne Data Analyst Interview Questions and Answers

Sql, power Bi basic and Reporting knowledge

Sql knowledge , use of power bi

Salary discussion round

Q1. What is your job role
Ans. 
I am responsible for assisting in various tasks and projects within the company.
• Supporting team members in daily operations

• Completing assigned tasks in a timely manner

• Assisting in research and analysis

• Participating in meetings and discussions
Answered by AI
Add your answer
Q2. What is the ctc
Ans. 
CTC stands for Cost to Company, which includes all expenses related to an employee's compensation.
• CTC includes salary, bonuses, benefits, and any other perks provided by the company

• It is the total amount of money a company spends on an employee in a year

• CTC is often used to negotiate job offers and understand the full value of a compensation package
Answered by AI
Add your answer

Test was based on arrays and some dsa concepts.

Q1. Does Java support pass by reference?
Ans. 
Yes
• Java uses pass by value for all variables, including object references.

• When an object reference is passed as an argument, a copy of the reference is passed, not the actual object.

• Modifying the reference inside the method will not affect the original reference outside the method.

• However, modifications to the object's state inside the method will be visible outside the method.
Answered by AI
Add your answer
Q2. Explain Singleton Pattern
Ans. 
Singleton pattern restricts the instantiation of a class to a single object.
• Singleton pattern ensures that only one instance of a class exists throughout the application.

• It provides a global point of access to the instance.

• Commonly used in scenarios where a single instance needs to coordinate actions across the system.

• Example: Database connection manager, logger, configuration manager.
Answered by AI
Add your answer

Q1. Internal Implementation of HashMap
Ans. 
HashMap is implemented using an array of linked lists to handle collisions.
• HashMap stores key-value pairs in an array of linked lists

• Hash function is used to determine the index of the array where the key-value pair will be stored

• Collision handling is done by chaining, where multiple key-value pairs with the same hash value are stored in the same linked list

• HashMap allows null keys and values

• HashMap is not synchronized...read more
Answered by AI
Add your answer