DB2认证题库700 -2.docVIP

DB2认证题库700 -2 1) Which of the following products is required to be installed in order to build an application on AIX, which will access a DB2 UDB for OS/390 database? a) DB2 Connect Personal Edition b) DB2 Universal Database Workgroup Edition c) DB2 Personal Developers Edition d) DB2 Universal Developers Edition 2) Which of the following tools can be used to catalog a database? a) Journal b) Alert Center c) License Center d) Client Configuration Assistant 3) Which of the following utilities would you run to order data and reclaim space from deleted rows in a table: a) reorg b) db2look c) db2move d) runstats 4) The purpose of the USE privilege is to: a) query data in a table. b) load data into a table. c) create tables within a table space. d) create table spaces within a database. 5) Which two of the following authorities can create a database? a) DBADM b) SYSADM c) DBCTRL d) SYSCTRL e) SYSMAINT 6) Cataloging a remote database is: a) Performed on a PC or UNIX machine to identify the server the DB2 database manager is on. b) Performed on a PC or UNIX machine to identify the DB2 database to users and applications. c) Never performed in DB2, as only one database per node is allowed, so cataloging a node automatically catalogs the database at that node. d) Performed on a PC or UNIX machine to open the catalogs in the DB2 database and present a user with a list of all accessible tables in that database. 7) Given the create statements: CREATE DISTINCT TYPE kph AS INTEGER WITH COMPARISONS CREATE DISTINCT TYPE mph AS INTEGER WITH COMPARISONS CREATE TABLE speed_limits (route_num SMALLINT, canada_sl KPH NOT NULL, us_sl MPH NOT NULL) Which of the following is a valid query? a) SELECT route_num FROM speed_limits WHERE canada_sl 80 b) SELECT route_num FROM speed_limits WHERE canada_sl kph c) SELECT route_num FROM speed_limits WHERE canada_sl us_sl d) SELECT route_n