Wipro pvt interview experience Real time questions & tips from candidates to crack your interview
Specialist Programmer
Wipro pvt
2 rounds | 2 Coding
problems
Selected Interview preparation journey
Preparation
Duration: 2 months
Topics: Data Structures, My SQL, OOPS, Algorithms
Tip 1: Don't try to cover everything, go with one or two skills to master it and have some general knowledge about others.
Tip 2: Do a project along with everything you learn. Practical exposure is what organizations demand.
Tip 3: Do not ignore soft skills at all. Many underestimate the magic of soft skills in getting selected over others.
Application process
Where: Other
Eligibility: Minimum 55% in college with no current backlogs
Tip 1: Resume should not be more than 1 or 2 pages. All information should be provided in the form of bullets and numbered in a precise manner and not just in long paragraphs with detailing for every aspect.
Tip 2: The resume should be easily readable with formal fonts and design, and should not contain false information.
Interview rounds
01
Round
Medium
Online Coding Interview
Duration90 minutes
Interview date25 Feb 2021
Coding problem0
It was an hour-long online test that can be done between 10 am to 5 pm anytime on the mentioned day. There were three sections where first two were elimination sections.
02
Round
Easy
Video Call
Duration30 minutes
Interview date3 Mar 2021
Coding problem2
It was a video interview where some database questions were asked and problems were given to solve. The questions were pretty simple and required database logic to be applied.
1. DBMS based questions
1. Write a query where you have to show the joining of three tables using joins.
2. Write a query where the difference between group by and order by is depicted.
3. What are DML, DCL, and DDL. Explain with examples.
4. What is the difference between SQL, MY SQL, and PL SQL.
5. Write a query by using LIMIT.
Problem approach
Tip 1: Theoretical questions can be answered with examples
Tip 2: The query must be as short and precise as possible.
Tip 3: SQL queries and database knowledge is relevant to learning.
2. SQL based question
Ques - Write a SQL query to find the second highest salary from a table.
Problem approach
I used the concept of subquery in this.
To find the highest salary in the table the query is:-
SELECT MAX(SALARY) FROM Table_Name;
Then, to find the second highest salary, I nested the above query into another query as:-
SELECT MAX(SALARY) FROM Table_Name WHERE SALARY < (SELECT MAX(SALARY) FROM Table_Name);
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
How do you remove whitespace from the start of a string?
Choose another skill to practice
Similar interview experiences
Software Engineer
3 rounds | 5 problems
Interviewed by Wipro pvt
Selected 
1949 views
0 comments
0 upvotes
Software Engineer Trainee
3 rounds | 4 problems
Interviewed by Wipro pvt
Selected 2704 views
0 comments
0 upvotes
Software Engineer
4 rounds | 4 problems
Interviewed by Wipro pvt
Selected 2701 views
0 comments
0 upvotes
SDE - 1
3 rounds | 12 problems
Interviewed by Wipro pvt
Selected 0 views
0 comments
0 upvotes