数据库考试题总汇（国外英文资料）.doc

数据库考试题总汇（国外英文资料） ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ 1, fill in the blank 5 questions (up to 20 points) ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ ━ Problem 1 (4) : 4973 The rule is to check whether a value in the field is valid. The answer: 1). Validity Problem 2 (4) : 2558 Database design is divided into the following six stages: demand analysis stage, 【 】 concept design phase, logic design, physical design, implementation, operation and maintenance phase. The answer: 1). Conceptual design phase Problem 5 (4) : 232 Access provides two types of field data types that hold data in both text and digital combinations: text and [comment]. The answer: 1). Note Problem 4 (4) : 3779 In Access, the tables [primary key] is automatically set to the primary index of the table. The answer: Primary key Problem 1 (4) : 3769 Import, refers to the copy to Access data from the other sources of data in the table, in the Access to modify, delete, and these data, and in the Access number in the table? The answer: 1.) the import Problem 2 (4) : 6166 The validity rule expression should be ( = 100 And = 999) if the value requested by the user is a value of 3 bits. The answer: 1). = 100 And = 999 Problem 3 (4) : 233 Data sources in the form include tables and [queries]. The answer: 1). The query Problem 4 (4) : 2566 The Access database includes basic objects such as tables, queries, forms, reports, (macros), pages, and modules. The answer: 1). The macro Problem 2 (4) : 2577 The easiest way to create the main keyword is to use the [automatic number] field. The answer: Automatic number Problem 4 (4) : 3775 Setting [index] in the Access database helps to quickly find and sort Access text, Numbers, dates/time, money and automatic number data type of the data values. The answer: Index of 1). Problem 1 (4) : 6170 If the user defines a table relationship, it must be removed before deleting the primary key. The answer: Primary key deletion Problem 5 (4) : 2573 The