1000+ Intern Interview Questions and Answers

The cost of a disease includes opportunity cost, medical expenses, social and emotional cost.

• Opportunity cost refers to the potential income or productivity lost due to the disease.

• Medical expenses include the cost of treatments, medications, hospital stays, and doctor visits.

• Social cost includes the impact on relationships, social activities, and support systems.

• Emotional cost refers to the psychological impact, such as stress, anxiety, and depression.

• Examples of opportunity...read more

The probability that three ants at the corner of a triangle will never meet.

• The ants can move randomly in any direction.

• The probability depends on the shape and size of the triangle.

• The probability can be calculated using geometric probability or simulation.

• Assumptions need to be made about the ants' movement patterns.

The income statement shows a company's revenues and expenses, while the balance sheet shows its assets, liabilities, and equity.

• Income statement includes revenues, cost of goods sold, gross profit, operating expenses, net income, etc.

• Balance sheet includes assets (current and non-current), liabilities (current and non-current), and equity.

• Examples of items on income statement: sales revenue, salaries expense, rent expense, interest income, etc.

• Examples of items on balance she...read more

Generalization and Specialization are two important concepts in DBMS.

• Generalization is the process of combining two or more entities into a higher-level entity.

• Specialization is the process of dividing a higher-level entity into two or more lower-level entities.

• Generalization is a top-down approach while specialization is a bottom-up approach.

• Generalization is used to represent a group of entities that share common attributes and relationships.

• Specialization is used to repres...read more

Index hunting is the process of finding the best index for a query to improve its performance.

• Index hunting involves analyzing the query and the database schema to determine the most efficient index to use.

• It can involve creating new indexes or modifying existing ones.

• For example, if a query frequently searches for a specific column, creating an index on that column can significantly improve performance.

• Index hunting is an important part of database optimization and can great...read more

Data is fetched through RESTful APIs using Python requests library. Machine learning is used for predictive analysis.

• API data is retrieved using HTTP GET requests

• Python requests library is used to handle API requests and responses

• Data is parsed using JSON library

• Machine learning models are trained on historical data to predict future outcomes

• Scikit-learn library is used for machine learning tasks

The single screen cinema is facing losses due to internal cost issues.

• Revenue streams: ticket sales, concessions (food and beverages), advertising

• Cost streams: employee salaries, food vending expenses, maintenance costs

• Examples of revenue streams: ticket sales revenue, revenue from selling food and beverages, revenue from advertising partnerships

• Examples of cost streams: salaries of employees involved in food vending and maintenance, expenses for purchasing food and beverages...read more

To reduce setup cost of a hotel company, focus on optimizing procurement, outsourcing non-core activities, and utilizing technology.

• Optimize procurement by negotiating better deals with suppliers and using bulk purchasing

• Outsource non-core activities such as laundry, landscaping, and maintenance to reduce staffing costs

• Utilize technology to automate processes and reduce manual labor, such as implementing self-check-in kiosks

• Consider modular construction techniques to reduce c...read more

Online education system in India has great potential but needs improvement.

• Online education has become more popular due to the pandemic.

• There is a lack of infrastructure and resources for online education in rural areas.

• Online education can be more affordable and accessible than traditional education.

• There is a need for better quality control and accreditation for online courses.

• Online education can provide opportunities for upskilling and reskilling.

• Online education can be a...read more

The person should commit the changes to the database and refresh the view for others to see.

• Commit the changes to the database

• Refresh the view for others to see

• Ensure proper permissions are set for others to access the data

This is a set of questions related to finance and stock markets.

• NSE and BSE are the two major stock exchanges in India.

• Derivative market is a financial market where investors can trade in financial instruments such as futures, options, and swaps.

• Risk hedging techniques include diversification, options trading, and futures trading.

• FPO stands for Follow-on Public Offer, which is a process by which a company raises additional capital by issuing new shares to the public.

There are approximately 500 cars parked in the college parking lot.

• Approximately 500 cars are parked in the college parking lot.

• The parking lot has designated areas for staff, students, and visitors.

• Parking permits are required for students and staff to park on campus.

• There is a security team that monitors the parking lot for any unauthorized vehicles.

• During special events, additional parking arrangements are made to accommodate more vehicles.

Auctus offers customized solutions to clients with a focus on long-term sustainability and growth.

• Auctus takes a holistic approach to consulting, considering all aspects of a client's business

• Auctus emphasizes long-term sustainability and growth, rather than short-term fixes

• Auctus offers customized solutions tailored to each client's unique needs

• Auctus has a team of experienced consultants with diverse backgrounds and expertise

• Auctus values transparency and collaboration with...read more

The hair care industry in India is growing rapidly, with increasing demand for natural and organic products. Investment decision depends on company goals and market research.

• India's hair care industry is expected to reach $13.3 billion by 2025

• Growing demand for natural and organic products

• Strong competition from established brands like Dove, Pantene, and L'Oreal

• Opportunities for niche players in the market

• Investment decision should be based on company goals and market researc...read more

As a cement dealer, important factors to consider include brand reputation, quality of product, pricing, delivery time, and customer service.

• Brand reputation

• Quality of product

• Pricing

• Delivery time

• Customer service

Yes, I am familiar with both Power BI and Tableau.

• I have used Power BI and Tableau extensively in my previous job.

• I am proficient in creating interactive dashboards and visualizations using both tools.

• I have experience in connecting to various data sources and transforming data for analysis.

• I am comfortable with creating calculated fields and measures to derive insights from data.

• I have also worked with Power BI and Tableau APIs to automate report generation and distribution.

There are approximately 10 million tennis players in India. Assuming each player has 3 tennis balls, there are around 30 million tennis balls in India.

• Estimate the number of tennis players in India

• Assume each player has 3 tennis balls on average

• Multiply the number of players by 3 to get an estimate of the total number of tennis balls in India

Pharma and Healthcare are distinct business functions with different focuses and objectives.

• Pharma primarily deals with the research, development, and production of drugs and medications.

• Healthcare encompasses a broader range of services including medical treatment, diagnostics, preventive care, and patient care.

• Pharma companies focus on developing and marketing pharmaceutical products to healthcare providers and consumers.

• Healthcare organizations provide direct patient care,...read more

Implement appointment scheduling, optimize patient flow, and increase staff efficiency.

• Implement an appointment scheduling system to reduce walk-ins and overcrowding.

• Optimize patient flow by streamlining check-in and triage processes.

• Increase staff efficiency by cross-training and delegating tasks.

• Use technology to automate administrative tasks and reduce paperwork.

• Monitor and analyze data to identify bottlenecks and areas for improvement.

Reverse a linked list in pairs of three.

• Create a function that takes the head of the linked list as input.

• Traverse the linked list in pairs of three and reverse each pair.

• Update the head of the linked list to the new head after reversing each pair.

• Return the new head of the linked list.

Both are important, but the person representing the product can make or break its success.

• The person representing the product is the face of the company and can influence customer perception.

• A great product with a poor representative may not sell well, while a mediocre product with a great representative may sell better.

• The representative should have knowledge and passion for the product to effectively communicate its value.

• In some cases, the representative may even be more i...read more

Commoditizing perfume sold at Jaipur City Palace used by the royal family.

• Create a brand around the perfume with a unique name and packaging

• Offer different sizes and variations of the perfume

• Sell the perfume online and in retail stores

• Collaborate with popular influencers to promote the perfume

• Offer limited edition versions of the perfume

• Create a loyalty program for customers

• Offer discounts and promotions to attract customers

• Use social media to create buzz and awareness about ...read more

Increasing the number of bank accounts of a public sector bank

• Offer attractive interest rates and benefits to customers

• Expand the bank's reach by opening new branches in untapped areas

• Partner with businesses and offer exclusive banking services to their employees

• Launch targeted marketing campaigns to attract new customers

• Provide excellent customer service to retain existing customers

Fill factor is the percentage of space on each leaf-level page to be filled with data.

• It determines how much data is written to a page during index creation or rebuild.

• It can improve performance by reducing page splits and fragmentation.

• The default value is 0, which means the page is filled to 100%.

• A fill factor of 80 means the page is filled to 80% and 20% is left empty for future growth.

Fermentation is a metabolic process that converts sugar to acids, gases, or alcohol. Doubling time is the time taken for a population to double. Microbial growth curve is a graph that shows the growth of microorganisms over time. Filtration is a process of separating solids from liquids or gases using a filter medium.

• Fermentation is used in the production of beer, wine, and bread.

• Doubling time varies depending on the species of bacteria and the environmental conditions.

• Microb...read more

Inventory management involves overseeing the flow of goods from manufacturers to warehouses to retailers, ensuring optimal levels are maintained.

• Tracking inventory levels in real-time

• Forecasting demand to prevent stockouts or overstocking

• Implementing efficient ordering and replenishment processes

• Utilizing technology such as barcode scanners or inventory management software

• Analyzing data to optimize inventory turnover and reduce carrying costs

Suggest inventory management solutions for a fruits and vegetables retailer.

• Analyze sales data to determine popular items and adjust inventory levels accordingly

• Implement a first-in, first-out (FIFO) system to ensure freshness of produce

• Use technology such as barcode scanning and automated ordering to streamline inventory management

• Consider partnering with local farmers to reduce transportation costs and ensure fresh produce

• Train staff on proper inventory management technique...read more

Valuation of revenue streams for an Indian Super League Team

• Identify and analyze the different revenue streams of the Indian Super League team

• Quantify the financial value of each revenue stream

• Consider factors such as ticket sales, sponsorship deals, merchandise sales, broadcasting rights, etc.

• Use financial models and projections to estimate the potential growth and profitability of each revenue stream

• Compare the valuation of the revenue streams to determine their relative im...read more

Healthcare and Pharmaceuticals markets differ in terms of products, regulations, and target customers.

• Healthcare market focuses on providing medical services and care to patients.

• Pharmaceutical market involves the development, production, and sale of drugs and medications.

• Healthcare market includes hospitals, clinics, and healthcare providers.

• Pharmaceutical market includes pharmaceutical companies and drug manufacturers.

• Healthcare market is regulated by government bodies to e...read more

Various tests are conducted on cement, concrete, aggregates, and bitumen to ensure their quality and durability.

• Cement tests include fineness, setting time, compressive strength, and soundness tests.

• Concrete tests include slump test, compressive strength test, and water absorption test.

• Aggregates tests include sieve analysis, specific gravity, and water absorption test.

• Bitumen tests include penetration test, softening point test, and ductility test.

• All these tests are importa...read more

SkinCareIndiaPvt.Ltd should focus on product innovation, competitive pricing, and effective marketing strategies.

• Invest in research and development to create innovative products

• Offer competitive pricing to attract price-sensitive customers

• Implement effective marketing strategies to increase brand awareness and customer loyalty

• Expand product line to cater to different customer needs

• Partner with influencers and beauty bloggers to promote products

• Offer discounts and promotions t...read more

Breastfeeding has numerous benefits for both mother and baby, including improved immunity, bonding, and long-term health outcomes.

• Breast milk provides essential nutrients and antibodies that help protect babies from infections and diseases.

• Breastfeeding promotes bonding between mother and baby through skin-to-skin contact and eye contact.

• Mothers who breastfeed have a reduced risk of certain health conditions such as breast and ovarian cancer.

• Breastfeeding can help with postpa...read more

The tractor manufacturing company's declining share is due to lack of product diversification and limited market reach.

• The company needs to expand its product line to cater to different customer needs.

• The company should explore new markets and increase its presence in existing ones.

• The company can consider partnerships or collaborations to enhance its manufacturing capabilities.

• The company should focus on improving its marketing and branding strategies to increase visibility ...read more

Object is an instance of a class while class is a blueprint for creating objects.

• Class is a template or blueprint for creating objects

• Object is an instance of a class

• Class defines the properties and methods that an object will have

• Object is created from a class using the 'new' keyword

• Multiple objects can be created from a single class

Static analysis is done without executing the code while dynamic analysis is done during code execution.

• Static analysis is done by analyzing the code without executing it

• Dynamic analysis is done by analyzing the code during its execution

• Static analysis is usually done before the code is compiled or executed

• Dynamic analysis is usually done after the code is compiled or executed

• Static analysis can detect potential issues in the code

• Dynamic analysis can detect actual issues in t...read more

A significant portion of the population in India has health insurance, and they are willing to use it for various medical cases.

• A large number of people in India have health insurance coverage.

• They are willing to use their health insurance for hospitalization expenses.

• Health insurance is also used for outpatient treatments and consultations.

• People often utilize health insurance for surgeries and medical procedures.

• Insurance coverage is commonly used for medication and prescri...read more

Yes, I believe consulting is in line with my career aspirations.

• I enjoy problem-solving and working with clients to find solutions

• I have experience in consulting through internships and coursework

• I am excited about the opportunity to work with a variety of industries and projects

• I am willing to put in the effort and dedication required to succeed in a challenging field

Test cases for login

• Verify successful login with valid credentials

• Verify error message with invalid credentials

• Verify password field is masked

• Verify session timeout after inactivity

• Verify login page is accessible from any page

• Verify login page is not accessible after logout

Find the missing number from 1 million random numbers.

• Calculate the sum of all numbers from 1 to 1 million using the formula n(n+1)/2

• Calculate the sum of all the given numbers

• Subtract the sum of given numbers from the sum of all numbers to get the missing number

My favorite OOPS concept is inheritance.

• Inheritance allows a class to inherit properties and methods from another class.

• It promotes code reusability and saves time and effort in coding.

• There are different types of inheritance such as single, multiple, multilevel, and hierarchical.

• For example, a class 'Car' can inherit properties and methods from a class 'Vehicle'.

Pharmaceutical companies in India face challenges in sales and marketing compared to abroad.

• Stringent regulations and complex approval processes in India

• Intense competition from local and international pharmaceutical companies

• Price control policies and government regulations affecting profit margins

• Diverse and fragmented market with varying healthcare infrastructure

• Lack of awareness and trust in generic drugs

• Counterfeit drugs and illegal parallel imports

• Language and cultural ...read more

Guesstimate on the number of commerce graduates passing out from Chennai annually.

• Approximately 20% of the total students in Chennai opt for commerce courses.

• Chennai has around 50 colleges offering commerce courses.

• Assuming an average of 200 students per college, around 10,000 students pass out as commerce graduates every year.

To isolate an organism from a mixed culture, one can use culturing techniques such as pour plates or spread plates and perform Gram staining.

• In pour plate technique, a diluted sample is mixed with agar and poured into a petri dish. In spread plate technique, a small amount of sample is spread over the surface of agar in a petri dish.

• After incubation, individual colonies can be picked and subcultured for further analysis.

• Gram staining can be used to differentiate between Gram-...read more

Enthalpy is the heat content of a system, entropy is the measure of disorder, and latent heat is the heat absorbed or released during a phase change.

• Enthalpy is a thermodynamic property that measures the heat content of a system at constant pressure.

• Entropy is a measure of the degree of disorder or randomness in a system.

• Latent heat is the heat absorbed or released during a phase change, such as melting or boiling.

• Enthalpy and entropy are related by the Gibbs free energy equa...read more

Designing of a component before manufacturing helps in identifying and resolving potential issues, reducing costs and improving efficiency.

• Designing helps in identifying potential issues and resolving them before manufacturing.

• It helps in reducing costs by identifying and rectifying errors early on.

• Designing also helps in improving efficiency by optimizing the component's design.

• It ensures that the final product meets the desired specifications and requirements.

• Designing also...read more

Neonatal jaundice is a condition where a newborn's skin and eyes appear yellow due to high levels of bilirubin in the blood.

• Neonatal jaundice is common in newborns and usually resolves on its own within a few days to weeks.

• To prevent neonatal jaundice, ensuring adequate feeding to prevent dehydration is important.

• Phototherapy may be used in severe cases to help lower bilirubin levels.

• Monitoring bilirubin levels through blood tests can help in early detection and management of...read more