Filter interviews by
I applied via LinkedIn and was interviewed before Nov 2023. There was 1 interview round.
Stored procedures and functions are precompiled SQL queries that can be stored and executed on the database server.
Stored procedures are a set of SQL statements that are stored on the database server and can be called by applications.
Functions are similar to stored procedures but return a value.
Stored procedures can accept input parameters and return multiple result sets, while functions can only return a single value.
...
Trigger is a special type of stored procedure that automatically executes when an event occurs in a database. Index is a data structure that improves the speed of data retrieval operations on a database table.
Trigger is used to maintain the integrity of the database by enforcing business rules or cascading changes.
Indexes are used to quickly locate data without having to search every row in a database table.
Examples: A...
Commit and Rollback are database transactions used to save or discard changes made to the database.
Commit is used to save the changes made in a transaction to the database permanently.
Rollback is used to discard the changes made in a transaction and revert the database to its previous state.
Commit makes the changes permanent while Rollback cancels the changes.
Example: If a transaction involves updating multiple records...
Join is used to combine rows from two or more tables based on a related column between them.
Types of Joins: Inner Join, Left Join, Right Join, Full Join, Cross Join
Inner Join: Returns rows when there is at least one match 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
Full Jo...
Union and Intersection are set operations in mathematics. Union combines all elements from two sets, while Intersection finds common elements.
Union combines all elements from two sets into a single set
Intersection finds common elements between two sets
Example: Set A = {1, 2, 3} and Set B = {3, 4, 5}. Union of A and B is {1, 2, 3, 4, 5}. Intersection of A and B is {3}
The new row will start from 1 after truncating a table.
Truncating a table removes all rows from the table, resetting the row count to 1.
The next row inserted after truncation will have an ID of 1.
Truncating a table does not reset the auto-increment value of the primary key column.
Top trending discussions
I was interviewed in Feb 2025.
I was interviewed in Feb 2025.
If you're asked, "Can you provide details for the assessment?", the answer depends on the context.
For a Job Interview Assessment at Wipro:
"The assessment typically includes sections on aptitude (quantitative, logical reasoning, verbal ability), coding (for technical roles), and sometimes an essay or business communication test. The coding section usually involves problem-solving in languages like Python, Java, or C++. The difficulty level varies based on the role, and candidates are evaluated on accuracy, efficiency, and problem-solving skills."
For an Employee Performance Assessment:
"The assessment process at Wipro evaluates employees based on key performance indicators (KPIs), project contributions, skill development, and feedback from peers and managers. It helps in career growth, identifying training needs, and aligning with organizational goals."
If you need specific details about an assessment you are preparing for, let me know!
If you're asked, "Details of the coding?" in the context of a Wipro assessment or interview, here’s a structured response:
For Wipro’s Hiring Assessment (Elite NTH, Turbo, etc.):
"The coding section typically includes two to three problems that test algorithmic thinking, data structures, and problem-solving skills. The difficulty ranges from easy to medium-hard, covering topics such as arrays, strings, recursion, dynamic programming, and sorting algorithms. Candidates are expected to write optimized and error-free code in languages like Python, Java, C, or C++. The evaluation is based on correctness, efficiency, and execution time."
For Wipro’s Internal Coding Assessments or Training:
"Wipro conducts periodic coding assessments to upskill employees. These may include competitive programming challenges, hackathons, and hands-on projects covering real-world problem-solving, automation, and software development best practices."
Would you like specific coding questions or topics to prepare for?
The Aptitude Test in Wipro's hiring process assesses a candidate's problem-solving abilities, logical reasoning, and numerical proficiency. While specific answers depend on the given test, the assessment typically includes:
1. Quantitative Aptitude:
Topics: Arithmetic (percentages, profit & loss, time & work), algebra, number series, and probability.
Approach: Focus on accuracy and time management, as these sections often have a time limit.
2. Logical Reasoning:
Topics: Patterns, seating arrangements, syllogisms, blood relations, and data interpretation.
Approach: Use logical deduction and elimination techniques to enhance efficiency.
3. Verbal Ability:
Topics: Reading comprehension, sentence correction, synonyms/antonyms, and para jumbles.
Approach: Improve vocabulary and practice grammar rules for better accuracy.
As the specific test questions vary, preparation through mock tests and previous Wipro placement papers is advisable. Would you like recommendations for resources to practice?
I was interviewed in Jan 2025.
I was interviewed in Feb 2025.
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.
I completed a 6-month internship at a tech company, where I worked on network infrastructure projects.
Assisted in setting up and configuring network devices such as routers and switches
Troubleshooted network issues and implemented solutions
Collaborated with team members on various IT projects
Participated in meetings with clients to discuss project requirements
I have worked on various major projects including designing and implementing network infrastructure, developing automation scripts, and optimizing system performance.
Designed and implemented a new network infrastructure for a large company, improving network speed and reliability
Developed automation scripts to streamline system monitoring and maintenance tasks, saving time and reducing errors
Optimized system performanc...
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.
I was interviewed in Feb 2025.
I was interviewed in Jan 2025.
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.
based on 1 interview
Interview experience
based on 9 reviews
Rating in categories
Jr. Data Scientist
7
salaries
| ₹3.2 L/yr - ₹9 L/yr |
Software Developer
5
salaries
| ₹3.2 L/yr - ₹9 L/yr |
Data Analyst
5
salaries
| ₹2 L/yr - ₹7.2 L/yr |
Mobile Developer
4
salaries
| ₹4 L/yr - ₹5.4 L/yr |
Business Operations Associate
3
salaries
| ₹2.5 L/yr - ₹2.5 L/yr |
Infosys
TCS
Wipro
HCLTech