OxfordCaps India Interview Questions and Answers

I was attended for technical f2f round for Android app developer, they asked to develop sample app with large json parsing in grid view. It's good and nice.

Q1. Once you successfully implemented coding, they will take technical f2f round. It will mainly in all topics of android.
Add your answer

Q1. Javascript based questions
Add your answer

Q1. Javascript and HTML/CSS based questions
Add your answer

Q1. Basic info about the tech stack I've worked on and my previous jobs.
Add your answer

Q1. React Native problem related to Flatlists and Array
Add your answer

Q1. Interviewer never joined the call. The interview kept postponing to another date.
Add your answer

Q1. Tell me about yourself and how you relevant for this job opportunity ? As i mentioned in my resume i completed my graduation in xyz for xy institute with x % (mention this only u score good) then your pos...read more
Add your answer
Q2. Tell me any situation in which you applied those skills which you mentioned in resume like team player and solution oriented.
Ans. For that relate in recent experience form past company/ internship be calm and act smartly with presence of mind or do prepared for this Q in advance.
Answered Anonymously
Add your answer

Q1. 2 LC medium level ds and algo questions.
Add your answer
Q2. Design scoreboard API.
Ans. 
Design an API for a scoreboard.
• Define endpoints for creating, updating, and retrieving scores.

• Include authentication and authorization mechanisms.

• Consider implementing rate limiting to prevent abuse.

• Use HTTP status codes to indicate success or failure.

• Ensure the API is scalable and can handle high traffic.

• Provide documentation for developers to use the API.
Answered by AI
Add your answer

Q1. SQL queries using group by and windows function.
Ans. 
Group by and window functions are used in SQL queries to aggregate data and perform calculations on subsets of data.
• Group by is used to group data based on one or more columns and perform aggregate functions on each group.

• Window functions are used to perform calculations on a subset of data within a group, without affecting the grouping of the data.

• Examples of aggregate functions include SUM, AVG, COUNT, MAX, and MIN.

• E...read more
Answered by AI
View 1 more answer
Q2. Excel index match. Python loops and function
Add your answer

Q1. Business understanding, guesstimates etc.
Add your answer

Q1. Tell me about your previous job profile
Add your answer
Q2. How can you generate the leads
Ans. 
Generating leads requires a combination of strategies such as networking, content marketing, and targeted advertising.
• Networking with industry professionals and attending events

• Creating valuable content to attract potential clients

• Utilizing social media platforms to reach a wider audience

• Running targeted ads on platforms like Google and Facebook

• Offering referral incentives to current clients

• Collaborating with complemen
Answered by AI
Add your answer
Q3. Sundays are working! How will you manage?
Add your answer