Sirius Transtech SQL Developer Interview Questions and Answers

Q1. Find 3rd highest salary
Ans. 
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 2,1 to skip first two highest salaries and get the third highest salary
Answered by AI
Add your answer
Q2. Pivoting and unpivoting in SQL
Ans. 
Pivoting and unpivoting are techniques used in SQL to transform data from rows to columns and vice versa.
• Pivoting involves rotating rows into columns, typically used to summarize data.

• Unpivoting involves rotating columns into rows, typically used to normalize data.

• Pivoting can be done using the PIVOT keyword in SQL, while unpivoting can be done using the UNPIVOT keyword.
Answered by AI
Add your answer
Q3. Difference in rank and dense rank
Ans. 
Rank assigns unique rank to each row, while dense rank allows for ties in ranking.
• Rank leaves gaps in ranking sequence, while dense rank does not

• Rank(1, 2, 2, 4) = 1, 2, 3, 4

• Dense Rank(1, 2, 2, 4) = 1, 2, 2, 3
Answered by AI
Add your answer

Simple coding not that much tough

Q1. Question related to your skills
Add your answer
Q2. Just basic questions
Add your answer

Q1. Why u want to join
Add your answer

Q1. Scenario based questions
Add your answer

Q1. Types of Indexes
Ans. 
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
• Clustered indexes physically reorder the data in the table based on the index key.

• Non-clustered indexes create a separate structure for the index, pointing back to the original table data.

• Unique indexes ensure that no two rows have the same values in the indexed columns.

• Composite indexes are created on multiple columns to improve...read more
Answered by AI
Add your answer
Q2. Sceanrio based question
Add your answer

Q1. Salary discussion
Add your answer
Q2. Joining date and last working date
Add your answer

Profit and loss,percentage

Q1. Why do you this job ?
Add your answer
Q2. How can i believe you are the best to our company?
Add your answer

Q1. Syntax of stored procedure What is cursors Joins Cte
Ans. 
Stored procedures are used to store SQL queries for reuse. Cursors are used to iterate through a result set. Joins combine data from multiple tables. CTEs are temporary result sets.
• Stored procedures are used to store SQL queries for reuse

• Cursors are used to iterate through a result set

• Joins combine data from multiple tables

• Common Table Expressions (CTEs) are temporary result sets
Answered by AI
Add your answer

Q1. Joins , index, keys and sp
Add your answer
Q2. Function plsql queries
Add your answer

Q1. Telephonic interview of SQL
Add your answer

Q1. SQL technical coding test
Add your answer