MaaxtreeM SQL Developer Interview Questions and Answers

Use SQL query to find the top 3 maximum salaries in a table.

• Use the SELECT statement to retrieve the salaries from the table.

• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the results to the top 3 salaries.

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization involves breaking down data into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured way.

• Normalization ensures data integrity by minimizing the chances of inconsistencies.

• There are different normal forms such as 1NF, 2NF, 3NF, and BCNF to guide the