20+ Shri Padhmam Industries Interview Questions and Answers

Finding smallest of 4 numbers without using >.< and min function in Java.

• Initialize a variable with the first number

• Compare it with the remaining numbers using if-else statements

• If a smaller number is found, update the variable

• Repeat until all numbers are compared

• The final value of the variable will be the smallest number

Swap two numbers without using a temporary variable.

• Use addition and subtraction to swap the values

• Use XOR operator to swap the values

• Use multiplication and division to swap the values

To add 2 tables, we need to use a join operation on a common column.

• Identify the common column between the tables

• Choose the appropriate join type (inner, outer, left, right)

• Write the SQL query to join the tables

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

Union combines and removes duplicates, Union All combines all rows including duplicates.

• Union is used to combine the result sets of two or more SELECT statements and remove duplicates.

• Union All is used to combine the result sets of two or more SELECT statements and includes all rows, including duplicates.

• Union is slower than Union All as it has to remove duplicates.

• Union requires the same number of columns in all SELECT statements, while Union All does not.

• Example: SELECT col...read more

Code for palindrome checking

• Convert the input to lowercase to ignore case sensitivity

• Use two pointers, one at the start and one at the end of the string

• Compare the characters at both pointers and move them towards each other

• If all characters match, it's a palindrome

Javascript code to display 'Hello World!' on the webpage

• Create a new HTML file

• Add a script tag with 'type' attribute set to 'text/javascript'

• Inside the script tag, use document.write() to display 'Hello World!'

The number of barbers required depends on the average number of haircuts per day and the time it takes to complete a haircut.

• The average number of haircuts per day per barber is typically around 10-15.

• The time it takes to complete a haircut is usually around 30 minutes.

• Assuming each person gets a haircut once every month, the number of haircuts per day would be 10000 / 30 = 333.33.

• To accommodate this, around 333.33 / 10 = 33.33 barbers would be required.

Classes are like blueprints and objects are like things made using those blueprints.

• Classes are like instructions or rules that tell us how to make something.

• Objects are the actual things that we make using those instructions.

• For example, a class 'Car' tells us how to make a car, and an object 'myCar' is the actual car that we make using those instructions.

Object Oriented Programming (OOP) concepts include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation: Bundling data and methods together in a class to hide implementation details.

• Inheritance: Creating new classes from existing ones, inheriting their properties and behaviors.

• Polymorphism: The ability of objects of different classes to respond to the same method in different ways.

• Abstraction: Simplifying complex systems by breaking them down into smaller, ...read more

Sorting algorithms have different time complexities based on their implementation and efficiency.

• Bubble Sort: O(n^2) - compares adjacent elements and swaps them if they are in the wrong order.

• Merge Sort: O(n log n) - divides the array into two halves, sorts them, and then merges them.

• Quick Sort: O(n log n) - picks a pivot element and partitions the array around the pivot.

• Heap Sort: O(n log n) - builds a max heap and repeatedly extracts the maximum element.

• Insertion Sort: O(n^...read more

OOPs pillars are Abstraction, Encapsulation, Inheritance, and Polymorphism.

• Abstraction: Hides complex implementation details and only shows necessary features. Example: Car dashboard displaying speed without showing internal engine details.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Class in Java encapsulates data members and member functions.

• Inheritance: Allows a new class to inherit properties and behavior of an existing cl...read more

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

• 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 the tables.

• Self Join: Joining a table with itself.

Internal audit is an independent, objective assurance and consulting activity designed to add value and improve an organization's operations.

• Internal audit evaluates the effectiveness of an organization's risk management, control, and governance processes.

• It provides recommendations for improvement and helps organizations achieve their objectives.

• Internal auditors are responsible for assessing the accuracy of financial statements and ensuring compliance with laws and regulati...read more