Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MS Exam 2 > Chapter 6 > Flashcards

Chapter 6 Flashcards

1
Q

Web mining is the discovery of useful patterns on the Web.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Both Oracle and Microsoft Access use SQL to retrieve information from the database.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

DBMS simplify how end users work with databases by separating the logical and physical views of the data

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Most back-end databases are able to interpret HTML commands

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Hadoop can process large quantities of any type of data, including video and Twitter feeds.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The two key services of Hadoop are HDFS and in-memory computing

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A data warehouse may include information from legacy systems

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

A data warehouse is typically compromised of several smaller data marts

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

OLAP is a key tool of BI

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

OLAP is used to find hidden patterns and relationships in large databases, and infer rules for these to infer future behavior

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A foreign key is a field that links to a separate table.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

In-memory computing relies on a computer’s main memory for storing data

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Implementing a Web interface for a database requires changes to the database itself

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

True

17
Q

In linking databases to the Web, the role of the application sever is to host the DBMS.

A

False

18
Q

A firm’s information policy lays out who is responsible for updating and maintaining the information in a database system

A

True

19
Q

The use of different terms for identifying data in a firm’s various information systems is an example of redundant data.

A

False

20
Q

Data cleansing is the same process as data scrubbing

A

True

21
Q

MongoDB and SimpleDB are both examples of:

A) open-source databases
B) SQL databases
C) NoSQL databases
D) Cloud databases

A

C

22
Q

An example of a pre-digital database is a:

A) library’s card-catalog
B) cash register receipt
C) doctor’s office invoice
D) list of sales totals on a spreadsheet

A

A

23
Q

What is the first step you should take in managing data for a firm?

A) identify the data needed to run the business
B) cleanse the data before importing it to any database
C) normalize the data before importing to a database
D) audit your data quality

A

A

24
Q

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 ADDRESS
C) the entity PRODUCT with the attribute PURCHASE
D) the entity PRODUCT with the attribute CUSTOMER

A

B

25
Q

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

A) two-tiered DBMS
B) pre-digital DBMS
C) relational DBMS
D) hierarchical DBMS

A

C

26
Q

What are the relationships that are relational database is named for?

A) relationships between rows and columns
B) relationships between entities
C) relationships between fields and records
D) relationships between databases

A

B

27
Q

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

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

A

D

28
Q

The most basic business database is comprised of:

A) three tables: for suppliers, parts, and sales
B) four tables: for customers, suppliers, parts, and sales
C) four tables: for customers, suppliers, sales, and employees
D) five tables: for customers, employees, suppliers, parts, and sales

A

D

29
Q

In a table for customers, the information about a single customer would reside in a single:

A) field
B) row
C) column
D) table

A

B

30
Q

In a relational database, a record is also called a(n):

A) tuple
B) row
C) entity
D) field

A

A

MS Exam 2 (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions