熟悉傳統數據庫概念及 SQL

1. Create an index when? (choose two)

2. Which of the following is the best description for a database?

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

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

5. Which of the following SQL statements is the correct one to copy rows from another tables?

6. Typically where is a database is stored?

7. Which of the following is a standard interactive and programming language for getting information from and updating a database?

8. 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.

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

10. In most databases, data are organized and stored in: