INSY5111 LU4

What is the role of the "Data Repository & Processing" component in the architecture?

• To store and process data for further analysis

• To visualize data insights

• To manage API gateways

• To create machine learning models

Which part of the architecture is responsible for predictive business analytics?

• Structured Data Blocks

• Data Repository & Processing

• Business Analytics & Predictive Ecosystem

• AI Core

What is a "File" in the hierarchy of stored information?

• A collection of integrated and related files

• A collection of related records

• A collection of related fields

• Multiple characters forming a unit

Which of the following is a feature of spreadsheets?

• Strict security measures and access restrictions

• Performing numeric modeling and what-if calculations

• High-speed retrieval for massive data volumes

• Sophisticated validation checks for data quality

What is a key benefit of databases for handling large data volumes?

• Quick data entry with features like auto-fill

• High-speed retrieval for massive data volumes

• Generating instant sum and average totals

• Rapid structural creation and initial setup

What is the primary function of the Database Engine in a Database Management System?

• To store, manipulate, and retrieve data.

• To define structures and primary keys.

• To add, delete, modify, and retrieve records.

• To handle backup, recovery, and performance.

What is the role of Application Generation in a Database Management System?

• To manage backup, recovery, and CRUD privileges.

• To build interactive menus and data-entry screens.

• To add, delete, modify, and retrieve records.

• To store, manipulate, and retrieve data.

Which component of a Database Management System is managed by a DBA and handles backup, recovery, performance, and CRUD privileges?

• Data Manipulation

• Data Administration

• Application Generation

• Data Definition

What is the main advantage of Random Access compared to Sequential Access?

• Faster access using magnetic disks

• Slower access using magnetic tape backups

• Scans index for address

• Optimizes both small and large data retrievals

What is the purpose of a Primary Key (PK) in a database table?

• To establish a link between two tables

• To uniquely identify each record in a table

• To store the total cost of an order

• To define the structure of a table