ROAD TO UPS 2 (D2T8) - PART 1

1. 1. Identify the correct statement of file processing system

• a structured collection of data, typically organized into tables consisting of rows and columns.

• software system designed to efficiently store, manage, retrieve, and manipulate large amounts of structured data

• Accessing data can be slow because you often have to scan entire files to find specific records.

• Multiple users can access and share the same data concurrently.

2.It provides a way to interact with data through queries, updates, and data management processes, while ensuring data integrity, security, and concurrency.

• database management system

• Oracle

• file system

• database system

3. 3.A collection of related data, organized in a manner that allows users to access, retrieve, & use of that data

• database system

• data file

• database

• dbms

4. 4.(a)   Database Management System (DBMS).

• Data might be duplicated across multiple files, leading to redundancy and inconsistencies.

• Data might be duplicated across multiple files, leading to redundancy and inconsistencies.

• the software that interacts with the database to perform tasks such as data entry, querying, updating, and administration.

• Software that allows user to create, access and manage data in database

5. Give examples of database used in business

• Customer Relationship Management (CRM)

• Supply Chain Management System

• Trading Systems

• Insurance System

6.Examples of Database Management System (DBMS).

• MS Power point

• Adobe Flash

• eWALLET

• db2

7. ____________referring to the structure and relationship between stored data, a database or databases, users and the hardware or operating system used for the storage

• Database

• Database system

• Database Management System

• Database Software

8.The rules, policies, and methods that govern how data is managed, accessed, and manipulated in the database

• Software

• Hardware

• Data

• Procedure

9. 9.The various programs and applications that interact with, manage, and support the database system

• Hardware

• Procedure

• Data

• Software

10. 10. Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row and column.      

List two (2) elements of a table in database representation

• data and software

• database and DBMS

• database system and record

• field and record