Intermediate Quiz 2
1. How do you rename a column "old" to "new"?
2. What does the UNIQUE constraint do?
3. Which function returns the current date in SQL?
4. How do you remove all rows from a table but keep its structure?
5. Which SQL statement creates an index?
6. How do you select employees whose name starts with "A"?
7. What does a LEFT JOIN do?
8. How do you get the total number of rows in a table "orders"?
9. Which SQL clause sorts the result set?
10. How do you select all rows where column "score" is between 80 and 100?
Previous Next