IS 3003 Exam 1 UTSA Questions With
Correct Answers | Latest Version
(2025/2026) Expert Verified
Web mining is the discovery of useful patterns on the Web. ✔✔Answer: TRUE
Diff: 1 Page Ref: 203
So, contrast this with text mining and data mining.
A grouping of characters into a word, a group of words, or a complete number is called
a record. ✔✔Answer: FALSE
A grouping of fields is a record. (The phrases used in the question are nonsensical.)
Every record in a file should contain at least one key field. ✔✔Answer: TRUE
Diff: 1 Page Ref: 188
Both Oracle and Microsoft Access use SQL to retrieve information from the database.
✔✔Answer: TRUE
Diff: 2 Page Ref: 194-195
How is SQL pronounced? (Sequel)
What does it stand for? (structured query language)
DBMS simplify how end users work with databases by separating the logical and
physical views of the data. ✔✔Answer: TRUE
Physical view of data refers to where on the hard drive the different pieces of data are
placed.
Logical view refers to the way in which we think about data - in the form of tables with
columns for each field and a row for each record.
Most back-end databases are able to interpret HTML commands. ✔✔Answer: FALSE
Diff: 1 Page Ref: 206
Front-end refers to those parts of the system which are closer to the user - the user
interface in particular.
Back-end refers to files in which the organized information is stored.
Hadoop can process large quantities of any type of data, including video and Twitter
feeds. ✔✔Answer: TRUE
Diff: 2 Page Ref: 199
Hadoop can handle both relational and non-relational data, including text, video etc:
, A data warehouse may include information from legacy systems. ✔✔Answer: TRUE
Diff: 2 Page Ref: 199
Recall data warehouses include historical data; historical data may reside in legacy
systems. (What is a legacy system?).
A data warehouse is typically comprised of several smaller data marts. ✔✔Answer:
FALSE
Diff: 2 Page Ref: 199
Data warehouse includes historic and current data from several databases.
Data mart is a subset of the data warehouse, created to try and answer specific
questions.
OLAP is used to find hidden patterns and relationships in large databases, and infer
rules from these to infer future behavior. ✔✔Answer: FALSE
Data mining is used to find hidden patterns and relationships.
A foreign key in a table of the database is a field that links to the primary key of another
table. ✔✔Answer: TRUE
Diff: 2 Page Ref: 189
In-memory computing relies on a computer's main memory (RAM) for storing data.
✔✔Answer: TRUE
Diff: 3 Page Ref: 200
Usually in-memory computing needs lots more of RAM than those systems that do not
do in-memory computing. In-memory computing is used to speed up processing of data.
A firm's information policy lays out who is responsible for updating and maintaining the
information in a database system. ✔✔Answer: TRUE
Diff: 1 Page Ref: 207
What else does the information policy include? Look it up.
The use of different terms for identifying data in a firm's various information systems is
an example of redundant data. ✔✔Answer: FALSE
Diff: 2 Page Ref: 208-209
Data cleansing is the same process as data scrubbing. ✔✔Answer: TRUE
Diff: 2 Page Ref: 208
This is done when creating a data warehouse. Data warehouses contain historic data.
Historic data over 10 or 15 years may have inconsistencies. For instance, in some
databases my name may have been entered as Chino, and in others as Srinivasan.
When you combine the two databases as part of creating the data warehouse, the
system has no way of knowing that Chino is the same as Srinivasan. So, while creating
the data warehouse, you have to go through a process of data cleansing - that is
detecting such inconsistencies (and other kinds of inconsistencies) and rectifying them.
Correct Answers | Latest Version
(2025/2026) Expert Verified
Web mining is the discovery of useful patterns on the Web. ✔✔Answer: TRUE
Diff: 1 Page Ref: 203
So, contrast this with text mining and data mining.
A grouping of characters into a word, a group of words, or a complete number is called
a record. ✔✔Answer: FALSE
A grouping of fields is a record. (The phrases used in the question are nonsensical.)
Every record in a file should contain at least one key field. ✔✔Answer: TRUE
Diff: 1 Page Ref: 188
Both Oracle and Microsoft Access use SQL to retrieve information from the database.
✔✔Answer: TRUE
Diff: 2 Page Ref: 194-195
How is SQL pronounced? (Sequel)
What does it stand for? (structured query language)
DBMS simplify how end users work with databases by separating the logical and
physical views of the data. ✔✔Answer: TRUE
Physical view of data refers to where on the hard drive the different pieces of data are
placed.
Logical view refers to the way in which we think about data - in the form of tables with
columns for each field and a row for each record.
Most back-end databases are able to interpret HTML commands. ✔✔Answer: FALSE
Diff: 1 Page Ref: 206
Front-end refers to those parts of the system which are closer to the user - the user
interface in particular.
Back-end refers to files in which the organized information is stored.
Hadoop can process large quantities of any type of data, including video and Twitter
feeds. ✔✔Answer: TRUE
Diff: 2 Page Ref: 199
Hadoop can handle both relational and non-relational data, including text, video etc:
, A data warehouse may include information from legacy systems. ✔✔Answer: TRUE
Diff: 2 Page Ref: 199
Recall data warehouses include historical data; historical data may reside in legacy
systems. (What is a legacy system?).
A data warehouse is typically comprised of several smaller data marts. ✔✔Answer:
FALSE
Diff: 2 Page Ref: 199
Data warehouse includes historic and current data from several databases.
Data mart is a subset of the data warehouse, created to try and answer specific
questions.
OLAP is used to find hidden patterns and relationships in large databases, and infer
rules from these to infer future behavior. ✔✔Answer: FALSE
Data mining is used to find hidden patterns and relationships.
A foreign key in a table of the database is a field that links to the primary key of another
table. ✔✔Answer: TRUE
Diff: 2 Page Ref: 189
In-memory computing relies on a computer's main memory (RAM) for storing data.
✔✔Answer: TRUE
Diff: 3 Page Ref: 200
Usually in-memory computing needs lots more of RAM than those systems that do not
do in-memory computing. In-memory computing is used to speed up processing of data.
A firm's information policy lays out who is responsible for updating and maintaining the
information in a database system. ✔✔Answer: TRUE
Diff: 1 Page Ref: 207
What else does the information policy include? Look it up.
The use of different terms for identifying data in a firm's various information systems is
an example of redundant data. ✔✔Answer: FALSE
Diff: 2 Page Ref: 208-209
Data cleansing is the same process as data scrubbing. ✔✔Answer: TRUE
Diff: 2 Page Ref: 208
This is done when creating a data warehouse. Data warehouses contain historic data.
Historic data over 10 or 15 years may have inconsistencies. For instance, in some
databases my name may have been entered as Chino, and in others as Srinivasan.
When you combine the two databases as part of creating the data warehouse, the
system has no way of knowing that Chino is the same as Srinivasan. So, while creating
the data warehouse, you have to go through a process of data cleansing - that is
detecting such inconsistencies (and other kinds of inconsistencies) and rectifying them.
