TEKIZMA Interview Questions and Answers for Experienced

Q1. Give diffrence between rank n dense rank of sql
Ans. 
Rank assigns unique rank to each distinct row, while dense rank assigns consecutive ranks to rows with the same values.
• Rank leaves gaps in ranking sequence if there are ties, while dense rank does not.

• Rank function is used to assign unique rank to each distinct row based on specified column values.

• Dense rank function is used to assign consecutive ranks to rows with the same values based on specified column values.

• Examp...read more
Answered by AI
Add your answer
Q2. Explain end to end ETL testing
Ans. 
End to end ETL testing involves testing the entire process of extracting, transforming, and loading data from source to target systems.
• Understand the data flow from source to target systems

• Verify data extraction from source systems

• Validate data transformation logic

• Check data loading into target systems

• Perform data reconciliation between source and target systems
Answered by AI
Add your answer
Q3. Scenario based questions
Add your answer

Q1. Reverse string. Find min Find max from list
Ans. 
Reverse a string and find min/max from a list of strings.
• To reverse a string, use built-in functions or loop through characters in reverse order.

• To find min/max from a list of strings, convert strings to numbers if needed and use built-in functions.

• Example: Reverse string 'hello' -> 'olleh'. Find min/max from list ['5', '10', '2'] -> min: 2, max: 10.
Answered by AI
Add your answer

Q1. Asked about sql and pl sql theoretical questions.
Add your answer

Did 4 questions on sql coding.