
1
2020 Database System Principles
Test One
Class___ _________No_______ _____Name____________
1. (20 points) Fill in blanks
(1)Among the following statements, the correct one/ones is/are C .
I. OpenGauss database, derived from PostgreSQL, is developed and distributed by
Huawei.
II. MySQL and PostgreSQL are two typical open-source database systems.
III. A on-line shopping site has a three-tier Browser-Server(B/S) architecture. Its
application programs are programmed in Java, and these programs access
MySQL database server via the ODBC interface.
IV. The relational model is applicable to managing structured data such as the table
data, while XML provides a way to represent semi-structured data, e.g. the data
with nested structures.
A. I, II, III, IV B. I, II, III C. I, II, IV D. II, III, IV
(2)The data model defines the specification of managing data items in database.
It is a collection of conceptual tools for describing data structure, data relationships,
data semantics, data operations and consistency constraints.
(3) Database design involves the following phases: requirements analysis, conceptual
schema design, logical design and physical design.
(4) As human-machine interfaces, the pure database language consists of two parts,
i.e. the data manipulation language and the data definition language (或:DDL)
that is for specifying the database schema and as well as other properties of the data.