Seniority Interview Questions and Answers

Different types of joins in SQL, Delete drop truncate difference

• Types of joins: Inner join, Left join, Right join, Full outer join

• Inner join returns only matching rows from both tables

• Left join returns all rows from left table and matching rows from right table

• Right join returns all rows from right table and matching rows from left table

• Full outer join returns all rows from both tables

• Delete is used to remove specific ...read more

Identify data structure based on insertion and deletion order

• If insertion and deletion follow LIFO order, it is a stack

• If insertion follows FIFO order and deletion follows LIFO order, it is a queue

• If insertion and deletion follow priority order, it is a priority queue

Find maximum element in an array in less than O(N)

• Use divide and conquer approach

• Compare maximum of left and right subarrays

• Recursively find maximum element