Deck 14: Electronic Commerce and Databases

Question 1

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. _________________________

Answer 1

True

Question 2

To the user, distributed databases look like a single database with fast access times, just like data being accessed on the local machine.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

In the ____ world, financial transactions are conducted by electronic means.

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

Question 7

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

Question 8

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

Question 9

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 10

The Census Bureau of the U.S. Department of Commerce estimated e-commerce retail sales in the United States for the first quarter of 2010 to be $36.7 billion, an increase of 13% from the first quarter of 2008.

Question 11

The selling of retail products to the general public is how most consumers interact with and experience the Web's commercial capabilities.

Question 12

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

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

Question 13

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

A) Application Service Provider
B) Application Manager
C) Application Hosting Provider
D) Application Management Provider

Question 14

Opening an online store requires less planning than building another physical store location.

Question 15

A(n) 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 16

A total ____ is where orders are processed, credit is verified, transactions are completed, debits are issued, shipping is alerted, and inventory is reduced, all electronically.

A) e-business model
B) e-business site
C) e-business concept
D) e-business transport

Question 17

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

Question 18

Accessing a record in a large file involves at least three disk input/output (I/O) operations.

Question 19

Transmission of Web pages between a client and server is stateless. _________________________

Question 20

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

Question 21

A standard data DVD holds ____ GB of data.

A) 720
B) 1.44
C) 4.7
D) 8.2

Question 22

A(n) ____ 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 23

____ 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 24

____ is the time for the correct sector to rotate under the read/write head.

A) Lag time
B) Latency
C) Seek time
D) Transfer time

Question 25

To change information in an existing tuple, you use the SQL ____ command.

A) UPDATE
B) SELECT
C) INSERT
D) DELETE

Question 26

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

Question 27

____ is the time to position the read/write head over the correct track on the disk.

A) Lag time
B) Latency
C) Seek time
D) Transfer time

Question 28

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 29

A row of the table containing data about one instance of an entity is called a ____.

A) tuple
B) triple
C) connection
D) unit

Question 30

____ is the time to read from or write to the entire sector.

A) Lag time
B) Latency
C) Seek time
D) Transfer time

Question 31

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

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

Question 32

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

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

Question 33

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

Question 34

Organizing the way that records are stored on the disk can help to minimize the access time by reducing the number of disk ____________________ that must be done before finding the sector containing the desired record.

Question 35

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 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(n) ____________________ is a graphical ad, often with animation, placed in a prominent position on a Web page.

Question 38

____ is the practice of impersonating a legitimate site for the purposes of stealing money or stealing identity by collecting confidential information such as credit card numbers, names, and addresses.

A) Spooling
B) Spoofing
C) Spamming
D) Spooning

Question 39

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 40

Related records-say, the records of all the employees in a single company-are kept in a ____.

A) data interface
B) data file
C) data collection
D) data network

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

Discuss the ability of cloud computing to expand and contract with the needs of your business.

Question 44

What, in detail, is cybersquatting?

Question 45

List four risks (in the form of questions to consider) that may be involved with the decision to move into e-commerce?

Question 46

Explain what distributed databases allow.

Question 47

Briefly, what are the goals of establishing an online shopping/e-commerce presence?

Question 48

What is typosquatting?

Question 49

Explain what Craigslist is and how it works.

Question 50

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