Oakton Interview Questions and Answers

Q1. Introduction, Current project overview and your role and responsibilities
Add your answer
Q2. Agile Ceremonies, Role of QA in Agile
Ans. 
Agile ceremonies are key meetings in Agile methodology where QA plays a crucial role in ensuring quality throughout the development process.
• QA participates in Agile ceremonies such as Sprint Planning, Daily Stand-ups, Sprint Review, and Sprint Retrospective to provide input on quality aspects.

• QA helps in defining acceptance criteria for user stories during Sprint Planning to ensure that the team understands the quality...read more
Answered by AI
Add your answer
Q3. Story Estimation Techniques in Agile
Ans. 
Story estimation techniques in Agile involve using relative sizing, planning poker, and t-shirt sizing.
• Relative sizing compares the size of one story to another to estimate effort.

• Planning poker involves team members individually estimating stories and then discussing differences.

• T-shirt sizing categorizes stories into small, medium, large, etc. based on complexity.

• Fibonacci sequence can be used for story points (1, 2,
Answered by AI
Add your answer
Q4. Updating scrum board and its process
Ans. 
Updating the scrum board involves adding, moving, and removing tasks to reflect the current status of the project.
• Regularly update the scrum board with the progress of tasks

• Move tasks from 'To Do' to 'In Progress' to 'Done' columns as they are worked on and completed

• Remove tasks that are no longer relevant or have been completed

• Ensure the team is aware of any changes made to the scrum board
Answered by AI
Add your answer
Q5. Different type of SQL Joins
Ans. 
SQL Joins are used to combine rows from two or more tables based on a related column between them.
• 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 right table

• RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table

• FULL JOIN: Returns rows when there is a match in one of the tables
Answered by AI
Add your answer
Q6. Test Plan, test Report in detal
Add your answer
Q7. Testing tools used
Ans. 
I have experience using a variety of testing tools such as Selenium, Jira, and TestRail.
• Selenium

• Jira

• TestRail
Answered by AI
Add your answer
Q8. Years of experience in team leading and challenges faced
Ans. 
Over 5 years of experience leading QA teams, faced challenges in communication, resource allocation, and stakeholder management.
• Managed a team of 10 QA engineers, ensuring timely delivery of high-quality testing.

• Challenges included resolving conflicts within the team, prioritizing tasks based on project deadlines, and effectively communicating with stakeholders.

• Implemented agile methodologies to improve team efficiency...read more
Answered by AI
Add your answer
Q9. Questions on Finance domain like derivatives, equity , Regulatory reports
Add your answer

It was pair programming round where we need to attempt a couple of Spark Scenario along with the Interviewer. You will have a boiler plate code with some functionalities to be filled up. You will be assessed on writing clean and extensible code and test cases.

Q1. Questions will be based on the Project where they try to assess the depth of understading you have on your project, data quality checks, handling failure scenarios, reasoning behind choice of tech stack
Add your answer

Q1. What are the key topics related to Generative AI, specifically focusing on Retrieval-Augmented Generation (RAG) and Large Language Models (LLM)?
Add your answer
Q2. What is your understanding of the existing project and the technology stacks used?
Add your answer

Q1. What has been your contribution to existing work and the technologies used in that context?
Add your answer
Q2. ML, DL, Gen AI implementation and flow
Add your answer
Q3. Python Coding logic and semantics
Add your answer

Q1. What are the existing work challenges you face, and what solutions have you implemented to address them?
Add your answer
Q2. What is your understanding of Generative AI and Natural Language Processing (NLP), and can you provide examples of their use cases?
Add your answer

Q1. HTML, CSS fundamentals
Add your answer
Q2. Javascript event loop and array methods
Add your answer
Q3. Javascript coding for operation on object array
Ans. 
Performing operations on an array of objects using JavaScript.
• Use array methods like map, filter, reduce for operations on object array.

• Access object properties using dot notation or bracket notation.

• Iterate through the array using loops like for loop or forEach method.

• Example: Calculate total sum of 'price' property in an array of products.
Answered by AI
Add your answer
Q4. React benefits and Redux implementations
Add your answer
Q5. How to create slice and combine reducers
Ans. 
To create slice and combine reducers in React, use the createSlice and combineReducers functions from Redux toolkit.
• Use createSlice function to define a slice of state with reducers and actions.

• Example: const counterSlice = createSlice({ name: 'counter', initialState: 0, reducers: { increment: state => state + 1, decrement: state => state - 1 } })

• Use combineReducers function to combine multiple slices into a sing...read more
Answered by AI
Add your answer

Q1. Questions based on projects, role, responsibilities and initiative at work place
Add your answer
Q2. How to create and optimize a react application
Ans. 
To create and optimize a React application, focus on efficient component structure, state management, code splitting, lazy loading, and performance monitoring.
• Use functional components and hooks for better performance.

• Implement state management with tools like Redux or Context API.

• Split code into smaller chunks and lazy load components for faster initial load times.

• Optimize performance by minimizing re-renders and usin...read more
Answered by AI
Add your answer

Q1. Day to day activity of workplace and salary negotiation
Ans. 
Day to day activities involve coding, debugging, testing, collaborating with team members. Salary negotiation involves research, preparation, and effective communication.
• Coding and developing new features

• Debugging and fixing issues

• Testing code for quality assurance

• Collaborating with team members for project progress

• Researching market rates for salary negotiation

• Preparing a strong case for desired salary

• Effectively comm
Answered by AI
Add your answer

Some basic testing questions

Q1. Selenium waits, java oops , priority vs severity
Add your answer
Q2. Write a selenium code by using assertions
Add your answer

Q1. Write selenium code and execute on screen
Add your answer
Q2. Write an sql query and get the desired output on screen
Add your answer

Q1. Salary expectations
Add your answer
Q2. Notice period related
Add your answer

Q1. Given an array of non-negative integers.Find the length of the longest subsequence such that elements in the subsequence are contiguous integers. The consecutive numbers can be in any order. Example n=7 nu...read more
Ans. 
Find the length of the longest subsequence of contiguous integers in an array.
• Sort the array

• Iterate through the array and check for consecutive integers

• Keep track of the longest subsequence found
Answered by AI
Add your answer
Q2. Get list of pincodes from these objects Employee{ id Long, name String, Addresses : List
} Addresses{ houseNo long, pindcode long, state String, country String, } Ans. Use flatMap to flatten and then use m...read more
Ans. 
Use flatMap and map to extract list of pincodes from Employee objects
• Use flatMap to flatten the list of Addresses in each Employee object

• Use map to iterate over the flattened list and extract the pincodes

• Example: employeeList.stream().flatMap(emp -> emp.getAddresses().stream()).map(address -> address.getPincode()).collect(Collectors.toList())
Answered by AI
Add your answer
Q3. What is Database Pooling, Hikari and its configurations. Java 8 to current enchancements and current java version Factory and Builder design patterns to explain and code Project expalantion and details, Cr...read more
Ans. 
Database pooling is a technique used to manage a pool of database connections for efficient resource utilization. HikariCP is a popular database connection pooling library in Java.
• HikariCP is a high-performance database connection pooling library for Java applications.

• It is known for its low latency and high throughput.

• Configurations for HikariCP include settings such as maximum pool size, connection timeout, and idle ...read more
Answered by AI
Add your answer

Q1. Types of job in kotlin coroutine
Ans. 
Types of jobs in Kotlin coroutine include launch, async, withContext, and runBlocking.
• launch: starts a new coroutine without blocking the current thread

• async: starts a new coroutine and returns a Deferred object with a result

• withContext: switches the coroutine context within a coroutine

• runBlocking: blocks the current thread until the coroutine inside it is completed
Answered by AI
Add your answer
Q2. What is Flow, Channel diffrent between StateFlow and SharedFlow
Ans. 
Flow is a cold asynchronous data stream, Channel is a hot asynchronous data stream. StateFlow is a hot asynchronous data stream with a state, SharedFlow is a hot asynchronous data stream without a state.
• Flow is a cold asynchronous data stream that emits values one by one.

• Channel is a hot asynchronous data stream that can have multiple subscribers.

• StateFlow is a hot asynchronous data stream that retains the most recent ...read more
Answered by AI
Add your answer
Q3. If Flow lifecycle aware
Ans. 
Flow lifecycle aware means using Kotlin Flow with lifecycle awareness in Android development.
• Flow lifecycle aware helps manage data streams in Android apps

• It ensures that data emissions are only observed when the lifecycle is in the appropriate state

• Example: Using Flow with LiveData to update UI components based on lifecycle events
Answered by AI
Add your answer
Q4. What is inline function and highorder function?
Ans. 
Inline functions are functions that are expanded in place at the call site, while high-order functions are functions that can take other functions as parameters or return them.
• Inline functions are expanded in place at the call site to improve performance.

• High-order functions can take other functions as parameters or return them.

• Example of high-order function: map() function in Kotlin.
Answered by AI
Add your answer

Q1. Tableau Questions 1. Difference between dimensions and measures. 2. What is RLS? 3. What are the functions you can assign in RLS? 4. Explain what is drill down approach. 5. What is LOD? 6. What is a calcul...read more
Add your answer
Q2. SQL Questions 1. In employee table find the 2nd highest salary. 2. Find the highest average salary in department 3. Given two tables(sales & product) find total sales per category 4. Two questions to find ...read more
Add your answer

Q1. Prior Experience
Add your answer
Q2. Capital Market, Hedge Fund
Add your answer
Q3. Derivatives, Scenario-based question
Add your answer

Q1. Prior Experience
Add your answer
Q2. How do you handle escalations?
Ans. 
I handle escalations by addressing the issue promptly, involving necessary stakeholders, and providing regular updates.
• Address the issue promptly to prevent further escalation

• Involve necessary stakeholders to gather input and support

• Provide regular updates to all parties involved to ensure transparency and progress

• Implement solutions to prevent similar escalations in the future
Answered by AI
Add your answer
Q3. What was the toughest escalation I have ever managed
Add your answer
Q4. Excel - Index, Match, Lookups - XLookup, VLookup, HLookup
Add your answer
Q5. Job Description
Add your answer

Q1. Long term vs short-term securities
Ans. 
Long-term securities are investments held for an extended period, while short-term securities are held for a shorter duration.
• Long-term securities typically have maturity dates of over one year, such as bonds or stocks.

• Short-term securities have maturity dates of one year or less, like Treasury bills or certificates of deposit.

• Long-term securities offer higher potential returns but also higher risk, while short-term se...read more
Answered by AI
Add your answer
Q2. Data analysis, vizualization
Add your answer
Q3. Yield to Maturity, the relationship between yield and interest
Ans. 
Yield to Maturity is the total return anticipated on a bond if it is held until it matures.
• Yield to Maturity is the annual rate of return an investor can expect to earn if the bond is held until it matures.

• It takes into account the bond's current market price, par value, coupon interest rate, and time to maturity.

• Yield to Maturity helps investors compare different bonds and make informed investment decisions.

• For exampl...read more
Answered by AI
Add your answer
Q4. About my project
Add your answer
Q5. Job Description
Add your answer