Deck 6: Databases and Information Management

Question 1

A more rigorous definition of a database is a collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant data.

Answer 1

True

Question 2

Each characteristic or quality describing a particular entity is called an attribute.

Answer 2

True

Question 3

Oracle Database Lite is a DBMS for small,handheld computing devices.

Answer 3

True

Question 4

A group of bytes,called a bit,represents a single character,which can be a letter,a number,or another symbol.

Question 5

A DBMS reduces data redundancy and inconsistency by maximizing isolated files in which the same data are repeated.

Question 6

Microsoft SQL Server are relational DBMS for large mainframes and mid-range computers.

Question 7

The use of a traditional approach to file processing encourages each functional area in a corporation to develop specialized applications.

Question 8

Data inconsistency is where the same attribute may have different values.

Question 9

A bit represents the smallest unit of data a computer can handle.

Question 10

Each characteristic or quality describing a particular entity is called an attribute.

Question 11

A group of related files makes up a database.

Question 12

Program-data independence refers to the coupling of data stored in files and the specific programs required to update and maintain those files so that changes in programs require changes to the data.

Question 13

Rows are commonly referred to as records or,in technical terms,as tulips.

Question 14

A grouping of characters into a word,a group of words,or a complete number is called a record.

Question 15

A traditional file system can deliver routine scheduled reports after extensive programming efforts;it can also deliver ad hoc reports or respond to unanticipated information requirements in a timely fashion.

Question 16

Microsoft Access is a relational DBMS for desktop systems.

Question 17

Data redundancy is the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location.

Question 18

Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.

Question 19

A group of records of the same type is called a file.

Question 20

A group of related fields,such as a student's name,the course taken,date,and grade,comprises a file.

Question 21

In a Web-based database,middleware is used to transfer information from the organization's internal database back to the Web server for delivery in the form of a Web page to the user.

Question 22

OODBMS are slower than relational DBMS.

Question 23

One of the drawbacks to OODBMS are that they cannot work with applets.

Question 24

OLAP is a key tool of BI.

Question 25

A data warehouse is typically comprised of several smaller data marts.

Question 26

Most DBMS have a specialized language called a data manipulation language that is used to add,change,delete,and retrieve the data in the database.

Question 27

The most prominent data manipulation language today is Structured Query Language (SQL).

Question 28

DBMS designed for organizing structured data into rows and columns are not well suited to handling graphics-based or multimedia applications.

Question 29

Many applications today require databases that can store and retrieve multimedia.

Question 30

OLAP enables users to obtain online answers to ad hoc questions in a fairly rapid amount of time,except when the data are stored in very large databases.

Question 31

An object-oriented DBMS stores the data and procedures that act on those data as objects that can be automatically retrieved and shared.

Question 32

Every record in a file should contain at least one key field.

Question 33

A data dictionary is a language associated with a database management system that end users and programmers use to manipulate data in the database.

Question 34

A data warehouse may be updated by a legacy system.

Question 35

The select operation creates a subset consisting of columns in a table,permitting the user to create new tables that contain only the information required.

Question 36

A Web interface requires changes to the internal database.

Question 37

Every table in a relational database has one field designated as it key field.

Question 38

A DBMS separates the logical and physical views of the data.

Question 39

Predictive analysis is synonymous with data mining.

Question 40

In a relational database,complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

Question 41

Data cleansing is the same process as data scrubbing.

Question 42

The select,join,and project operations enable data from two different tables to be combined and only selected attributes to be displayed.

Question 43

Users access an organization's external database through the Web using their desktop PCs and Web browser software.

Question 44

Jane Clark is student at the university.Jane is also employed by the university library.Jane got married two weeks ago and her new last name is Jones.Jane receives her work cheque in the mail addressed to Jane Clark but her grades that come in the mail are addressed Jane Jones.This is an example of ________ of Jane's information.

A)data bits
B)program-data independence
C)data sort
D)data inconsistency

Question 45

A relational database organizes data in the form of two-dimensional tables.

Question 46

Which of the following is NOT one of the main problems with a traditional file environment?

A)data inconsistency
B)program-data independence
C)lack of flexibility in creating ad hoc reports
D)poor security

Question 47

Data access deals with the policies and processes for managing the availability,usability,integrity,and security of the data employed in an enterprise.

Question 48

Text mining is the discovery of patterns and relationships from large sets of unstructured data-the kind of data we generate in e-mails,phone conversations,blog postings,online customer surveys,and tweets.

Question 49

Unlike structured data,which are generated from events such as completing a purchase transaction,unstructured data have no distinct form.

Question 50

A group of bits,called a ________,represents a single character,which can be a letter,a number,or another symbol.

A)bit
B)field
C)record
D)byte

Question 51

How organizations store,organize,and manage their data has a tremendous impact on organizational effectiveness.

Question 52

A ________ represents the smallest unit of data a computer can handle.

A)bit
B)field
C)record
D)byte

Question 53

The data warehouse extracts current and future data from multiple operational systems inside the organization.

Question 54

A normalized relation contains repeating groups.

Question 55

Governments around the world are opening up their data stores to the public.

Question 56

A grouping of characters into a word,a group of words,or a complete number (such as a person's name or age)is called a ________.

A)bit
B)field
C)record
D)byte

Question 57

A group of records of the same type is called a ________.

A)bit
B)field
C)record
D)file

Question 58

Common Gateway Interface is a specification for processing data on a Web server.

Question 59

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

Question 60

A group of related fields,such as a student's name,the course taken,date,and grade,comprises a ________.

A)bit
B)field
C)record
D)byte

Question 61

The confusion created by ________ makes it difficult for companies to create customer relationship management,supply chain management,or enterprise systems that integrate data from different sources.

A)batch processing
B)data redundancy
C)data independence
D)online processing

Question 62

Darren Pepper works for a large medical clinic.They are running out of five-digit patient numbers and they want to expand the patient number to seven digits.It will cost a great deal of money to make this switch because three of the clinic's programs will no longer work with this new number of digits in the patient number.The clinic is using a traditional file system.This is an example of ________.

A)program-data dependence
B)lack of flexibility
C)poor security
D)lack of data sharing and availability

Question 63

Jess Wilde works for a large law firm.Every week he gets reports on the cases each lawyer in the firm is working on.He wants to get the files that deal with billing hours for each lawyer and combine that information with the files on individual cases that each lawyer is working on.He discovers that information cannot flow freely across different parts of the organization in this traditional file system.This is an example of ________.

A)program-data dependence
B)lack of flexibility
C)poor security
D)lack of data sharing and availability

Question 64

The Giant Hardware Company sells four different products - screws,nails,hammers,and bolts - in the East,West,and Prairie regions.They want to know how many hammers sold in each of their sales regions and compare actual results with projected sales.What tools should they use to analyze the data?

A)OLAP
B)data mining
C)predictive analysis
D)text mining

Question 65

Which of the following best illustrates the relationship between entities and attributes?

A)the entity CUSTOMER with the attribute PRODUCT
B)the entity CUSTOMER with the attribute PURCHASE
C)the entity PRODUCT with the attribute PURCHASE
D)the entity PRODUCT with the attribute CUSTOMER

Question 66

Duplicate data in multiple data files is called data ________.

A)redundancy
B)repetition
C)independence
D)partitions

Question 67

Don Gibb works for a large retail chain.Every month he gets reports on the wages in each store across Canada.He notices that one employee received a 20 percent raise.He calls payroll to find who put this raise into the traditional file system.He is told that there is no way to know who entered that raise in the system.This is an example of ________.

A)program-data dependence
B)lack of flexibility
C)poor security
D)lack of data sharing and availability

Question 68

A government agency wants to analyze their data.Their data consists of e-mail,memos,survey responses,legal cases,patent descriptions,and service reports.What tools should they use to analyze their data?

A)OLAP
B)data mining
C)predictive analysis
D)text mining

Question 69

A DBMS makes the

A)physical database available for different logical views.
B)logical database available for different analytical views.
C)physical database available for different analytical views.
D)relational database available for different physical views.

Question 70

The Bank of Canada has large amounts of data collected over many years.It wants to get value from this data.They decide they want to analyze this large amount of data.They don't have any particular question in mind,they just want to find out if there are any hidden trends in the data.What tools should they use to analyze the data?

A)OLAP
B)data mining
C)predictive analysis
D)text mining

Question 71

Gord Smith works for a large pizza chain.Every week he gets reports on the sales in each store across Canada.He sees a problem in one of the stores in Ontario.He wants and ad hoc report for sales at that store after 9 p.m.on weekdays.He is told that no such report can be created by the traditional file system.This is an example of ________.

A)program-data dependence
B)lack of flexibility
C)poor security
D)lack of data sharing and availability

Question 72

Oracle Database Lite is a(n)

A)DBMS for small handheld computing devices.
B)Internet DBMS.
C)mainframe relational DBMS.
D)DBMS for midrange computers.

Question 73

Microsoft SQL Server is a(n)

A)DBMS for small handheld computing devices.
B)Internet DBMS.
C)desktop relational DBMS.
D)DBMS for midrange computers.

Question 74

DBMS for midrange computers include all of the following EXCEPT

A)DB2.
B)Oracle.
C)Microsoft SQL Server.
D)Microsoft Access.

Question 75

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

A)OODBMS.
B)pre-digital DBMS.
C)relational DBMS.
D)hierarchical DBMS.

Question 76

The logical view

A)shows how data are organized and structured on the storage media.
B)presents an entry screen to the user.
C)allows the creation of supplementary reports.
D)presents data as they would be perceived by end users.

Question 77

________ recognizes patterns that describe the group to which an item belongs by examining existing items that have been classified and by inferring a set of rules.

A)Classification
B)Associations
C)Clustering
D)Sequences

Question 78

Frito Lay wants to introduce a new flavour of potato chips in Canada.They have a great deal of data to help them make the decision to introduce this flavour.They plan on using data-mining techniques,historical data,and assumptions about future conditions to predict outcomes of introducing the new flavour.What tools should they use to analyze the data?

A)OLAP
B)data mining
C)predictive analysis
D)text mining

Question 79

A characteristic or quality describing an entity is called a(n)

A)field.
B)tuple.
C)key field.
D)attribute.

Question 80

A DBMS reduces data redundancy and inconsistency by

A)enforcing referential integrity.
B)uncoupling program and data.
C)utilizing a data dictionary.
D)minimizing isolated files with repeated data.