WINSMART Interview Questions and Answers

Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order. Merge sort is a divide and conquer algorithm that divides the input array into two halves, recursively sorts the two halves, and then merges the sorted halves.

• Bubble sort has a time complexity of O(n^2) in worst case scenario, while merge sort has a time complexity of O(n log n).

• Bubble sort is not efficient for large datas...read more

A virtual function is a function in a base class that is overridden by a derived class, allowing polymorphic behavior.

• Virtual functions are used in object-oriented programming to achieve runtime polymorphism.

• They are declared in the base class with the 'virtual' keyword and can be overridden in derived classes.

• When a virtual function is called through a base class pointer or reference, the appropriate derived class function is executed.

• Virtual functions enable dynamic binding...read more

Operator overloading is the ability to redefine operators for user-defined types.

• Allows operators to be used with user-defined types

• Can simplify code and make it more readable

• Examples include overloading the + operator for string concatenation

Function overreading refers to the ability of a function to read beyond the end of an array.

• Function overreading can lead to security vulnerabilities and crashes.

• It can occur when a function does not properly check the bounds of an array before accessing its elements.

• For example, if an array has 10 elements and a function tries to access the 11th element, it may read data from an unintended memory location.

• This can be prevented by using safe programming practices such as boun...read more

Joins are used in databases to combine rows from two or more tables based on a related column between them.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL 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 JOIN returns rows when there is a match in one of...read more

The Like function is used in SQL to search for a specified pattern in a column.

• Used in SQL to search for a specified pattern in a column

• Can use wildcards like % and _ for pattern matching

• Example: SELECT * FROM table WHERE column LIKE 'abc%'

Group by is a clause in SQL used to arrange identical data into groups based on one or more columns.

• Group by is used in conjunction with aggregate functions like COUNT, SUM, AVG, etc.

• It is commonly used to summarize data and perform calculations on grouped data.

• For example, SELECT department, COUNT(employee_id) FROM employees GROUP BY department;