RMSI Interview Questions and Answers

Question 1

Asked in

Q1. What is the difference between the cursors declared in procedures and those declared in package specifications?

Add your answer

Question 2

Asked in

Q2. What is a PL/SQL cursor?

Add your answer

Question 3

Asked in

Q3. What is the difference between ROWID and ROWNUM in SQL?

Add your answer

Question 4

Asked in

Q4. What is the difference between triggers and stored procedures in a Database Management System (DBMS)?

Add your answer

Question 5

Asked in

Q5. What is a trigger in the context of a database management system?

Add your answer

Question 6

Asked in

Q6. Can you explain SQL join related queries?

Add your answer

Question 7

Asked in

Q7. what is your project exp in SCM module

Add your answer

Answer

I have 5 years of project experience in implementing and optimizing SCM modules.

Implemented end-to-end supply chain solutions for a global manufacturing company
Optimized inventory management processes to reduce costs and improve efficiency
Led cross-functional teams in implementing new SCM software systems
Developed and implemented KPIs to measure supply chain performance

Question 8

Asked in

Add your answer

Answer

ALE configurations in SAP PI PO

ALE (Application Link Enabling) is used for exchanging data between different SAP systems
ALE configurations in SAP PI/PO involve setting up logical systems, ports, partner profiles, and distribution models
ALE can be used for both inbound and outbound communication
ALE can be configured using transaction codes such as SALE, BD64, and WE20