Скачать или смотреть Top 50 Interview Questions?

Top 50 Interview Questions? #shorts


1. What is SQL?

2. What are the different types of SQL statements?

3. What is a primary key?

4. What is a foreign key?

5. What is normalization in SQL?

6. What is a self-join?

7. What is the difference between UNION and UNION ALL?

8. What is the difference between INNER JOIN and OUTER JOIN?

9. What is a subquery?

10. What is a view?
11. What is a stored procedure?

12. What is a trigger?

13. What is the difference between CHAR and VARCHAR data types?

14. What is the difference between WHERE and HAVING clauses?

15. What is the difference between DELETE and TRUNCATE statements?

16. What is the difference between clustered and non-clustered indexes?

17. What is the difference between GROUP BY and ORDER BY?

18. What is the difference between a database and a schema?

19. Explain ACID properties in SQL.

20. What is a deadlock and how can it be resolved?
21. What is a composite key?

22. Explain the difference between DDL, DML, and DCL.

23. What is the difference between a function and a stored procedure?

24. What is the difference between an outer join and a cross join?

25. What is the difference between a left join and a right join?

26. What is the difference between a unique key and a primary key?

27. What is a self-referential foreign key?

28. What is the difference between the EXISTS and IN operators?

29. What is the difference between the MINUS and NOT IN operators?

30. What is the difference between the LIKE and SUBSTRING functions?
31. What is the purpose of the COALESCE function?

32. What is the purpose of the GROUPING function?

33. What is the difference between the CHAR and NCHAR data types?

34. Explain the concept of data integrity in SQL.

35. What is the purpose of the GREATEST and LEAST functions?

36. What is the purpose of the ROLLUP and CUBE operators?

37. What is the difference between the ROW_NUMBER and RANK functions?

38. What is the purpose of the NVL function?

39. What is the difference between a candidate key and a super key?

40. What is the difference between the UNION and UNION ALL operators?
41. Explain the concept of database normalization.

42. What is the difference between an index and a constraint?

43. What is the purpose of the COMMIT and ROLLBACK statements?

44. Explain the concept of database transactions.

45. What is the purpose of the CASE statement?

46. What is the difference between the ANY and ALL operators?

47. What is the purpose of the TRUNC function?

48. What is the difference between the COUNT and COUNT(*) functions?

49. What is the purpose of the DISTINCT keyword?

50. Explain the concept of referential integrity in SQL.