熟悉傳統數據庫概念及 SQL

1. Create an index when? (choose two)

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

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

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

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

6. How to create a table?

7. Typically where is a database is stored?

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

9. Which of the following is a collection of data items organized as a set of formally described tables from which data can be accessed or reassembled in many different ways, without having to reorganize the table?

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