Database Architecture Quiz

Functions of DBMS

• A DBMS (Database Management System) performs several functions, including defining, constructing, and manipulating databases
• It also controls access, manages concurrency, and ensures database security and integrity
• DBMS provides a way to store, retrieve, and manipulate data in a database

DDL (Data Definition Language)

• DDL is used to define the structure and organization of a database
• It is used to create, modify, and delete database objects such as tables, indexes, and relationships

Logical Structure of a Database

• The logical structure of a database is described by the relational model
• This model organizes data into one or more tables with rows and columns
• Each table has a unique name and consists of rows (also called tuples) and columns (also called attributes)

DML (Data Manipulation Language)

• DML primarily deals with managing data in a database
• It includes commands such as SELECT, INSERT, UPDATE, and DELETE
• These commands are used to retrieve, add, modify, and delete data in a database

Data Encryption Techniques

• Data encryption techniques are used to protect data from unauthorized access
• These techniques convert plaintext data into unreadable ciphertext to prevent hackers from accessing sensitive information
• The purpose of data encryption is to ensure data confidentiality, integrity, and authenticity