Deck 3: Databases and Data Warehouses: Building Business

Question 1

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 1

C

Question 2

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

Answer 2

A

Question 3

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)

Answer 3

D

Question 4

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

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

Question 5

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 6

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

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

Question 7

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 8

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 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

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

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

Question 11

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 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

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 14

What is another name for a database?

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

Question 15

What is another name for a database that supports OLTP?

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

Question 16

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

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

Question 17

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

Question 18

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 19

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 20

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 21

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 22

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 23

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 24

If you were looking at information in a database and you 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 25

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 26

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 27

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 28

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 29

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 30

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

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

Question 31

Every primary key can also be a _____ key.

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

Question 32

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

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

Question 33

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 34

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 35

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 36

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 37

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 38

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 39

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 40

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 41

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 42

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 43

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 44

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 45

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 46

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

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

Question 47

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 48

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 49

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 50

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

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

Question 51

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 52

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 53

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

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

Question 54

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

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

Question 55

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 56

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 57

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 58

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 59

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 60

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 61

A database is a collection of information that you organize and access according to the logical structure of that information.

Question 62

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

Question 63

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

Question 64

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 65

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 66

A database actually consists of three parts: information,the logical structure of that information,and tables.

Question 67

Operational databases are databases that support OLAP.

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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 73

A physical view represents how the users view the data.

Question 74

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 75

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 76

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 77

Foreign keys uniquely identify records.

Question 78

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

Question 79

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 80

A primary key must consist of one and only one field.