Digilytics AI Product Engineer Interview Questions and Answers

Query to find second highest marks of a student

• Sort the marks in descending order

• Select the second highest mark

• Join with student table to get student details

Joins in SQL are used to combine data from two or more tables based on a related column.

• Joins are used to retrieve data from multiple tables.

• There are different types of joins such as inner join, left join, right join, and full outer join.

• The join condition is specified using the ON keyword.

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

No, static methods cannot be overridden but can be overloaded.

• Static methods belong to the class and not to the instance of the class.

• Overriding is not possible as it requires inheritance and static methods cannot be inherited.

• Overloading is possible as it allows multiple methods with the same name but different parameters.

• Example: public static void method() and public static void method(int a)