Mid-term Flashcard (Chapter 5-8)

Front

What is the primary advantage of using a database over traditional file storage?

Back

Data integrity

Front

What best describes a "record" in a database?

Back

A group of related fields

Front

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

Back

SELECT

Front

Which of the following is NOT a key characteristic of high-quality data? Options: Accuracy, Completeness, Inconsistancy, Relevance

Back

Inconsistancy

Front

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

Back

To link data between two tables

Front

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

Back

Advantages of DBMS: Reduced redundancy, data integrity, easier data management, centralized data control, security, data independence. Disadvantages of DBMS: Higher cost, complexity in managing large databases, the need for specialized staff, and potential security risks with centralized data.

Front

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

Back

E-business includes activities beyond just selling.

Front

Which of the following is an example of a click-and-mortar business? Netflix, Walmart, Amazon, Skype

Back

Walmart

Front

Which type of e-commerce involves individuals selling products to each other? Options: B2B, B2C, C2C, B2G

Back

C2C

Front

Which of the following is a security measure commonly used in e-commerce transactions? Web hosting, Encrypted data transfer, Search engine optimization, Cookie files

Back

Encrypted data transfer