Zones Corporate Solutions 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!'

Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• Polymorphism allows for methods to be called on objects of different classes that share a common superclass.

• It enables flexibility and extensibility in object-oriented programming.

• Examples include method overriding in inheritance and interfaces in Java.