ITE 3 Part 2

Question 1

DBMS Key Components (9)

Answer 1

Software
Data
Procedures
Database Languages
Query Processor
Runtime Database Manager
Database Manager
Database Engine
Reporting

Question 2

Refers to the technology solution used to optimize and manage the storage and retrieval of data from databases.

Answer 2

Database Management System (DBMS)

Question 3

DBMS is primarily a ___ system that can be considered as a management console or an interface to interact with and manage databases. The interfacing also spreads across real-world physical systems that contribute data to the backend databases. The OS, networking software, and the hardware infrastructure is involved in creating, accessing, managing, and processing the databases

Answer 3

Software

Question 4

DBMS contains operational data, access to database records and metadata as a resource to perform the necessary functionality. The data may include files with such as index files, administrative information, and data dictionaries used to represent data flows, ownership, structure, and relationships to other records or objects.

Answer 4

Data

Question 5

While not a part of the DBMS software, ___ can be considered as instructions on using DBMS. The documented guidelines assist users in designing, modifying, managing, and processing databases.

Answer 5

Procedures

Question 6

These are components of the DBMS used to access, modify, store, and retrieve data items from databases; specify database schema; control user access; and perform other associated database management operations.

Answer 6

Database Languages

Question 7

As a fundamental component of the DBMS, the ___ acts as an intermediary between users and the DBMS data engine in order to communicate query requests.

Answer 7

Query Processor

Question 8

A centralized management component of DBMS that handles functionality associated with runtime data, which is commonly used for context-based database access. This component checks for user authorization to request the query, processes the approved queries; devises an optimal strategy for query execution; supports concurrency so that multiple users can simultaneously work on same databases; and ensures integrity of data -recorded into the databases.

Answer 8

Runtime Database Manager

Question 9

Unlike the runtime database manager that handles queries and data at runtime, the ___ performs DBMS functionality associated with the data within databases. It allows a set of commands to perform different DBMS operations that include creating, deleting, backup, restoring, cloning, and other database maintenance tasks. It may also be used to update the database with patches from vendors.

Answer 9

Database Manager

Question 10

This is the core software component within the DBMS solution that performs the core functions associated with data storage and retrieval. It is also accessible via APIs that allow users or apps to create, read, write, and delete records in databases.

Answer 10

Database Engine

Question 11

The ___ generator extracts useful information from DBMS files and displays it in structured format based on defined specifications. This information may be used for further analysis, decision making, or business intelligence.

Answer 11

Reporting

Question 12

Benefits of DBMS (6)

Answer 12

Data Security
Data Sharing
Data Access and Auditing
Data Integration
Abstraction and Independence
Uniform Management and Administration