第1题:
What are the primary goals of the data discovery phase of the data warehouse project?
在数据仓库项目中,数据探索阶段的主要目的是什么?
第2题:
State the primary types of tables found in a data warehouse and the order which they must be loaded to enforce referential integrity.
简述数据仓库中的表的基本类型,以及为了保证引用完整性该以什么样的顺序对它们进行加载。
第3题:
________ there much cargo in the warehouse?
A.Are
B.Is
C.Be
D.Will be
第4题:
customer wants to network several computers within a large warehouse. The warehouse has one computer at the very far end of the warehouse that is 170 meters (557 feet) from the network switch. Which of the following cable types should a technician use for this computer?()
第5题:
某企业的数据库系统中有如下所示的员工关系和仓库关系,每个仓库可有多名员工,但只有一名负责人。
员工关系(employee):
仓库关系(warehouse):
则创建仓库表结构的SQL语句为(58)。
A.CREATE TABLE (employee ID CHAR(2)NOTNULL UNIQUE, name CHAR(30)NOT NULL, address CHAR(40), principal ID CHAR(3));
B.CREATE warehouse(warehouse ID CHAR(2)PRIMARY KEY, name CHAR(30), address CHAR(40), principal ID CHAR(3));
C.CREATE TABLE warehouse(warehouse ID CHAR(2)PRIMARY KEY, name CHAR(30)NOT NULL, address CHAR(40), principal ID CHAR(3), FOREIGN KEY(principal ID)REFERENCES employee(employee ID));
D.CREATE TABIE warehouse(warehouse ID CHAR(2), name CHAR(30)NOT NULL, address CHAR(40), principal ID CHAR(3), PRIMARY REY(warehouse ID), FOREIGN KEY(employee ID)REFERENCES employee(employee ID));
第6题:
How can data quality be quantified in the data warehouse?
如何来量化数据仓库中的数据质量?
第7题:
若某企业的数据库系统中有如下所示的员工关系和仓库关系,每个仓库可有多名员工,但只有一名负责人。员工关系(cmployee):
仓库关系(warehouse):
则创建仓库表结构的SQL语句为(58)。
A.CREATE TABLE(employeeID CHAR(2)NOT NULL UNIQUE, name CHAR(30)NOT NULL, address CHAR(40), pricipallD CHAR(3));
B.CREATE warehouse(warehouseD CHAR(2)PRIMARY KEY, name CHAR(30), address CHAR(40), pficipalID CHAR(3));
C.CREATE TABLE warehouse(warehouselD CHAR(2)PRIMARY KEY, name CHAR(30)NOT NULL, address CHAR(40), pricipalID CHAR(3), FOREIGN KEY(priciPalID)REFERENCES employee(employeeID));
D.CREATE TABLE warehouse(warehouselD CHAR(2), name CHAR(30)NOT NULL, address CHAR(40), pricipalID CHAR(3), PRIMARY KEY(warehouselD), FOREIGN KEY(employeeID)REFERENCES emplo
第8题:
下列叙述不正确的是
A.DB2 Warehouse Manager是IBM数据仓库解决方案的重要组成,提供:数据访问、数据转换、数据分布、数据存储等功能
B.DB2 Warehouse Manager完全自动地把OLAP集成到数据仓库
C.利用DB2 Server Analyzer工具可以很容易地访问DB2 OLAP Server中经过处理的数据
D.DB2 OLAP Server没有把OLAP集成到数据仓库
第9题:
A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.
A.OLTPs
B.transactions
C.data sarts
D.OLAPs
第10题:
翻译:Warehouse to Warehouse Clause()