AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Olvy Technologies Interview Questions and Answers
Olvy Technologies Interview Experiences
2 interviews found
Anonymous
(3 Questions)
- Q1. Execution of SQL query include joins too
- Ans.
Yes, execution of SQL query can include joins to combine data from multiple tables.
Joins are used to combine rows from two or more tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q2. Find row_number , rank and dense rank on give table
- Ans.
Row_number, rank, and dense rank functions are used to assign a unique number to each row in a result set based on specified criteria.
Use ROW_NUMBER() to assign a unique sequential integer to each row in the result set.
Use RANK() to assign a unique rank to each row based on the specified ordering.
Use DENSE_RANK() to assign a unique rank to each row without any gaps in the ranking.
- Q3. Give two table what will happen after inner join, left join and right join
- Ans.
Inner join returns only the rows that have matching values in both tables, left join returns all rows from the left table and the matched rows from the right table, right join returns all rows from the right table and the matched rows from the left table.
Inner join: Only rows with matching values in both tables are returned
Left join: All rows from the left table and matched rows from the right table are returned
Right j...
Skills evaluated in this interview
Production Analyst Interview Questions asked at other Companies
Selected
I applied via Wellfound and was interviewed in Jul 2024. There were 3 interview rounds.
(2 Questions)
- Q1. A brief introduction about yourself
- Ans.
I am a software engineer with 5 years of experience in developing web applications using Java, Spring, and Angular.
5 years of experience in software development
Proficient in Java, Spring, and Angular
Strong problem-solving skills
- Q2. Tell me about your technical background
- Ans.
I have a strong technical background with a degree in Computer Science and experience in software development.
Degree in Computer Science
Proficient in programming languages such as Java, Python, and C++
Experience in software development projects
Familiarity with databases and web development technologies
A front end project to handle large amount of data in frontend
(2 Questions)
- Q1. A practical question to implement in frontend
- Q2. About store manaagement
Software Engineer Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
Selected
I was interviewed in Jan 2025.
(2 Questions)
- Q1. Sale price on on day
- Q2. Start working
Interview Preparation Tips
Key points to remember:
Prioritize networking:
Utilize your network to connect with people in the industry, attend industry events, and leverage platforms like LinkedIn to build relationships with potential hiring managers.
Tailor your resume:
Include relevant sales keywords throughout your resume to catch the attention of recruiters and ensure your experience aligns with the job description.
Practice your sales pitch:
Prepare compelling stories from your past experiences to demonstrate your ability to close deals, overcome objections, and build rapport during interviews.
Follow up consistently:
After submitting applications, send personalized follow-up emails to maintain engagement with potential employers.
Research companies:
Actively monitor companies you're interested in by following their social media and news to stay informed about potential openings.
Highlight transferable skills:
Even if you lack direct sales experience, emphasize skills like communication, persuasion, relationship building, and problem-solving that translate well to a sales role.
Ask insightful questions:
During interviews, demonstrate your knowledge of the company and role by asking thoughtful questions that show your genuine interest.
Be enthusiastic and confident:
Convey a positive attitude and express your passion for sales to make a strong impression on potential employers.
I was interviewed in Feb 2025.
(5 Questions)
- Q1. Can you provide information about yourself and the projects you have worked on?
- Q2. What is the Re-Framework, and how do the Dispatcher, Performer, and DataTable transaction approaches function in UiPath?
- Q3. What is the difference between an execute query and an execute non-query?
- Q4. What is the difference between a switch statement and an if-else statement?
- Q5. Datatable how to use it in Uipath, what is a connection string and how we can create that?
Selected
I was interviewed in Jan 2025.
The exam consists of seven sections, and the cutoff score is quite high; it is essential to complete the exam thoroughly.
(5 Questions)
- Q1. Can you tell me about yourself?
- Q2. Can you provide details about your internship experience?
- Q3. Given a puzzle to solve
- Q4. What can you tell me about your major projects?
- Q5. What is the latest news you have heard regarding technology?
- Ans.
The latest news I heard regarding technology is the release of the new iPhone 13 with improved camera features.
Apple recently announced the release of the iPhone 13 series with upgraded camera capabilities.
The new iPhone 13 models come with improved low-light performance and cinematic mode for videos.
Apple also introduced the A15 Bionic chip for enhanced performance and battery life.
Interview Preparation Tips
I was interviewed in Feb 2025.
(3 Questions)
- Q1. Tell me about yourself
- Q2. Expected CTC
- Q3. Why you left your previous company (Negative answers should be avoided)
(3 Questions)
- Q1. Questions based on the concepts of payroll
- Q2. Expected CTC
- Q3. Discussion regards to Shift timings, Cab facility, Annual leaves, Variable bonus, Relocate bonus.
(1 Question)
- Q1. Regards to Payroll questions on what I did on daily basis.
Selected
(5 Questions)
- Q1. Tell me about yourself
- Q2. What is the product conference customer
- Q3. What is the time management
- Q4. What is the customer dealing
- Q5. What is the product and service the opportunity this customer
Interview Preparation Tips
I was interviewed in Jan 2025.
(2 Questions)
- Q1. Give work freedom to employee
- Q2. No need to search each and every transactions
(2 Questions)
- Q1. Trust on employee
- Q2. Maintain minimum job curtsy
(2 Questions)
- Q1. Salary hike and position hike is Mandatory
- Q2. Collect exact feedback from employee
Interview Preparation Tips
I was interviewed in Sep 2024.
An aptitude test evaluates an individual's potential to excel in a specific area by assessing their strengths and weaknesses in particular abilities.
An assessment that measures an individual's inherent abilities and potential for success in a specific activity.
A coding test is a programming assessment designed to evaluate a candidate's coding skills. It is a standard component of the technical hiring process for software developers and programmers.
Assessment that evaluates a candidate's coding skills
Group discussion (GD) topics for interviews may cover areas such as business, social issues, and current affairs. GDs serve to evaluate a candidate's communication, leadership, and teamwork abilities.
Discussion assignments are prompts that your teacher may assign to you. By participating in these discussions, you can reflect on your learning, share ideas and opinions, or ask and answer questions. Discussions may require you to respond to individual questions or provide multiple responses to an ongoing conversation.
Interview Preparation Tips
Research
Know your goals: Consider your values, strengths, and ideal work environment.
Research the company: Anticipate common interview questions.
Prepare your resume
Tailor your resume: Customize your resume for each job application.
Highlight your skills: Highlight how your skills and experience match the job description.
Use keywords: Use relevant keywords in your resume and cover letter.
Prepare for interviews
Prepare your answers: Use the STAR method to prepare your answers.
Research the company: Anticipate common interview questions.
Network
Expand your professional network: You may find that more people can recommend you to a new position.
Use your professional network: You can use your network for career advice.
Other tips Don't limit your search to online resources, Optimize your LinkedIn profile, Use several job-search websites, Keep your resume up-to-date, and Develop your interview skills.
I was interviewed in Jan 2025.
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
(6 Questions)
- Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
- Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
- Ans.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
- Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
- Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
- Ans.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
- Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
- Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Interview Preparation Tips
Olvy Technologies Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Executive Interview Questions
- Team Lead Interview Questions
- Design Engineer Interview Questions
- Senior Associate Interview Questions
- Senior Engineer Interview Questions
- Consultant Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Data Analyst Interview Questions
- Show more
Olvy Technologies Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Olvy Technologies Reviews and Ratings
based on 3 reviews
Rating in categories
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Olvy Technologies Interview Questions
