Kuiz berkaitan panduan · Sederhana Tahap
Cara Menulis Pertanyaan SQL dengan Kuiz AI
Uji sejauh mana anda boleh memberikan AI skema anda, tangkap perangkap fan-out dan NULL serta sahkan SQL yang dijana AI dengan selamat sebelum mempercayai hasilnya.
soalan 1 daripada 8
Menurut panduan itu, apakah langkah tunggal yang paling meningkatkan ketepatan SQL yang dijana AI?
Pratonton setiap soalan8 soalan
Jawapan dan penjelasan muncul semasa anda mengambil kuiz.
- Menurut panduan itu, apakah langkah tunggal yang paling meningkatkan ketepatan SQL yang dijana AI?
- Asking the model to be extra careful
- Pasting your schema, such as CREATE TABLE statements and relationships
- Writing your question entirely in uppercase
- Always using the newest model available
- Mengapa anda perlu memberitahu AI dialek SQL yang anda gunakan?
- Only PostgreSQL supports SELECT statements
- AI models refuse to answer without a dialect
- The dialect determines how much disk space a query uses
- Dialects differ in details like date functions and LIMIT versus TOP
- Anda menyertai pesanan ke order_item dan kemudian mengira SUM(orders.total). Apakah masalah yang mungkin berlaku?
- Revenue is inflated because each order total repeats once per item
- The query will always fail with a syntax error
- NULL values are converted to zero
- The results come back sorted in the wrong order
- Mengapakah panduan mengesyorkan meminta AI untuk menerangkan pertanyaannya dengan kata-kata yang jelas?
- It makes the query run faster
- SQL engines require an explanation before executing
- It exposes misunderstandings, such as counting rows instead of distinct customers
- It reduces the cost of the AI request
- Pernyataan yang manakah tentang COUNT(lajur) dan COUNT(*) adalah betul?
- They always return the same number
- COUNT(column) skips NULLs, while COUNT(*) counts every row
- COUNT(*) skips NULLs, while COUNT(column) counts every row
- COUNT(column) counts only distinct values
- What is the safest way to experiment with AI-generated queries?
- Run them directly on production during quiet hours
- Ask the AI whether the query is safe and trust the answer
- Use a read-only database user and wrap data changes in a transaction you can roll back
- Remove the WHERE clause so the query is simpler
- When asking an AI to optimize a slow query, what should you provide besides the query?
- A screenshot of the dashboard that uses it
- The database password
- A list of everyone who runs the report
- The execution plan from EXPLAIN or EXPLAIN ANALYZE
- Which of these is a misconception the guide warns against?
- A query that runs without errors must be returning the right answer
- The schema alone is often enough context, without real customer data
- An UPDATE without a WHERE clause affects every row
- Business rules like amounts stored in cents should be stated