DB2模拟题（国外英文资料）.docVIP

DB2模拟题（国外英文资料） The DB2 common database base emulation problem A developer develops a Windows program that accesses DB2 on the backend AIX and needs to be installed on the Windows development platform: A. DB2 runtime client B. DB2 manages the client C. DB2 application development client D. DB2 thin client Correct answer: C 2 after executing the following two SQL statements: The CREATE TABLE t1 C1 char (10) NOT NULL PRIMARY KEY, C2 int, C3 char (10), C4 char (10) NOT NULL, CONSTRAINT c4 UNIQUE (c1, c4)) / / automatically creates the index CREATE INDEX Index1 ON t1 (c2 ASC) How many indexes are on table t1? A. 0 1 B. 2 C. 3 D. E. 4 Answer: D The main difference between a database system and a file system is: A database system is complex, and the file system is simple. The B file system does not solve data redundancy and data independence problems, and the database system can solve it. The C file system only manages the program files, and the database system can manage various types of files. The D file system manages less data and the database system can manage a large amount of data. Answer: B The connection in the E -r graph can be related to the entity A zero 1 B One or more C D more Answer: C It is stored in the database A data B data model The link between C data and data D information Answer: C The independence of the database system means A does not affect the application because of the data changes B does not affect the application because the system data store structure changes with the data logic structure C does not affect the storage structure because of the changes in the storage policy D does not affect other storage structures because of changes in the storage structure Answer: B The following is the correct description of the database system There is only A link between data items in A database There is a link between the data items of the B database and the records There is no link between the data items of the C database and the records There is no co