05What is a relational database (RDBMS) and how does it differ from NoSQL? Xem câu trả lờiXem chi tiếtentry
06How do you choose the right SQL data type for a column (DECIMAL vs FLOAT, VARCHAR vs TEXT, dates, UUID, JSON, boolean)? Xem câu trả lờiXem chi tiếtentry
09How does the LIKE operator work, and when should you use full-text search instead? Xem câu trả lờiXem chi tiếtentry
10What is the difference between COUNT(*), COUNT(column) and COUNT(DISTINCT column)? Xem câu trả lờiXem chi tiếtentry
14How do UNIQUE and CHECK constraints work, and how do they differ from PRIMARY KEY and NOT NULL? Xem câu trả lờiXem chi tiếtjunior
16How do ORDER BY, LIMIT, OFFSET and FETCH FIRST work across databases, and why is keyset pagination better than OFFSET? Xem câu trả lờiXem chi tiếtjunior
18What are the rules of GROUP BY, and what are ONLY_FULL_GROUP_BY and ANY_VALUE? Xem câu trả lờiXem chi tiếtjunior
19How does the CASE expression work in SQL and where can you use it? Xem câu trả lờiXem chi tiếtjunior
20What is the difference between COALESCE, NULLIF, IFNULL and ISNULL? Xem câu trả lờiXem chi tiếtjunior
21What are a self join, a cross join and a natural join, and when would you use each? Xem câu trả lờiXem chi tiếtjunior
22How do string functions and concatenation differ between SQL databases? Xem câu trả lờiXem chi tiếtjunior
24How do you model one-to-many and many-to-many relationships in SQL? Xem câu trả lờiXem chi tiếtjunior
28Discuss INNER JOIN ON vs WHERE clause (with multiple FROM tables) Xem câu trả lờiXem chi tiếtmiddle