Wipro Mts Consultant 3 Interview Questions and Answers

Q1. Nth higest salary query in sql
Add your answer
Q2. Constraints
Add your answer
Q3. Delete drop truncate
Add your answer
Q4. Identity column
Add your answer
Q5. Ref and out
Add your answer
Q6. Polymorphism code
Add your answer
Q7. Inheritance, interface, abstract class,access modifiers, solid principles,design patterns
Add your answer
Q8. Remove duplicates from an array
Ans. 
Remove duplicates from an array of strings
• Create a Set to store unique elements

• Iterate through the array and add each element to the Set

• Convert the Set back to an array to get the unique elements
Answered by AI
Add your answer

Q1. Difference between display none, visibility hidden and opacity 0 in CSS
Ans. 
display none hides the element completely, visibility hidden hides the element but still takes up space, opacity 0 makes the element transparent.
• display none removes the element from the layout

• visibility hidden hides the element but it still occupies space

• opacity 0 makes the element transparent but still occupies space

• Example: display: none; visibility: hidden; opacity: 0;
Answered by AI
Add your answer
Q2. Write a polyfill for javascript method "filter"
Ans. 
Polyfill for JavaScript method 'filter'
• Create a function called 'filter' that takes a callback function as an argument

• Loop through the array and apply the callback function to each element

• If the callback function returns true, add the element to a new array and return it
Answered by AI
Add your answer
Q3. Explain ShadowDOM
Ans. 
Shadow DOM is a way to encapsulate the styling and structure of a web component, preventing styles from leaking out and clashing with the rest of the page.
• Shadow DOM allows for creating self-contained components with their own DOM tree and styling.

• It helps in preventing styles from the main document affecting the component and vice versa.

• Shadow DOM can be created using the 'attachShadow' method in JavaScript.

• It is comm...read more
Answered by AI
Add your answer
Q4. Explain Currying in Javascript
Ans. 
Currying is a technique in JavaScript where a function with multiple arguments is transformed into a sequence of functions, each taking a single argument.
• Currying allows you to create reusable functions with partial application of arguments.

• It helps in creating more flexible and composable functions.

• Example: const add = (a) => (b) => a + b; const add5 = add(5); console.log(add5(3)); // Output: 8
Answered by AI
Add your answer
Q5. What is Event Deligation in javascript
Ans. 
Event delegation in JavaScript is a technique where a single event listener is attached to a parent element to handle events for multiple child elements.
• Event delegation helps improve performance by reducing the number of event listeners.

• It is useful for dynamically created elements or elements with similar behavior.

• Event delegation works by utilizing event bubbling, where events on child elements bubble up to the pare
Answered by AI
Add your answer

Q1. What Is difference between SAP ERP AND S/4 HANA
Ans. 
SAP ERP is the traditional enterprise resource planning software, while S/4 HANA is the next-generation ERP suite built on the SAP HANA platform.
• SAP ERP is based on traditional on-premise architecture, while S/4 HANA is designed for cloud deployment.

• SAP ERP uses a row-based database structure, while S/4 HANA utilizes an in-memory columnar database for faster data processing.

• SAP ERP requires separate systems for transac...read more
Answered by AI
Add your answer
Q2. What are the steps for implementation in SAP
Ans. 
Implementation steps in SAP involve planning, configuration, testing, training, and deployment.
• 1. Planning phase involves defining project scope, objectives, and timeline.

• 2. Configuration phase includes setting up SAP modules according to business requirements.

• 3. Testing phase ensures that the system functions correctly and meets user needs.

• 4. Training phase involves educating users on how to use the SAP system effecti...read more
Answered by AI
Add your answer
Q3. What is RICEF? explain
Ans. 
RICEF is a prioritization framework used in project management to rank tasks based on their impact and effort required.
• RICEF stands for Reach, Impact, Confidence, and Effort.

• Reach refers to the number of people affected by the task.

• Impact is the potential positive outcome of the task.

• Confidence is how sure you are about the estimates for Reach and Impact.

• Effort is the amount of time and resources needed to complete the...read more
Answered by AI
Add your answer
Q4. Have you worked with APP? EXPLAIN THE STEPS
Ans. 
Yes, I have worked with APP. The steps involve designing, developing, testing, and deploying the application.
• Design the user interface and functionality of the APP

• Develop the APP using programming languages like Java, Swift, or React Native

• Test the APP for bugs and errors

• Deploy the APP to app stores or internal servers for users to access
Answered by AI
Add your answer
Q5. How would you configure material?
Ans. 
Material can be configured by adjusting its properties and parameters to meet specific requirements.
• Identify the specific requirements for the material

• Adjust properties such as density, strength, and flexibility

• Consider parameters like temperature resistance and chemical compatibility

• Test the configured material to ensure it meets the desired specifications
Answered by AI
Add your answer
Q6. What is your role in your current company
Ans. 
I am responsible for managing client relationships, providing strategic advice, and overseeing project implementation.
• Managing client relationships

• Providing strategic advice

• Overseeing project implementation
Answered by AI
Add your answer

Q1. P2P Cycle, Special procurement processes, accounting entries
Add your answer
Q2. Idoc questions, pricing procedure,Stock transfer order, Change request, Movement types
Add your answer

Q1. Project related questions , scenario based questions
Add your answer
Q2. Project related questions, scenario based questions
Add your answer

I have three questions: 1. How to handle null values? 2. What are ranking functions? 3. Can you explain self joins?

Q1. Project description
Add your answer
Q2. Tools used
Ans. 
I primarily use tools such as Microsoft Excel, PowerPoint, and Tableau for data analysis and visualization.
• Microsoft Excel for data manipulation and analysis

• PowerPoint for creating presentations

• Tableau for data visualization
Answered by AI
Add your answer

Voice assesment,which will be evaluated by ai

Q1. Introduce yourself
Add your answer
Q2. Basic dsa question on printing pattern
Add your answer

Q1. Your experience in Manufacturing
Ans. 
I have over 10 years of experience in manufacturing, specializing in lean production and process optimization.
• Implemented lean manufacturing principles to reduce waste and improve efficiency

• Led cross-functional teams to streamline production processes

• Utilized Six Sigma methodologies to identify and solve quality issues

• Managed production schedules and inventory levels to meet customer demand

• Implemented automation and ro
Answered by AI
Add your answer
Q2. What is the complex integration you did?
Ans. 
I led a complex integration project between two large financial institutions to streamline their data sharing processes.
• Designed a custom API to facilitate real-time data exchange between the systems

• Implemented data mapping and transformation logic to ensure compatibility between the different data formats

• Worked closely with both technical teams to troubleshoot and resolve integration issues

• Developed a comprehensive te...read more
Answered by AI
Add your answer