Moniepoint Interview Questions and Answers

Q1. Write a select query that selects all the data from a table named cards where the pan column has values that start or begin with the number ‘4’ and the active_percentage column has values not being one of...read more
Ans. 
Selects records from 'cards' where 'pan' starts with '4' and 'active_percentage' is not 20, 50, 60, or 70.
• Use the SQL SELECT statement to retrieve data from the 'cards' table.

• Utilize the LIKE operator to filter 'pan' values starting with '4'. Example: '4%'

• Use the NOT IN clause to exclude specific 'active_percentage' values. Example: NOT IN (20, 50, 60, 70)

• Combine conditions using the WHERE clause to ensure both criteri...read more
Answered by AI
Add your answer
Q2. Could you type in the chatbox a sample LEFT JOIN selecting all columns of all records from a table called agents and corresponding columns in the second table called wallets, where wallet_id is a column sh...read more
Ans. 
Sample SQL LEFT JOIN query to select all columns from agents and wallets, ordered by created_on.
• Use LEFT JOIN to include all records from agents and matching records from wallets.

• Select all columns using * from both tables.

• Filter results to the earliest records using ORDER BY created_on.

• Limit the results to 200 records using LIMIT 200.
Answered by AI
Add your answer
Q3. You are in charge of the mobile banking application of a bank, which runs a micro service architecture, and at a particular time 4 different services(Transfer, Airtime, Billpayment, Login) of the applicat...read more
Ans. 
I would prioritize identifying the root causes of each service outage and work on restoring them one by one.
• Prioritize identifying the root causes of each service outage

• Work on restoring the services one by one

• Communicate with relevant teams to coordinate efforts

• Implement monitoring and alerting systems to prevent future outages
Answered by AI
View 1 more answer
Q4. Problem: You are asked to prove that the bulb in a refrigeraitor actually goes off upon closing the door of the refrigerator, how can you prove this.
Ans. 
To prove that the bulb in a refrigerator actually goes off upon closing the door, you can use a simple test involving observation and a manual switch.
• Open the refrigerator door and observe the bulb is on.

• Manually press the switch that is triggered when the door is closed to simulate the door being closed.

• Observe that the bulb turns off when the switch is pressed, indicating that it does go off when the door is closed.
Answered by AI
Add your answer
Q5. Problem: Six plays A, B, C, D, E and F are staged on six days of the week starting from Monday to Saturday. Play C is staged on Tuesday. Plays A, F and B are staged one after the other in the same order. P...read more
Ans. 
Play E is staged on Saturday.
• Play C is staged on Tuesday.

• Plays A, F, and B are staged one after the other.

• Play D is not staged on Monday or Wednesday.
Answered by AI
Add your answer
Q6. Problem: How can you measure 4L of water with only a 5L cup and a 3L cup (assume that you have an unlimited supply of water).
Add your answer

Q1. Write a query showing the percentage of completed transactions.
Ans. 
Query to show the percentage of completed transactions
• Use COUNT() function to count total transactions

• Use SUM() function to count completed transactions

• Calculate percentage by dividing completed transactions by total transactions and multiplying by 100
Answered by AI
Add your answer
Q2. Tell me about your recent role.
Add your answer
Q3. Tell me about the tools you use.
Ans. 
I use a variety of tools such as remote desktop software, ticketing systems, knowledge bases, and diagnostic tools.
• Remote desktop software (e.g. TeamViewer, AnyDesk)

• Ticketing systems (e.g. Zendesk, Jira)

• Knowledge bases (e.g. Confluence, SharePoint)

• Diagnostic tools (e.g. Wireshark, Ping)
Answered by AI
Add your answer

Q1. - Experience with Agile transformation and forming teams - Metrics and the ones available in Jira - Tools you use - How to ensure there is no spillover and team is melting sprint goal
Ans. 
Experience with Agile transformation, metrics in Jira, tools used, and ensuring team meets sprint goal
• I have experience leading Agile transformations and forming high-performing teams through coaching and training

• I am familiar with metrics available in Jira such as burndown charts, velocity, and sprint reports

• I use tools like Jira, Trello, and Slack to facilitate communication and collaboration within the team

• To ensure...read more
Answered by AI
View 1 more answer
Q2. - Scenario on how to set up work/tasks/projects from start to finish
Ans. 
Setting up work in Scrum involves defining tasks, prioritizing them, and ensuring team collaboration throughout the project lifecycle.
• Define the project vision and goals with stakeholders.

• Create a product backlog with user stories, e.g., 'As a user, I want to log in to my account.'

• Prioritize the backlog using techniques like MoSCoW or the Kano model.

• Plan sprints by selecting high-priority items from the backlog for the...read more
Answered by AI
Add your answer

Q1. Explaining heap memory and new features of java 17
Ans. 
Heap memory in Java is used for dynamic memory allocation, while Java 17 introduces new features enhancing performance and usability.
• Heap memory is where Java objects are stored during runtime, allowing for dynamic memory allocation.

• Java 17 introduced 'Sealed Classes', which restrict class inheritance, enhancing security and maintainability.

• The 'Pattern Matching for instanceof' feature simplifies type checks and castin...read more
Answered by AI
Add your answer
Q2. Code review of Java inheritance loops
Ans. 
Reviewing Java inheritance loops involves identifying and resolving circular dependencies in class hierarchies.
• Check for circular dependencies: Ensure that no class inherits from another in a way that creates a loop.

• Use UML diagrams: Visualize class relationships to identify potential inheritance loops.

• Refactor if necessary: If a loop is found, consider using composition over inheritance to break the cycle.

• Example: If ...read more
Answered by AI
Add your answer

Q1. Basic questions on work background
Add your answer

There are 2 coding and 1 sql and 6 java questions