武汉理工大学数据库系统原理总复习题完整版含答案.docx

1、武汉理工大学数据库系统原理总复习题完整版含答案武汉理工大学 数据库系统原理总复习题（完整版含答案）1. Questions1.1 What is the purpose of a database?ANSWER：The purpose of a database is to help people track of things.1.2 What is the most commonly used type of database?ANSWER: the most commonly used type of database is the relational database.1.7 Def

2、ine 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 simila

3、r 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 users work may interfere with others.1.12 What is the purpose of the largest databases at e-commerce compani

4、es such as A?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

5、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 nece

6、ssarily 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 c

7、omplexity 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 interna

8、tionally 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

9、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 tables.1.23 Why is a database co

10、nsidered to be self-describing? ANSWER: A database is self-describing because it contains a description of itself. Thus, databases contain not only tables of user data, but also tables of data that describe that user data.1.24 What is metadata? How does this term pertain to a database?ANSWER: databa

11、ses contain not only tables of user data, but also tables of data that describe that user data. Such descriptive data is called metadata because it is data about data.1.25 What advantage is there in storing metadata in tables?ANSWER: Because metadata is stored in tables, you can use SQL to query it.

12、 Thus, by learning how to write SQL to query user tables, you will also learn how to write SQL to query metadata.1.26 List the components of a database other than user tables and metadata. Tables of user data Metadata Indexes Stored procedures Triggers Security data Backup/recovery data1.27 Is Micro

13、soft Access a DBMS? Why or why not?ANSWER: No, Microsoft Access is not just a DBMS. Rather, it is a personal database system: a DBMS plus an application generator.Because although Microsoft Access contains a DBMS engine that creates, processes, and administers the database, it also contains form, re

14、port, and query components that are the Microsoft Access application generator1.37 List several consequences of a poorly designed database.ANSWER: -They may require application developers to write overly complex and contrived SQL to get wanted data.-they may be difficult to adapt to new and changing

15、 requirements.-they may fail in some other way.1.38 Explain two ways that a database can be designed from existing data.ANSWER:The first type of database design involves databases that are constructed from existing Data.A second way that databases are designed is for the development of new informati

16、on systems.1.39 What is a data warehouse? What is a data mart?ANSWER: The data warehouse and data mart databases store data specifically organized for research and reporting purposes, and these data often are exported to other analytical tools, such as SASs Enterprise Miner, IBMs SPSS Data Modeler,

17、or TIBCOs Spot fire Metrics. 1.40 Describe the general process of designing a database for a new information system.ANSWER: First, the team creates a data model from the requirements statements and then transforms that data model into a database design.1.41 Explain two ways that databases can be red

18、esigned.ANSWER: In the first, a database is adapted to new or changing requirements. This process sometimes is called database migration. In the migration process, tables may be created, modified, or removed; relationships may be altered; data constraints may be changed; and so forth. The second typ

19、e of database redesign involves the integration of two or more databases. This type of redesign is common when adapting or removing legacy systems. It is also common for enterprise application integration, when two or more previously separate information systems are adapted to work with each other.

20、1.42 What does the term database migration mean?ANSWER: The process of a database is adapted to new or changing requirements.1.43 Summarize the various ways that you might work with database technology.ANSWER: In our career, we may work with database technology as either a user or as a database admi

21、nistrator. As a user, you may be a knowledge worker who prepares reports, mines data, and does other types of data analysis or you may be a programmer who writes applications that process the database. Alternatively, you might be a database administrator who designs, constructs, and manages the data

22、base itself. Users are primarily concerned with constructing SQL statements to get and put the data they want. Database administrators are primarily concerned with the management of the database.1.44 What job functions does a knowledge worker perform?ANSWER: preparing reports, mining data, and doing

23、 other types of data analysis.1.45 What job functions does a database administrator perform?ANSWER: designing, constructing, and managing the database itself.1.47 What need drove the development of the first database technology?ANSWER: The need for data integration drove the development of the first

24、 database technology.1.48 What are Data Language/I and CODASYL DBTG?ANSWER: Data Language/I (DL/I) used hierarchies or trees (see Appendix G) to represent relationships.This subcommittee developed a standard data model that came to bear its namethe CODASYL DBTG model. It was an unnecessarily complic

25、ated model. This data relationship used data structures called networks.1.49 Who was E. F. Codd?ANSWER: E.F.Codd was a little-known IBM engineer published a paper in the Communications of the ACM3 in which he applied the concepts of a branch of mathematics called relational algebra to the problem of

26、 “shared data banks,” as databases were then known. The results of this work are now the relational model for databases, and all relational database DBMS products are built on this model. 1.50 What were the early objections to the relational model?1.51 Name two early relational DBMS products.ANSWER:

27、 Oracle Database, DB2.1.52 What are some of the reasons for the success of Oracle Database?ANSWER:1, it would run on just about any computer and just about any operating system.2, Oracle Database had, and continues to have, an elegant and efficient internal design.1.53 Name three early personal comp

28、uter DBMS products.ANSWER: dBase, R:base, Paradox.1.55 What was the purpose of OODBMS products? State two reasons that OODBMS products were not successful.ANSWER: They were designed to make it easy to store the data encapsulated in OOP objects.There were two reasons for their lack of acceptance. Fir

29、st, using an OODBMS required that the relational data be converted from relational format to object-oriented format. By the time OODBMS emerged, billions upon billions of bytes of data were stored in relational format in organizational databases. No company was willing to undergo the expensive trava

30、il of converting those databases to be able to use the new OODBMS. Second, object-oriented databases had no substantial advantage over relational databases for most commercial database processing. As you will see in the next chapter, SQL is not object oriented. But it works, and thousands of develop

31、ers have created programs that use it. Without a demonstrable advantage over relational databases, no organization was willing to take on the task of converting their data to OODBMS format. 1.56 What characteristic of HTTP was a problem for database processing applications?ANSWER: HTTP is a stateles

32、s protocol; a server receives a request from a user, processes the request, and then forgets about the user and the request. Many database interactions are multistage. A customer views products, adds one or more to a shopping cart, views more products, adds more to the shopping cart, and eventually checks out. A stateless protocol cannot be used for such applications. 1.57 What is an open source DBMS product? Which of the five DBMS p