熟悉傳統數據庫概念及 SQL

1. Each record in the products table has a product ID and a product name. How to list the products sorted by their names?

2. Each record in the products table has a product ID, a product name and a price. How to calculate the numbers of products whose prices are greater than $100?

3. In creating a database, this is the process of organizing it into tables in such a way that the results of using the database are always unambiguous.

4. Which of the following is not a many-to-many relationship?

5. How to create a table?

6. Which of the following may be a valid SQL statement?

7. Each record in the products table has a product ID, a product name and a price. How to double the prices of all products?

8. Create an index when? (choose two)

9. Which of the following may be a valid SQL statement?

10. Which of the following is suitable to use index?