Font size
WorksheetsDatabase and E-commerce Quiz
Total questions: 24
Worksheet time: 12mins
Which of the following are problems of the traditional file environment?
Data redundancy
Data inconsistency
Program–data dependence
High data quality
A record is best defined as:
A group of related fields
A group of related files
A group of characters
A unique identifier
A database is designed to:
Centralize data
Control data redundancy
Increase program–data dependence
Improve data security
A relational DBMS represents data as:
Two-dimensional tables
Hierarchical tree structures
Columns and rows
Blockchain ledgers
What is a primary key?
A field used to uniquely identify each record
A field that appears in another table as a foreign key
A record identifier used for JOIN operations
A field storing encrypted values
A foreign key is:
A primary key in another table
Used to link two tables
Used to enforce referential integrity
A field that must always be numeric
Which are the three basic operations of a relational DBMS?
SELECT
JOIN
PROJECT
MERGE
SQL is used for:
Querying data
Data manipulation
Report generation
Hardware optimization
Normalization helps to:
Reduce data redundancy
Eliminate many-to-many relationships
Increase data inconsistency
Improve database design
Data governance refers to:
Policies for managing organizational data
Rules for data access and sharing
Data encryption standards
Procedures for classifying and standardizing information
NoSQL databases are characterized by:
Flexible data models
Ability to scale easily
Storage across distributed machines
Only supporting structured data
Cloud databases typically offer:
On-demand scalability
Lower cost for startups
Completely offline operations
Services such as Amazon RDS or SQL Azure
Blockchain technology provides:
Peer-to-peer distributed ledger
Immutable transaction records
Centralized database control
Encryption for identity verification
Big data is characterized by:
Very large volumes of data
Being only structured
Requiring specialized tools like Hadoop
Ability to reveal hidden patterns
A data warehouse:
Stores historical and current data
Cannot be changed by end users
Focuses on real-time transactions
Supports enterprise-wide reporting
Data mining can identify:
Associations
Clustering patterns
Forecasting trends
Print layouts for reports
Web-database integration is beneficial because:
Browsers are easy to use
Web interfaces require few database changes
It is inexpensive to add web access
It eliminates the need for DBMS
Which of the following is a unique feature of e-commerce that reduces search costs for consumers?
Ubiquity
Social technology
Richness
Global reach
Digital goods are characterized by:
Low cost of producing the first unit
High cost of producing additional units
Low cost of delivery over the Internet
High inventory and storage costs
What is an example of a B2C e-commerce model?
Amazon selling books online
Firms exchanging invoices via EDI
A business buying supplies from another business
A user selling goods to another user on auction sites
A market creator such as eBay primarily provides:
Content distribution
A digital platform where buyers and sellers meet
A portal offering search services
A subscription-based media service
Behavioral targeting refers to:
Selling products across national borders
Tracking users’ online activities to deliver relevant ads
Using smart logistics for fast delivery
Providing social shopping recommendations
Which technology is most associated with mobile payment systems like Apple Pay and Google Pay?
QR Code scanning
NFC (Near Field Communication)
Bluetooth pairing
SMS-based confirmation
Which statement best describes m-commerce?
Commerce that occurs only on desktop websites
The use of mobile devices to buy goods and services
Trading goods between businesses
Offline shopping enhanced by smart kiosks
