SMC Global Securities Interview Questions and Answers

Program to append a string at the middle of another string

• Find the middle index of the original string

• Use string slicing to split the original string into two parts

• Concatenate the first part, new string, and second part to form the final string

Query to select sum of salaries department wise

• Use GROUP BY clause to group salaries by department

• Use SUM() function to calculate the sum of salaries

• Join the employee and department tables on department ID

Query to select employee with second highest salary

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1,1 to select the second highest salary

• Join with employee table to get employee details

OOPs concepts are the fundamental principles of Object-Oriented Programming.

• Abstraction

• Encapsulation

• Inheritance

• Polymorphism

Access modifiers are keywords in object-oriented programming languages that set the accessibility of classes, methods, and other members.

• There are four access modifiers in Java: public, private, protected, and default

• Public members are accessible from anywhere in the program

• Private members are only accessible within the same class

• Protected members are accessible within the same class and its subclasses

• Default members are accessible within the same package

• Access modifiers help...read more

Abstraction is the process of hiding complex implementation details and showing only the necessary information to the user.

• Abstraction is achieved through abstract classes and interfaces.

• It helps in reducing complexity and improving maintainability.

• Example: A car dashboard is an abstraction of the car's internal workings.

• Abstraction is a key concept in object-oriented programming.