Syntax Error
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is a syntax error?
2. What is the consequence of a syntax error for program execution?
3. In the anecdote from New Zealand, how long did a senior architect spend trying to fix a syntax error?
4. What are syntax errors said to reflect?
5. In SQL, when do syntax errors often occur?
6. What is wrong with the SQL statement INSERT INTO customers (customer_id, customer_name, city) VALUES (101, 'John Doe, 'New York');?
7. What is wrong with the statement SELECT employee_id, employee_name WHERE department = 'Sales';?
8. Which of the following is NOT one of the SQL syntax-error examples given?
9. When do SQL development environments and database systems typically report syntax errors?
10. Which statement about syntax errors is correct?