数据库第三章同步练习(国外英文资料).docVIP

数据库第三章同步练习(国外英文资料) The third chapter A, multiple choice The index that can be opened automatically with the table is C A) A single index file B) composite index files C) structured composite index files D) unstructured composite index files The primary key does not allow repeat values, meaning A A) entity integrity constraint rule B) referential integrity constraint rules C) user-defined integrity constraint rules D) data integrity constraint rules In the following statements on the index, the incorrect is D A) Visual FoxPro supports two index files: single index files and composite index files B) open and close the INDEX files using the SET INDEX TO command The type of index has primary indexes, candidate indexes, unique indexes, and common indexes D) the index file is not closed as the library file is closed The maximum value of the field name in the free table is B A) 8 B) ten C) 128 D) 255 To open multiple data table files simultaneously, select the command that can be used in different workspaces A) USE B) OPEN C) the SELECT D) all orders are available In Visual FoxPro, the command phrase for opening the database file in a Shared way is B A) EXCLUSIVE B) SHARED C) NOUPDATE D) VALIDATE In the following index, the uniqueness is not unique A) primary index B) the candidate index C) a unique index D) average index 8, if you want to set the student age validity rule between the ages of 18 and 20, when the input value is not in the range, then the error message is given, and we must define B A) entity integrity B) domain integrity C) referential integrity D) all of the above needs to be defined The function of command SELECT 0 is A A) select the least numbered free workspace B) choose the spare workspace with the maximum number C) randomly select the area code of a workspace No such workspace, command error If the salary table is indexed by the base wage, and the assigned statement N = 800, the following is the wrong number B A) SEEK FOR basic salary = N C) FIND 1000