Walmart Database Admin Interview Questions, Process, and Tips

Round duration - 90 minutes
Round difficulty - Medium

Round duration - 60 minutes
Round difficulty - Medium

This was the technical round, held around at 10 AM IST on Google Meet.
Firstly she greeted me and asked me to tell something about myself, to which I introduced myself, explaining my academic and some projects also.
After that we moved on to the Hackathon project, which was smart cart self-checkout system. I explained the project along with the code, wherever necessary.
Every word you say while explaining should be clear to you.I used Firebase and SQL while explaining my project, to which she asked some questions related to it, 
Then she moved to the DBMS part, types of joins,what is indexing, how to approach if you were to design a payment system.
At last she asked me some Data Structure questions, which were of medium complexity

Q1. 
Remove the Kth Node from the End of a Linked List
You are given a singly Linked List with 'N' nodes containing integer data and an integer 'K'. Your task is to delete the Kth node from the end of this Lin...read more
Ans. 
Remove the Kth node from the end of a singly linked list given the position 'K'.
• Traverse the list to find the length 'N' of the linked list.

• Calculate the position of the node to be removed from the beginning as 'N - K + 1'.

• Traverse the list again and remove the node at the calculated position.
Answered by AI
Add your answer
Q2. 
House Robber Problem Statement
Consider Mr. X, a professional robber who is planning to rob houses along a street. These houses are arranged in a circle, which means the first house is a neighbor to the l...read more
Ans. 
House Robber problem where adjacent houses have connected security system, find maximum money Mr. X can rob without triggering security.
• Use dynamic programming to keep track of maximum money robbed at each house.

• At each house, decide whether to rob the current house or skip it based on maximum money robbed so far.

• Handle the circular nature of houses by considering two cases: robbing the first house and not robbing the ...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

The interviewer was very frank and cheerful. This was held at 2:30 PM IST on Google Meet.
He firstly greeted me and asked me how I was doing.
How was my previous round, any technical difficulties?
Then he asked me to introduce myself.
He started telling about his journey to Lowe's and his technical background.
Then he asked some HR related questions

There was a aptitude test with coding problems

Q1. Basic Puzzles were asked
Add your answer

Coding test contains 2 questions 1 moderate and 1 easy level

Q1. Asked about DSA,Heap sort,Merge sort.
Add your answer

Q1. Tell me about yourself
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Graduated with a degree in Computer Science

• Worked on various projects using Java and Python

• Familiar with web development technologies like HTML, CSS, and JavaScript
Answered by AI
Add your answer
Q2. Why Lowe's,how can Lowe's improve its customer services
Ans. 
I believe Lowe's is a reputable company with a strong focus on customer satisfaction. They can improve their customer services by implementing personalized recommendations, enhancing their online platform, and providing better in-store experiences.
• Implement personalized recommendations based on customer preferences and purchase history

• Enhance the online platform for easier navigation, product search, and checkout proce...read more
Answered by AI
Add your answer

Q1. Delete a node from a bst
Ans. 
To delete a node from a binary search tree (BST), we need to handle three cases: node has no children, node has one child, and node has two children.
• Start at the root and traverse the tree to find the node to be deleted.

• Handle the three cases: node has no children, node has one child, and node has two children.

• For a node with two children, find the inorder successor (smallest node in the right subtree) to replace the n
Answered by AI
Add your answer
Q2. DP based question
Add your answer

Q1. Why string arr immutable
Ans. 
String arrays are immutable because they cannot be changed once created.
• Strings in an array cannot be modified individually

• Any changes to a string array result in a new array being created

• Immutable arrays ensure data integrity and prevent unintended side effects
Answered by AI
Add your answer
Q2. How we can create a custom immutable class
Ans. 
To create a custom immutable class, use final keyword for class, private final fields, and no setter methods.
• Use the final keyword for the class to prevent inheritance

• Declare all fields as private and final to prevent modification

• Do not provide setter methods for the fields to maintain immutability

• Provide getter methods to access the fields
Answered by AI
Add your answer