熟悉傳統數據庫概念及 SQL

1. Typically where is a database is stored?


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


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


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


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


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


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


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


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


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