Sodexo Senior Associate Interview Questions and Answers

What is DBa role do when they find out issue on tablepsace

Q1. What is oracle database?
Ans. 
Oracle database is a relational database management system developed by Oracle Corporation.
• Oracle database is used for storing and managing data in a structured format.

• It supports SQL as a query language for accessing and manipulating data.

• Oracle database offers features like data security, scalability, and high availability.

• Examples of Oracle database editions include Oracle Database Standard Edition, Enterprise Editi
Answered by AI
Add your answer
Q2. Expain oracle database architecture?
Ans. 
Oracle database architecture is a multi-tiered system with components like client, server, and storage.
• Consists of physical and logical structures

• Includes processes like SQL processing, memory management, and I/O management

• Client communicates with server through SQL*Net

• Server manages data storage and retrieval

• Storage includes data files, control files, and redo log files
Answered by AI
Add your answer

Q1. Overall previous site infrastructure details
Ans. 
Previous site infrastructure included data centers, networking equipment, servers, and storage systems.
• Data centers were located in multiple regions for redundancy.

• Networking equipment included routers, switches, and firewalls.

• Servers were a mix of physical and virtual machines.

• Storage systems used SAN and NAS technologies.

• Backup and disaster recovery plans were in place.

• Monitoring tools were used to track performance
Answered by AI
Add your answer

Multiple scenarios of UPS DG CHILLER FAILURES

Round duration - 60 Minutes
Round difficulty - Medium

The round started at 8 PM. There was one question with several test cases and had to pass every test case in order to get a call for interview.

Q1. 
Nth Fibonacci Number Problem Statement
Calculate the Nth term in the Fibonacci sequence, where the sequence is defined as follows: F(n) = F(n-1) + F(n-2), with initial conditions F(1) = F(2) = 1.
Input:
...read more
Add your answer

Round duration - 45 Minutes
Round difficulty - Medium

It was first round for 45mins and only one question was asked.

Q1. 
Sum Of Zeroes Coverage Calculation
You are provided with a binary matrix containing dimensions 'N * M', comprised only of 0s and 1s. Your task is to compute the aggregated sum of coverages for all the zer...read more
Add your answer

Round duration - 45 Minutes
Round difficulty - Easy

It was again 45 min interview and after an intro we quickly jumped in coding.

Q1. 
Word Occurrence Counting
Given a string 'S' of words, the goal is to determine the frequency of each word in the string. Consider a word as a sequence of one or more non-space characters. The string can h...read more
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

It was an Technical + HR round. The interviewer was very understanding and he checked the overall knowledge of the subject.

Q1. 
Kth Smallest Element Problem Statement
You are provided with an array of integers ARR of size N and an integer K. Your task is to find and return the K-th smallest value present in the array. All elements...read more
Add your answer

Q1. Asking for Current location, position, CTC, work experience, why need to change job, how you handle team etc..
Add your answer

Q1. Final account, banking, balance sheet, rules of account, P&L, team management, flexible Shifts, require CTC, all work experience etc...
Add your answer