SAP Ariba Interview Questions and Answers

Q1. Design schema for movie booking system ?
Ans. 
Design schema for a movie booking system.
• Create tables for movies, theaters, users, bookings, and payments.

• Use foreign keys to establish relationships between tables.

• Include attributes like movie title, showtime, seat number, user details, booking status, payment details, etc.

• Consider implementing a booking algorithm to handle seat selection and availability.

• Ensure data integrity and normalization for efficient data re
Answered by AI
Add your answer
Q2. How would u scale the app (database wise) over India ?
Ans. 
To scale the app database over India, consider sharding, replication, and using cloud services.
• Implement sharding to distribute data across multiple servers based on geographic location or other criteria.

• Set up replication to ensure data consistency and availability in different regions.

• Utilize cloud services like AWS or Azure to easily scale resources based on demand.

• Optimize queries and indexes to improve database pe...read more
Answered by AI
Add your answer

Q1. What is sharding vs partitioning
Ans. 
Sharding and partitioning are both techniques used in database management to improve performance and scalability by dividing data into smaller chunks.
• Sharding involves splitting a database into smaller, independent databases called shards, each responsible for a subset of the data.

• Partitioning involves dividing a database into smaller segments called partitions, each containing a subset of the data based on a defined c...read more
Answered by AI
Add your answer
Q2. What are the 3 basic components of database, and do a RCA for why a DB is down.
Ans. 
The 3 basic components of a database are data, schema, and software. An RCA for a DB being down involves identifying the root cause of the issue.
• Data: the actual information stored in the database, such as customer records or product details.

• Schema: the structure that defines how the data is organized and related to each other, including tables, fields, and relationships.

• Software: the database management system (DBMS) ...read more
Answered by AI
Add your answer

Q1. DSA Array, String and Hashmap questions
Add your answer
Q2. Functional programming java questions
Add your answer

Q1. Spring and spring boot related
Add your answer
Q2. HLD scenario level questions
Add your answer
Q3. SQL queries nested and joins
Add your answer
Q4. DB related questions and experience level questions and previous project situations related questions
Add your answer
Q5. Security level questions like XSS vulnerability and SQL injection
Add your answer

It was good. The platform could be better.

Q1. Explain code from Round 1
Ans. 
The code from Round 1 involved implementing a sorting algorithm in Python.
• Implemented a sorting algorithm in Python

• Used concepts like loops, conditionals, and list manipulation

• Example: Implemented bubble sort or selection sort
Answered by AI
Add your answer

Q1. Question about Tree and Linked List.
Add your answer

Q1. Questions from OOPs, DBs. Practical questions
Add your answer

Q1. Create class, constructor, inheritance various scenarios related to that
Add your answer

Q1. HR questions like goals, aspirations etc.
Add your answer

Basic Reasoning and Quant.
They do give the sample questions link. Have to go through it and then appear for exam.

40 questions in 20 mins
Reasoning has major contribution in aptitude test. Me and my other frnds had 25-30 questions just on reasoning.

Q1. Had multiple questions related to P&C insurance domain. Mostly the functionality of scenarios.
Add your answer
Q2. Had questions related to testing, defect leakage control and how to handle the team
Add your answer

Q1. Same as Technical interview 1 just questions were more oriented towards managing resources.
Add your answer
Q2. How will you distribute workload etc.
Ans. 
Workload distribution will be based on team members' strengths, workload complexity, deadlines, and priorities.
• Assess team members' strengths and weaknesses

• Assign tasks based on complexity and deadlines

• Prioritize tasks based on project goals

• Regularly communicate with team members to ensure workload balance
Answered by AI
Add your answer

Q1. Coding with design fundamentals on BST and DP
Add your answer

Q1. Coding test with BST, DP
Add your answer
Q2. LLD, HLD on telecom. SOLID principles, Design patterns, System design
Add your answer

Q1. One on one round with Architect and Manager. What do we know about SIP, SS7, Diameter.
Add your answer

Q1. Usual HR questions
Add your answer

Q1. Describe the boot process of kernel.
Ans. 
The kernel boot process involves several stages from power on to loading the operating system.
• BIOS/UEFI firmware initializes hardware components

• Bootloader (such as GRUB) loads the kernel into memory

• Kernel initializes essential system components

• Init process starts user space processes

• System is ready for user interaction
Answered by AI
Add your answer