Search by topic
14 questions
- Why does a tester need SQL?Fresher 路 Q39SQL馃敀
- What is the difference between a primary key, a foreign key and a unique key?Fresher 路 Q40SQL馃敀
- What is the difference between DELETE, TRUNCATE and DROP?Fresher 路 Q41SQL馃敀
- How do you find the second highest salary from an Employee table?Fresher 路 Q42SQL馃敀
- What is the difference between WHERE and HAVING? Explain GROUP BY.Fresher 路 Q43SQL馃敀
- What are the types of joins in SQL?Fresher 路 Q44SQL馃敀
- How do you find duplicate records in a table?Fresher 路 Q45SQL馃敀
- What is the difference between UNION and UNION ALL?Junior QA 路 Q41SQL馃敀
- What is a subquery? When would you use it instead of a join?Junior QA 路 Q42SQL馃敀
- What are window functions? Explain ROW_NUMBER, RANK and DENSE_RANK.Junior QA 路 Q43SQL馃敀
- What is an index? How does it affect testing?Junior QA 路 Q44SQL馃敀
- What are ACID properties and transactions?Junior QA 路 Q45SQL馃敀
- How do you validate data between the UI and the database?Junior QA 路 Q46SQL馃敀
- What is a CTE in SQL and how do you use SQL to test data migrations?Mid-level QA 路 Q48SQL馃敀