CIB 4203 - Chapter 4 Exam Questions and
Correct Answers
Most databases share a common structure.
List 3 components of it. - ANSWER 1- Files (tables)
2- Records (rows)
3- Fields (columns)
*______ hold information on a single topic such as customers, products, transactions or service
requests.*
A. Files (tables)
B. Records (rows)
C. Fields (columns) - ANSWER Files (tables)
*Each ______ contains a number of records (rows).*
A. File (table)
B. Record (row)
C. Field (column) - ANSWER File (table)
*Each ______ contains a number of elements of data.*
A. File (table)
B. Record (row)
C. Field (column) - ANSWER Record (row)
*Elements of data are arranged in common set of ______ across the table.*
,A. Files (tables)
B. Records (rows)
C. Fields (columns) - ANSWER Fields (columns)
Building a customer-related database consists of 6 phases.
List them. - ANSWER 1- Define the database functions
2- Define the information requirements
3- Identify the information sources
4- Select the database technology and hardware platform
5- Populate the database
6- Maintain the database
*______ are defined by the CRM-related purposes for which data is acquired, enhanced,
stored, distributed and used.*
A. Database functions
B. Information requirements - ANSWER Database functions
*______ CRM uses data to identify target customers*
A. Strategic
B. Operational
C. Analytical
D. Collaborative - ANSWER Strategic
*______ CRM uses data to help in the everyday running of the business.*
A. Strategic
B. Operational
C. Analytical
, D. Collaborative - ANSWER Operational
*______ CRM uses customer related data to support marketing, sales, and services decisions.*
A. Strategic
B. Operational
C. Analytical
D. Collaborative - ANSWER Analytical
*______ CRM uses operational and analytical data with the partners to align their efforts to
serve end-customers.*
A. Strategic
B. Operational
C. Analytical
D. Collaborative - ANSWER Collaborative
Data is organized into 2 subsets.
List them. - ANSWER 1- OLTP (online transaction processing) databases
2- OLAP (online analytical processing) databases
*Analytical data resides in an ______ database.*
A. OLTP (online transaction processing)
B. OLAP (online analytical processing) - ANSWER OLAP (online analytical processing)
*The information in the ______ database is normally a summarized extract of the ______
database, enough to perform the analytical tasks.*
A. OLTP, OLAP
B. OLAP, OLTP - ANSWER OLAP, OLTP
Correct Answers
Most databases share a common structure.
List 3 components of it. - ANSWER 1- Files (tables)
2- Records (rows)
3- Fields (columns)
*______ hold information on a single topic such as customers, products, transactions or service
requests.*
A. Files (tables)
B. Records (rows)
C. Fields (columns) - ANSWER Files (tables)
*Each ______ contains a number of records (rows).*
A. File (table)
B. Record (row)
C. Field (column) - ANSWER File (table)
*Each ______ contains a number of elements of data.*
A. File (table)
B. Record (row)
C. Field (column) - ANSWER Record (row)
*Elements of data are arranged in common set of ______ across the table.*
,A. Files (tables)
B. Records (rows)
C. Fields (columns) - ANSWER Fields (columns)
Building a customer-related database consists of 6 phases.
List them. - ANSWER 1- Define the database functions
2- Define the information requirements
3- Identify the information sources
4- Select the database technology and hardware platform
5- Populate the database
6- Maintain the database
*______ are defined by the CRM-related purposes for which data is acquired, enhanced,
stored, distributed and used.*
A. Database functions
B. Information requirements - ANSWER Database functions
*______ CRM uses data to identify target customers*
A. Strategic
B. Operational
C. Analytical
D. Collaborative - ANSWER Strategic
*______ CRM uses data to help in the everyday running of the business.*
A. Strategic
B. Operational
C. Analytical
, D. Collaborative - ANSWER Operational
*______ CRM uses customer related data to support marketing, sales, and services decisions.*
A. Strategic
B. Operational
C. Analytical
D. Collaborative - ANSWER Analytical
*______ CRM uses operational and analytical data with the partners to align their efforts to
serve end-customers.*
A. Strategic
B. Operational
C. Analytical
D. Collaborative - ANSWER Collaborative
Data is organized into 2 subsets.
List them. - ANSWER 1- OLTP (online transaction processing) databases
2- OLAP (online analytical processing) databases
*Analytical data resides in an ______ database.*
A. OLTP (online transaction processing)
B. OLAP (online analytical processing) - ANSWER OLAP (online analytical processing)
*The information in the ______ database is normally a summarized extract of the ______
database, enough to perform the analytical tasks.*
A. OLTP, OLAP
B. OLAP, OLTP - ANSWER OLAP, OLTP
