Mid-term Quiz (Chapter 5-8)

Chapter 5:

1. What is the primary advantage of using database over traditional file storage

• Data redundancy

• Data isolation

• Data intergrity

• None of the above

Chapter 5:

Which of the following best describes a "record" in a database?

• A single character

• A group of related fields

• A single bit

• A logical group of records

Chapter 5:

Which SQL operation is used to retrieve data from a database?

• SELECT

• DELETE

• INSERT

• UPDATE

Chapter 5:

Which of the following is NOT a key characteristic of high-quality data?

• Accuracy

• Completeness

• Inconsistancy

• Relevance

Chapter 5:

What is the function of a foriegn key in database relationship?

• To serve as a primary key

• To link data between two tables

• To store data redudancy

• To isolate records in a table

Chapter 5:

What is the advantage and disadvantage of using a Database Management System (DBMS) compared to traditional file systems.

Chapter 6:

What is the difference between e-commerce and e-business?

• E-commerce involves only monetary transactions

• E-business is limited to online activities

• E-business includes activities beyond just selling

• E-commerce includes hiring employees

Chapter 6:

Which of the following is an example of a click-and-mortar business?

• Netflix

• Walmart

• Amazon

• Skype

Chapter 6:

Which type of e-commerce involves individuals selling products to each other?

• B2B

• B2C

• C2C

• B2G

Chapter 6:

Which of the following is a security measure commonly used in e-commerce transactions?

• Web hosting

• Encrypted data transfer

• Search engine optimization

• Cookie files