Ocean Palms ARC Analyst Interview Questions and Answers

Q1. What is the pivot table in Excel
Ans. 
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
• Allows users to summarize and analyze large datasets

• Can easily reorganize data by dragging and dropping fields

• Provides options to calculate sums, averages, counts, etc. for data

• Helps in creating interactive reports and charts

• Useful for identifying trends and patterns in data
Answered by AI
Add your answer
Q2. A pivot table is used to summarize...........etc.
Add your answer

Q1. Case study of shareride
Add your answer
Q2. Case study of amusement park
Add your answer
Q3. Case study of airplane
Add your answer

Bq questions like tell me a time

Onw beginner level coding challenge

Create postman collection for a given scenario using provided API document

Q1. Scenario based questions
Add your answer
Q2. Project experience
Ans. 
I have 3 years of experience working on various software projects as a Quality Analyst.
• Led testing efforts for multiple software releases

• Created and executed test cases to ensure product quality

• Collaborated with cross-functional teams to identify and resolve defects

• Utilized automation tools like Selenium for regression testing

• Participated in Agile ceremonies such as sprint planning and retrospectives
Answered by AI
Add your answer

Q1. Salary expectation
Add your answer
Q2. My previous roles
Add your answer

Quantitative aptitude, reasoning with time limit

Excel tasks were given. There were total 2 tasks related to excel. 1st one was basic and second one was moderate level of difficulty. SQL queries were basic.

Q1. Questions were from the Assignment only. Approach to the problems.
Add your answer

Q1. Basic HR questions like strength and weakness, why you want to join this organization
Add your answer

Q1. What is difference between bonds and equity
Ans. 
Bonds are debt instruments issued by companies or governments, while equity represents ownership in a company.
• Bonds are loans made by investors to companies or governments, who promise to repay the principal amount with interest.

• Equity represents ownership in a company and gives shareholders the right to vote on company matters and receive a share of profits.

• Bonds have a fixed maturity date, while equity has no maturit...read more
Answered by AI
View 1 more answer

Q1. What is your strength and weekness
Add your answer

Q1. Media framework fundamentals, gstreamer
Add your answer
Q2. How you fix memory leak in framework
Ans. 
Memory leaks in frameworks can be fixed by identifying and removing the root cause of the leak.
• Identify the source of the leak using memory profiling tools

• Analyze the code to find the root cause of the leak

• Fix the code by releasing unused memory or optimizing memory usage

• Test the framework thoroughly to ensure the leak has been fixed
Answered by AI
Add your answer
Q3. Design framework for media player
Ans. 
A media player design framework should prioritize user experience, ease of use, and accessibility.
• Include intuitive controls for playback, volume, and playlist management

• Ensure compatibility with a variety of media formats

• Consider incorporating features such as equalizer settings and visualizations

• Design for accessibility with options for closed captioning and audio descriptions

• Prioritize a clean and visually appealing
Answered by AI
Add your answer

Was good...and easy with maths problems.

Coding with your suited programming language.

Data Coding, 1hr, series of questions in excel