Member Technical Staff Software Interview Questions and Answers for Freshers

Technical interview questions on SQL and database concepts.

• To update employee salary, use the UPDATE statement with SET clause and WHERE clause to specify the employee.

• A palindrome is a word or phrase that reads the same backward as forward. Write a function to check if a string is a palindrome.

• Normalization is the process of organizing data in a database to reduce redundancy and dependency.

• Views are virtual tables that display data from one or more tables in a database.

• ACID ...read more

Find all nodes at distance k from a given node in a binary tree.

• Use depth-first search to traverse the binary tree and keep track of the distance from the target node.

• When reaching the target node, start exploring its children at distance k.

• Consider using a queue to keep track of nodes at each level while traversing the tree.