Deck 5: Database Systems, Data Centres, and Business Intelligence

Question 1

The business user asks the data analyst for a database to capture information about all the customers including personal information.In preparation, the data analysis identifies the list of attributes to be used for the database.What is the name of this list?

A)a data definition
B)a data extract
C)a schema
D)a record

Answer 1

C

Question 2

A consultant has been hired to help a company identify a specific requirement for a project.The consultant sets out to identify the informational elements including its usage and access.What method is this being used?

A)logical analysis
B)physical design
C)data modelling
D)business plan

Answer 2

C

Question 3

The business systems analyst has identified a data modelling approach to help in the understanding of the business requirements.What is an example of a tool to help in the data modelling?

A)logical drawing
B)physical drawing
C)entity-relationship diagram
D)information model diagram

Answer 3

C

Question 4

Jane and her two friends plan to take three courses next semester including Accounting.Each of the courses at the university can accommodate a maximum of 40 students.In data modelling, what would be the relationship between course and student?

A)one to one
B)one to many
C)many to one
D)many to many

Question 5

What type of data manipulation involves eliminating rows in a relational database?

A)selecting
B)joining
C)projecting
D)linking

Question 6

What is a database a collection of?

A)integrated and related fields
B)integrated and related files
C)integrated and related records
D)integrated and related attributes

Question 7

Which of the following is a visual approach to developing database requests?

A)concurrency control
B)query by example
C)natural language command
D)structured query language

Question 8

What is a database?

A)a decision tool
B)a strategy to reduce costs
C)an organized collection of unprocessed information
D)a group of programs

Question 9

In creating a database, a system analyst creates several entities and for each of the entity creates a list of attributes.For each attribute, the system analyst is given certain constraints as to the valid values that can be used.What is the term used to refer to these constraints?

A)restrictions
B)domains
C)exceptions
D)lists

Question 10

There are rules in Canada that require companies to report serious incidents related to their DBMS product once it is installed and used.Where would such a report, be sent?

A)Statistics Canada
B)Health Canada
C)the provincial government
D)the municipal government

Question 11

What is the smallest piece of data used by a computer?

A)a terabyte
B)a field
C)a character
D)a bit

Question 12

What is a collection of fields about a specific object called?

A)an attribute
B)a file
C)a record
D)a primary key

Question 13

In order to generate a report, Jane identifies the name of the database as well as the attributes.She then uses a set of commands and writes out a sentence to be executed.What is the term for this method of data manipulation?

A)query by example
B)direct command
C)visual command
D)structured query language

Question 14

What standardized data manipulation language, developed in the 1970s, allows programmers to use one powerful language on a variety of systems?

A)Java
B)C++
C)DML
D)SQL

Question 15

What tool do database designers use to show the logical mapping among data?

A)a framework
B)a decision table
C)a relational model
D)a domain diagram

Question 16

Which of the following terms refers to the logical and physical structure of the data and the relationships among the data for each user?

A)entity relationship diagram
B)schema
C)data model
D)data manipulation language

Question 17

Ali created a report for an instructor that lists all student marks for three tests, a midterm, and a final exam for the Winter term.The instructor asks Ali to modify the report to include only the three tests.What type of data manipulation would that involve?

A)selecting
B)projecting
C)joining
D)linking

Question 18

The tables in a relational database can be linked to provide useful information and reports so long as they share which of the following?

A)one common primary key
B)one common file
C)one common characteristic
D)one common attribute

Question 19

One of the rules at the university is that students are given an ID card bearing their names.The card is not transferable and if the student loses the card, it can be replaced for a fee.In data modelling, what is the relationship between student and ID card?

A)one to one
B)one to many
C)many to one
D)many to many

Question 20

In many organizations, information is stored in more than one location, which makes it difficult to maintain because there is much duplication.What is the term used to refer to this problem in data?

A)integrity
B)accuracy
C)redundancy
D)validation

Question 21

Which of the following stores the database on a service provider's server and allows the client to access the database over a network?

A)Internet access
B)database as a service
C)software as a service
D)Oracle database system

Question 22

A DBMS provides one of many points of management and control over data resources.

Question 23

During payroll processing, the system crashed and the operator concluded that the payroll system had integrity issues.Who will be called first to fix the problem?

A)the database administrator
B)the data administrator
C)the software vendor
D)the business systems analyst

Question 24

What is the term for the steps an organization takes to protect information sought by unauthorized parties?

A)data loss prevention
B)security measures
C)counterintelligence
D)competitive intelligence

Question 25

Who is responsible for planning, designing, creating, operating, securing, monitoring, and maintaining databases?

A)data owners
B)data analysts
C)database power users
D)database administrators

Question 26

What is the primary consideration when selecting a database management system for an organization?

A)the low maintenance of the system
B)the number of awards received by the database vendor
C)the information needs of the organization
D)the availability of support staff to manage the system

Question 27

Which of the following employs multidimensional databases to efficiently store and deliver data warehouse information?

A)a data mart
B)data mining
C)distributed database
D)online analytical processing

Question 28

What application of data mining identifies the products and services most commonly purchased at the same time?

A)customer churn
B)direct marketing
C)market basket analysis
D)business intelligence tool

Question 29

In what type of database can data be spread across several smaller databases connected through telecommunications devices?

A)data mart
B)distributed database
C)replicated database
D)data synchronizer

Question 30

The senior executives of a multinational company just received the quarterly financial report of their company broken down by country; each country was broken down further by region.The data collected was aggregated and presented in an efficient manner.What type of tool was used to generate this report?

A)data mining
B)online analytical processing
C)object-oriented data analysis
D)virtual analytical methods

Question 31

Which of the following contains a subset of data for a single aspect of a company's business and is used by smaller groups who want to access detailed data for business analysis?

A)an OLTP database
B)a data warehouse
C)a data mart
D)a data extract

Question 32

Which of the following terms refers to the manipulation of data to gain increasing levels of detail about business conditions?

A)aggregation
B)drill down
C)slicing
D)extraction

Question 33

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Question 34

What type of database systems have companies such as IBM developed to allow different databases to work together as a unified system?

A)relational
B)distributed
C)replicated
D)virtual

Question 35

A database provides an essential foundation for an organization's information and decision support systems.

Question 36

What information-analysis tool involves the automated discovery of patterns and relationships in a data warehouse?

A)data mining
B)DBMS
C)competitive intelligence
D)data loss prevention

Question 37

Which of the following typically stores three to ten years of historical summary data records from many operational systems and external data sources so that it can be used for business analysis?

A)an organizational file
B)a database
C)a data warehouse
D)a knowledge base

Question 38

Who is responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization?

A)data analysts
B)data administrators
C)database power users
D)database administrators

Question 39

What is the name given to a system used to analyze financial and operating data?

A)data mining
B)data modelling
C)business intelligence
D)business database systems

Question 40

Which of the following processes uses a database to store and access data according to the locations it describes, and permits related queries and analysis?

A)data mining
B)data modelling
C)relational data extract
D)spatial data technology

Question 41

The raw data necessary to make sound business decisions is stored in a variety of locations and formats.

Question 42

The DBMS serves as an interface between an application program and the database.

Question 43

Today, most organizations use the database approach to data management, where multiple information systems share a pool of related data.

Question 44

The domain for pay rate would include both positive and negative numbers.

Question 45

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and data to be organized more logically.

Question 46

A database need not reflect the business processes of the organization.

Question 47

Entity-relationship diagrams are a useful database design tool.

Question 48

Oracle is currently the market leader in general-purpose databases, with about three-quarters of the multibillion-dollar database market.

Question 49

Identifying who will have access to a database has little impact on organizing a database.

Question 50

A record is a collection of fields about a specific object.

Question 51

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Question 52

In the relational model, each row of a table represents a data entity or record and each column of the table represents an attribute or field.

Question 53

One of the first steps in installing and using a large database involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

Question 54

Data centres are approaching the point of automation, where they can run and manage themselves while being monitored remotely in a "lights out" environment.

Question 55

The database administrator decides the contents of the database with little or no input from the users of the database.

Question 56

Database management systems cost in excess of $1,000.

Question 57

Business and technology vendors are working to develop blue data centres that run more efficiently and require less energy for processing and cooling.

Question 58

Due to their size, databases must be stored on mainframe computers or other large, powerful computers.

Question 59

Projecting involves eliminating columns in a table.

Question 60

Carrying summary totals in the data records is an example of planned data redundancy.

Question 61

Reader's Digest Canada's use of data in order to gain a better understanding of its major market segments is an example of data mining.

Question 62

A data warehouse is used to support decision making while an OLTP database is used to support transaction processing.

Question 63

____________________ involves combining two or more tables in a relational database.

Question 64

Online analytical processing and data mining are essentially the same.

Question 65

A data centre that is fully automated to the extent that it can run and manage itself while being monitored remotely is said to operate in a(n) ____________________ environment.

Question 66

Business intelligence turns data into useful information that is then kept closely guarded to prevent it falling into the hands of the wrong employees.

Question 67

Competitive intelligence is gained through industrial espionage; the gathering of this information often includes illegal or unethical means.

Question 68

The ____________________ data model has become the most popular database model.

Question 69

A data warehouse stores historical data that has been extracted from operational systems and external sources.

Question 70

A(n) ____________________ is a field or set of fields that uniquely identifies a record.

Question 71

The allowable values for an attribute are called its ____________________.

Question 72

Better access to data and information and improved data integrity are two advantages of the ____________________ approach.

Question 73

A(n) ____________________ is a climate-controlled building that houses database servers and systems that deliver mission-critical information and services.

Question 74

A database design where certain data entities are combined, summary totals are carried in the data records rather than calculated, and some data attributes are repeated in more than one data entity exhibits what is called planned ____________________.

Question 75

Data mining involves the automated discovery of patterns and relationships in a data warehouse.

Question 76

A collection of related records is called a(n) ____________________.

Question 77

A report from IDC estimates that the amount of information humanity creates will grow by a factor of ____________________ between 2009 and 2020.

Question 78

A(n) ____________________ is typically a name, number, or combination of characters that describes an aspect of a business object.

Question 79

Without a well-designed, accurate database, executives, managers, and others do not have access to the ____________________ they need to make good decisions.

Question 80

In the relational data model, each column of a table represents a(n) ____________________.