Nippon Express Deputy Manager Interview Questions and Answers

Case study related to marketing

Q1. Window sum in sql
Ans. 
Window sum in SQL is a way to calculate the sum of a specific column over a specified window of rows.
• Use the OVER clause with the SUM function to calculate window sum.

• Specify the window frame using ROWS or RANGE keyword.

• Example: SELECT column_name, SUM(column_name) OVER (ORDER BY column_name ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS window_sum FROM table_name;
Answered by AI
Add your answer
Q2. Tableau related questions
Add your answer

Q1. Expectations and general hr queries
Add your answer

Q1. The questions are about the past work experience
Add your answer
Q2. Regarding past work experience
Add your answer

Q1. Normal profile and industry related questions
Add your answer
Q2. Normal industry related questions
Add your answer

Q1. How will you manage the shortage of manpower
Ans. 
I will prioritize tasks, delegate responsibilities, and possibly hire temporary staff.
• Prioritize tasks based on urgency and importance

• Delegate responsibilities to existing staff members

• Consider hiring temporary staff to fill in the manpower shortage
Answered by AI
Add your answer

Q1. Salary and previous company work profiles
Add your answer

Q1. About all last mile operations
Add your answer
Q2. What about live cycle of shipments
Ans. 
The life cycle of shipments involves various stages from order placement to delivery and post-delivery follow-up.
• Order placement

• Processing and packaging

• Shipping and transportation

• Delivery to customer

• Post-delivery follow-up and customer feedback
Answered by AI
View 1 more answer

Q1. Salary discussion
Add your answer
Q2. Employee benefits
Add your answer

Q1. Self introduction
Add your answer

Q1. Brief experience
Add your answer