Deck 3: Databases and Data Warehouses

Question 1

When information is stored about a purchase or sale, what is stored in a database?

A) A transaction
B) A table
C) A view
D) A query

Answer 1

A

Question 2

Which of the following are large electronic repositories of very detailed information?

A) Libraries
B) Data compilations
C) Data collections
D) Databases

Answer 2

D

Question 3

If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) _____.

A) Identifying field
B) Relational field
C) Primary key
D) Principle key

Answer 3

C

Question 4

What application enables your organization to analyze competitor, customer, environmental, and internal data?

A) Query-by-example
B) Information analysis
C) Business intelligence
D) SQL

Question 5

Which type of application requires that you know the physical location of information before you are able to access it?

A) Database management systems
B) Database
C) Spreadsheets
D) Business intelligence

Question 6

What is the type of field, or group of fields, that can uniquely identify each record in a database?

A) Identifying
B) Relational
C) Primary key
D) Main field

Question 7

Which of the following terms represent an organized and structured collection of information?

A) Database management system
B) Database
C) Data dictionary
D) Structured query system

Question 8

Which part of a relational database contains the logical structure for the information?

A) Data dictionary
B) Relation
C) Query
D) SQL

Question 9

Which term refers to a specific piece of data that is stored in a database file?

A) Relation
B) Category
C) Class
D) Attribute

Question 10

What is the objective of business intelligence (BI)?

A) To process transactional information efficiently and effectively
B) To provide decisions makers with a great deal of information
C) To provide timely and quality information to decision makers
D) To process external information or information that is purchased from outside vendors

Question 11

Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?

A) Hierarchical
B) File-based
C) Relational
D) Conventional

Question 12

To succeed in business and to enable your organization to extract meaningful information from its information repositories, you need which type of application?

A) Query-by-example
B) Business intelligence
C) Information analysis
D) SQL

Question 13

What is another name for a database that supports OLTP?

A) Business intelligence
B) File management
C) Records management
D) Operational database

Question 14

Which application supports the manipulation of information to support decision making?

A) Online transaction processing (OLTP)
B) Records management
C) Relational database administration
D) Online analytical processing (OLAP)

Question 15

Which type of database stores data in a series of logically related two-dimensional tables or files?

A) Hierarchical
B) File-based
C) Conventional
D) Relational

Question 16

Your student ID is an example of a(n) _____.

A) Relation
B) Table
C) Business rule
D) Attribute

Question 17

Which system allows your organization to gather, process, and update transactional information?

A) Online analytical processing (OLAP)
B) Business intelligence (BI)
C) File management systems (FMS)
D) Online transaction processing (OLTP)

Question 18

What is another name for a database?

A) Information repository
B) Data depository
C) Data warehouse
D) Information depot

Question 19

A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?

A) Online analytical processing (OLAP)
B) Strategic information systems (GIS)
C) Knowledge Management
D) Customer Management

Question 20

If you needed to store facts about information that you were collecting, you would store these facts in the _____.

A) Relations
B) Database management system
C) Business rules
D) Data dictionary

Question 21

Which database management subsystem helps you create and maintain the data dictionary and define the structure of the files in a database?

A) Data definition subsystem
B) Data manipulation subsystem
C) Application generator
D) Data administration subsystem

Question 22

What must you define before adding any information to a relational database?

A) The intended audience
B) The physical hardware structure
C) The administrative rights of users
D) The logical structure of the database

Question 23

What is a data warehouse?

A) A large hardware environment that supports multiple platforms
B) A logical collection of information gathered from many different operational databases to create business intelligence
C) An operational database system used to manage and analyze transactional data
D) An accumulation of all operational data stored by large organizations

Question 24

A database management system contains five important software components. Which of the following components allows you to add, change, and delete information in a relational database?

A) Data definition subsystem
B) Application generator subsystem
C) Data administration subsystem
D) Data manipulation subsystem

Question 25

Every primary key can also be a _____ key.

A) Foreign
B) Secondary
C) Identifying
D) Relational

Question 26

If you were comparing information from various divisions of an organization for instance, sales, marketing, and production, what type of information repository would you most likely work with?

A) Data mart
B) Data warehouse
C) Hypercube database
D) Data mining

Question 27

A database management system contains five important software components. Which of the following components allows you to define the structure of a database?

A) Data definition subsystem
B) Data manipulation subsystem
C) Application generator subsystem
D) Data administration subsystem

Question 28

Which type of environment allows you to go beyond operational database systems to support business intelligence?

A) Transactional systems
B) Application generators
C) Data Warehouses
D) Relational DBMS

Question 29

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

A) Programming query
B) Automatic module generator
C) Application generation subsystem
D) Fast programming

Question 30

Which type of constraint ensures the quality of information in a relational database?

A) Environmental
B) Business constraint
C) Integrity constraint
D) Production constraint

Question 31

Which data manipulation tool allows you to graphically design the answer to your business questions?

A) Report generators
B) Application reports
C) Query-by-example tools
D) Data administration tools

Question 32

Which database management subsystem is responsible for backup and recovery, security management, query optimization, concurrency control, and change management?

A) Application management
B) Data administration
C) Data management
D) Data optimization

Question 33

Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?

A) Query tools
B) Data administration tools
C) Report generators
D) Application reports

Question 34

What is SQL?

A) A fourth generation language found in most DBMSs
B) A storage tool that holds the data and definitions for a database
C) An administrative tool that allows you to set access rights for database users
D) A programming language that can be used instead of a DBMS

Question 35

If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?

A) Logical view
B) Physical view
C) Stored view
D) Objective view

Question 36

If you were able to quickly pull information from student records with course records to build students' schedules, you would be using a _____ tool.

A) Data administration
B) Query-by-example
C) Data definition
D) Data manipulation

Question 37

What is the purpose of a data warehouse?

A) Backup and recovery
B) To support decision making and OLAP
C) To support transaction processing and OLTP
D) To support, backup and recovery, OLAP, and OLTP

Question 38

If you were looking at information in a database and you are able to see only the information you needed in the format you wanted, what type of database view would you see?

A) Logical view
B) High-level view
C) User view
D) Physical view

Question 39

Which of the following systems contain information from multiple databases?

A) Data warehouses
B) Data marts
C) OLTPs
D) Data warehouses and data marts

Question 40

A database management system contains five important software components. Which of the following components accepts and processes requests from the other four database components?

A) DBMS engine
B) Data definition subsystem
C) Data manipulation subsystem
D) Data administration subsystem

Question 41

When business intelligence is focused on the external competitive environment, it is known as _____.

A) External information
B) Trends
C) Competitive intelligence
D) Competitor knowledge

Question 42

Which organizational function is responsible for developing security procedures for an organization?

A) Data security
B) Data protection
C) Information resource management
D) Database administration

Question 43

In a data warehouse, which tool would you use to build reports quickly and without having to write programming code?

A) Application generator
B) Intelligent agents
C) Multidimensional analysis tools
D) Query-and-reporting tools

Question 44

In a data warehouse, which artificial intelligence tool allows you to discover information and build intelligence?

A) Query-by-example
B) Query-and-reporting
C) Hypercube
D) Intelligent agent

Question 45

Which of the following contains a subset of a data warehouse in which only a focused portion of the data is kept?

A) Data mart
B) Intelligent agent
C) Business intelligent subsystem
D) Operational database

Question 46

Which data warehouse tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives?

A) Query-and-reporting
B) Intelligent agents
C) OLTP
D) Multidimensional analysis

Question 47

If you were to perform a regression analysis, what type of data warehouse tool would you use?

A) Statistical
B) Multidimensional analysis
C) Production analysis
D) Hypercube

Question 48

What is a digital dashboard?

A) A new type of electronic dashboard for high-priced cars that displays GPS information alongside of traditional information
B) A learning environment for online educational courses
C) A computer tool that provides competitive information from external sources
D) A computer screen that provides tailored, current snapshots of information and trends

Question 49

What is the difference between data administration and database administration?

A) Data administration focuses on strategic management whereas database administration focuses on operational issues
B) Data administration focuses on OLTP whereas database administration focuses on OLAP
C) Data administration and database administration are terms that can be used interchangeably
D) Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data

Question 50

Data-mining tools include all but which of the following?

A) Query-and-reporting
B) Intelligent agents
C) Data manipulation
D) Statistical

Question 51

What is a hypercube?

A) A hyper text link stored in a database
B) Data definitions that are linked to other related, but external, attributes or fields
C) Database that is built on Internet technology
D) Multidimensional representation of information

Question 52

Which of the following functions plans for, oversees the development of, and monitors the information resources of an organization?

A) Strategic management
B) Data administration
C) Information resource planning
D) Operational planning

Question 53

Which organizational function is responsible for the more technical and operational aspects of managing information repositories?

A) Database administration
B) Strategic management
C) Information resource planning
D) Operational planning

Question 54

What is the difference between multidimensional analysis and statistical analysis?

A) Multidimensional analysis is a higher level of mathematical analysis than normal statistical analysis
B) Multidimensional analysis uses a form of fuzzy logic whereas statistical analysis is objective
C) Statistical analysis requires a step-by-step approach to data analysis; multidimensional analysis does not
D) Statistical analysis is a mathematical approach to understanding information; multidimensional analysis is a way of viewing information from different perspectives

Question 55

Which of the following is a smaller, more focused data warehouse?

A) Data warehouse
B) Data mart
C) Operational database
D) OLAP

Question 56

What type of software tool is used to query information stored in a data warehouse?

A) OLTP
B) Analytical
C) Data-mining
D) Decision support

Question 57

What does it mean for a data warehouse to be multidimensional?

A) The database stores data, facts, and definitions for all stored information
B) Data can be linked to other sources of internal and external information
C) The files stored in a warehouse contain multiple layers of columns and rows
D) Customer information can be related to sales, departmental, and organizational information

Question 58

What is the term used to describe the sharing of information regardless of title or department.

A) Open source
B) Data mining
C) Information sharing
D) Data distribution

Question 59

If you were viewing information from different perspectives, you would be _____.

A) Turning the cube
B) Making decisions
C) Creating hyperlinks
D) Applying fuzzy logic

Question 60

If you were working for a large pharmaceutical company and building a sales report on current prescription writing habits of doctors, what type of information repository would you be most likely working with?

A) Data warehouse
B) Operational database
C) Transactional database
D) Data mart

Question 61

Online analytical processing (OLAP) is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.

Question 62

A data dictionary is a two-dimensional table used to store data within a relational database.

Question 63

If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database, the database will typically generate an error message. This message indicates that an integrity constraint has been violated.

Question 64

Business intelligence is knowledge about your customers, your competitors, your partners, your competitive environment, and your own internal operations.

Question 65

Assume you have an order entry database with an Order file and a Customer file. The Order Date field most likely would be the common field used to relate the two files.

Question 66

If an employee needs to change the details of a specific customer order, he/she would use OLTP (online transaction processing).

Question 67

If your student information had two different birth dates for you, your data would not be considered _____.

A) Legitimate
B) Correct
C) Clean
D) Acceptable

Question 68

The acronym DBMS stands for Database Marketing System and is a type of database designed to support the marketing function within a business.

Question 69

A relational database model uses a series of logically related two-dimensional tables or files to store information in the form of a database.

Question 70

A database management system (DBMS) allows you to specify the logical organization for a database and access and use the information within a database.

Question 71

A database actually consists of two distinct parts: information and the logical structure of that information.

Question 72

There can be duplicate primary keys in the same file in a database.

Question 73

A key consideration in today's business environment is ______ or the assigning of responsibility for ensuring the quality of information.

A) Accountability
B) Information ownership
C) Data security
D) Data management and control

Question 74

A physical view represents how the users view the data.

Question 75

XYZ, Corp. would like to determine advertising strategies for customers who buy high-priced products. It would use OLTP on its data warehouse.

Question 76

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

Question 77

Operational databases are databases that support OLAP.

Question 78

Foreign keys uniquely identify records.

Question 79

A primary key is a field that uniquely describes each record.

Question 80

The logical view of information focuses on how you arrange and access information to meet the needs of the business.