10+ Wipro Interview Questions and Answers

Use indexing, pagination, caching, and optimized queries to fetch large amounts of data quickly.

• Utilize indexing on database columns to speed up search queries.

• Implement pagination to limit the number of records fetched at once.

• Use caching mechanisms to store frequently accessed data and reduce database load.

• Optimize queries by selecting only necessary columns and avoiding unnecessary joins.

• Consider using asynchronous processing or parallel processing for fetching data in bat...read more

CORS allows web applications to make requests to a different domain than the one it originated from.

• CORS is enabled on the server side by setting the 'Access-Control-Allow-Origin' header to specify which domains are allowed to make requests.

• Options requests are sent by the browser to check if the server allows the actual request. The server should respond with the appropriate headers.

• CORS can be configured to allow specific HTTP methods and headers using the 'Access-Control-A...read more

Use a hashmap to store the frequency of each number in the array.

• Create a hashmap to store the frequency of each number in the array.

• Iterate through the array and update the frequency in the hashmap.

• Return the hashmap with the frequency of each number.

SQL query to retrieve duplicate email addresses from a table

• Use GROUP BY and HAVING clause to identify duplicates

• Select the email column and count the occurrences

• Filter the results to show only emails with count greater than 1

Protein is important for weight loss as it helps increase metabolism, reduce appetite, and preserve muscle mass. The recommended daily protein intake varies based on factors like age, gender, activity level, and goals.

• Protein helps increase metabolism by requiring more energy to digest compared to fats and carbs

• Protein reduces appetite by promoting feelings of fullness and satiety

• Protein preserves muscle mass during weight loss, preventing muscle loss and promoting fat loss

• Re...read more

The default session time in PHP is 24 minutes.

• Default session time in PHP is 24 minutes

• Session time can be changed using the 'session.gc_maxlifetime' directive in php.ini file

• Session time can also be set using the 'session_set_cookie_params()' function in PHP

Foods restricted for high creatinine patients include high-protein foods, processed foods, and foods high in sodium and potassium.

• Limit high-protein foods like red meat, poultry, and fish

• Avoid processed foods like canned soups and frozen meals

• Reduce intake of foods high in sodium like processed snacks and fast food

• Limit foods high in potassium like bananas, oranges, and potatoes

I have worked on projects involving customer segmentation, sales forecasting, and sentiment analysis using analytics.

• Customer segmentation: Used clustering algorithms to group customers based on their behavior and demographics.

• Sales forecasting: Utilized time series analysis to predict future sales trends and optimize inventory management.

• Sentiment analysis: Applied natural language processing techniques to analyze customer feedback and sentiment towards products or services.

HbA1c is a blood test that measures average blood sugar levels over the past 2-3 months.

• HbA1c stands for Hemoglobin A1c.

• It is used to diagnose diabetes and monitor blood sugar control in individuals with diabetes.

• A normal HbA1c level is below 5.7%, while a level of 6.5% or higher indicates diabetes.

• The test reflects average blood sugar levels over a longer period of time compared to daily glucose monitoring.

• Lowering HbA1c levels through diet, exercise, and medication can redu...read more