MID TERM ECP00203

FULL NAME

ID NUMBER

Instructions: Answer all questions. Each question carries 1 mark. Select the best answer for each multiple-choice question.

What is the main purpose of a database?

• To increase redundancy

• To organize and manage data

• To replace networks

• To secure hardware

In a database, a "record" refers to:

• A column in a table

• A complete row of data

• A set of databases

• A single character

Which SQL command is used to retrieve data?

• UPDATE

• DELETE

• SELECT

• INSERT

A primary key in a table:

• Allows duplicate values

• Uniquely identifies each record

• Links two tables

• Stores backup data

Which of the following is NOT an advantage of using a DBMS?

• Reduced data redundancy

• Improved security

• Increased inconsistency

• Centralized data control

Which term refers to the buying and selling of goods/services over the Internet?

• E-business

• E-commerce

• Digital banking

• Online storage

Which of the following BEST describes e-business?

• Only online selling

• Business processes supported by digital technology

• Limited to financial transactions

• Social media advertising only