Database Management Systems

What is the primary function of transaction management in a database?

What is an instance in the context of a database?

What type of independence allows modifying the physical schema without changing the logical schema?

What component is responsible for handling business logic and communicating with the database server in a three-tier architecture?

What type of database system is designed to improve performance by using multiple processors and storage devices in a shared memory or shared disk configuration?

What is the function of a DDL compiler in a database system?

Which component is responsible for query optimization in a database system?

What is the primary function of the storage manager in a database system?

What is the primary function of a Database Administrator (DBA)?

In which era did SQL emerge as an industrial standard?

What is the main characteristic of NoSQL systems?

What is the term for a collection of operations that performs a single logical function?

What is responsible for translating DML statements into low-level instructions?

What type of database application involves managing production, inventory, orders, and supply chain?

What is a disadvantage of storing data in multiple file formats?

What is responsible for executing a query and producing the desired result?

Database Management Systems

Transaction management ensures that the database remains in a consistent state despite failures.
An instance is the snapshot of the data stored in the database at a specific moment in time.

Data Independence

Physical data independence allows modifying the physical schema without changing the logical schema.

Database Architecture

In a three-tier architecture, the application server communicates directly with the database system.
Parallel databases are designed to improve performance by using multiple processors and storage devices in a shared memory or shared disk configuration.

Database Components

The query processor is responsible for query optimization.
The storage manager handles the storage, retrieval, and updating of data.

Database Administration

The main function of a database administrator (DBA) is managing the database schema and storage structure.

Database Types

NoSQL systems are designed for big data storage.

Database Applications

Examples of database applications include enterprise information, manufacturing, banking and finance, and universities.
Manufacturing involves managing production, inventory, orders, and supply chain.

Transactions

A transaction is a collection of operations that performs a single logical function in a database application.

Database Issues

Data redundancy and inconsistency occur when data is stored in multiple file formats.
Data redundancy and inconsistency can lead to duplication and inconsistency across different files.

Data Definition Language (DDL)

The main purpose of DDL is to define the database schema.

Relational Model

In a relational model, data is stored in various tables.
A primary key in a database is a field that uniquely identifies a row in a table.

Data Manipulation Language (DML)

Declarative DML requires specifying what data are needed without specifying how to get those data.
A DML compiler translates DML statements into low-level instructions.