武汉理工大学数据库系统原理总复习题(完整版含答案)
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
理工大学数据库系统原理总复习题（完整版含答案）
1. Questions
1.1What is the purpose of a database?
ANSWER：The purpose of a database is to help people track of things.
1.2What is the most commonly used type of database?
ANSWER: the most commonly used type of database is the relational database.
1.7 Define the terms data and information. Explain how the two terms differ.
ANSWER: Data are recorded facts and numbers.
we can now define information as:
●Knowledge derived from data.
●Data presented in a meaningful context.
●Data processed by summing, ordering, averaging, grouping,
comparing or other similar operations.
1.10 What problem can occur when a database is processed by more than one user?
ANSWER: When more than one user employs a database application, these is always the chance that one user's work may interfere with other's.
1.12 What is the purpose of the largest databases at e-commerce companies such as Amazon.?
ANSWER: The largest databases are those that track customer browser behavior.（用来记录用户的浏览行为的。）
1.13 How do the e-commerce companies use these databases? .
ANSWER: E-commerce companies use Web activity databases to determine which items on a Web page are popular and successful and which are not.
1.14 How do digital dashboard and data mining applications differ from transaction processing applications?
ANSWER: Digital dashboards and other reporting systems assess past and current performance. Data mining applications predict future performance.
1.15 Explain why a small database is not necessarily simpler than a large one.
What are the functions of application programs?
ANSWER: Supposed we have 2 company which are different in sales but have similar database. Though the difference in sale, both have the same kinds of data, about the same number of tables of data, and the same level
of complexity in data relationships. Only the amount of data varies from one to the other. Thus, although a database for a small business may be small, it is not necessarily simple.
1.18 What is Structured Query Language (SQL), and why is it important?
ANSWER: Structured Query Language (SQL)is an internationally recognized standard language. Because it can be understood by all commercial DBMS products, in database processing and the fact that database applications typically send SQL statements to the DBMS for processing.
1.19 What does DBMS stand for?
ANSWER: The database management system.
1.20 What are the functions of the DBMS?
ANSWER: It can be used to create, process, and administer the database.
1.21 Name three vendors of DBMS products.
ANSWER: IBM, Microsoft, Oracle.
1.22 Define the term database.
ANSWER: A database is a self-describing collection of integrated