Deck 14: Ecommerce, Databases, and Data Science

Question 1

Opening an online store requires at least the same amount of planning than building another physical store location.

Answer 1

True

Question 2

To manage a relational table, you need only be able to add new tuples to the table and delete tuples from a table.

Answer 2

False

Question 3

The number-one attraction to online shopping is probably ____.

A)speed
B)lower cost
C)the ability to view products
D)convenience

Answer 3

D

Question 4

Authentication is the process of verifying the identity of the receiver of the data._________________________

Question 5

In the ____ world, customers have quick, easy, and secure access to purchasing items and paying for services through the World Wide Web.

A)e-transactions
B)ecommerce
C)web commerce
D)virtual commerce

Question 6

A disk input/output (I/O)operation is a much slower process than accessing information stored in main memory, sometimes by as much as three or four orders of magnitude._________________________

Question 7

____ is an online coupon site.

A)iTunes
B)PayPal
C)Craigslist
D)Groupon

Question 8

The SQL command to create a table only requires specification of the various attributes by name and data type.

Question 9

A database management system works much like a simple file manager.

Question 10

Accessing a record in a large file involves at least one disk input/output (I/O)operation(s).

Question 11

Building massive, integrated government databases raises fewer technical questions than legal, political, social, and ethical ones.

Question 12

A meta tag is a small text file that the web server sends to the user's browser and that gets stored on the user's hard drive. _________________________

Question 13

Each record in a file contains information about an item in the "universe of discourse" that the file describes.

Question 14

Encryption is the method in which data are protected during a transaction._________________________

Question 15

The correspondence between primary keys and compound keys is what establishes the relationships among various entities in a database._________________________

Question 16

You maintain a ____ web presence to streamline transactions between you as the seller and other businesses as buyers.

A)B2B
B)S2B
C)B2S
D)C2B

Question 17

The Internet has been around since 1969.

Question 18

To the user, distributed databases look like a single database, just with slightly slower access times.

Question 19

The Census Bureau of the U.S. Department of Commerce estimated ecommerce retail sales in the United States for the first quarter of 2017 to be $105.7 billion, an increase of 14% from the first quarter of 2016.

Question 20

An ____ will, for a fee, design your website and manage it on an ongoing basis.

A)application service provider
B)application manager
C)application hosting provider
D)application management provider

Question 21

A ____ runs Bitcoin software that verifies (using a hash function)that the blockchain has not been altered in any way since the previous transaction, and for this service, the miner is rewarded with new bitcoins.

A)dumpster diver
B)Groupon bot
C)virtual currency specialist
D)bitcoin miner

Question 22

Each category of information in a database is called a(n)____.

A)element
B)tuple
C)attribute
D)entity

Question 23

Related records are kept in a _________.

A)data file
B)data chain
C)record file
D)file sheet

Question 24

A database management system can relate information between various tables through ____ values.

A)special
B)prepared
C)key
D)primary

Question 25

The term __________ expresses that we now have huge amounts of data available.

A)data warehouse
B)data store
C)big data
D)large data

Question 26

____________________ is an online payment service, an alternative to a customer paying an online merchant by credit card.

Question 27

In general, issues of personal privacy and public safety are magnified enormously by the capabilities of ____________________ databases.

Question 28

A(n)____________________ is a graphical ad, often with animation, placed in a prominent position on a webpage.

Question 29

____ allow the physical data to reside at separate and independent locations that are electronically networked together.

A)Discrete databases
B)Singleton databases
C)Distributed databases
D)Normalized databases

Question 30

A ____ is an attribute or combination of attributes that uniquely identifies a tuple.

A)secondary key
B)primary key
C)foreign key
D)preferred key

Question 31

Services such as Apple Pay and PayPal are examples of __________.

A)electronic payment systems
B)automated payment systems
C)data-driven payment systems
D)network-based payment systems

Question 32

As of April 2017, ____ had almost 169 million active registered users, and there were over 800 million listings of items for sale.

A)Groupon
B)eBay
C)PayPal
D)Craigslist

Question 33

A ____ is a collection of databases that contain current and archived data used for research and analysis purposes rather than to manage day-to-day business transactions such as inventory control or payroll data.

A)data mine
B)data broker
C)data warehouse
D)daisy chain

Question 34

Using multiple ____________________ in a single database minimizes the amount of work required to maintain consistency in the data.

Question 35

__________ is the basis of Bitcoin cybercurrency.

A)Blockloop
B)Encrypted chain
C)Chain looping
D)Blockchain

Question 36

A good DBMS incorporates the services of a ____ to organize the disk files in an optimal way, in order to minimize access time to the records.

A)sophisticated file manager
B)simple file manager
C)special operating system service
D)specialized file system

Question 37

A ____ gives the user, or the user's application software, the ability to combine and manipulate data easily in ways that would be very difficult if the data were kept in separate and unrelated files.

A)file
B)database
C)datastore
D)data system

Question 38

A program written in ____________________ asks for something to be done, but it does not contain a specific sequence of instructions on how it is to be done.

Question 39

A ____ is one where multiple keys are needed to identify a tuple uniquely.

A)unique primary key
B)discrete primary key
C)foreign primary key
D)composite primary key

Question 40

____ is the process of automatically analyzing large amounts of data to discover and interpret previously hidden patterns contained therein.

A)Phishing
B)Data mining
C)Metadata searching
D)Data warehousing

Question 41

Describe in detail how your potential customers learn your URL in the first place

Question 42

How do you manage a relational table?

Question 43

Talk about the use of cookies in ecommerce. Discuss how they are useful. Are they potentially dangerous?

Question 44

What is required by the SQL command to create a table?

Question 45

What is a Bitcoin?

Question 46

Explain what Craigslist is and how it works.

Question 47

Briefly, what are the goals of establishing an online shopping/ecommerce presence as discussed in this chapter?

Question 48

What, in detail, is cybersquatting?

Question 49

Discuss the risks associated with large databases (big data)full of personal and financial information being accessible on the Web.

Question 50

Explain what distributed databases allow.