RDBMS Basics Practice Test — Flashcards

Relational Database Management Systems (RDBMS) are a specialized type of DBMS that uses the relational model of organizing data. 

The key components of an RDBMS are:
Tables: Store data
Rows and columns: Store data
Primary keys: Uniquely identify rows
Foreign keys: Establish relationships between tables
Indexes: Optimize data retrieval
Constraints: Enforce data integrity 

RDBMS also uses transactions and locking mechanisms to maintain data consistency and prevent multiple users from modifying data simultaneously. 

Here are some basic features of RDBMS:
Data integrity: Protects data from accidental or malicious corruption
Normalization: Helps set up the database in a format and identify anomalies
Indexes: Retrieve information
Keys: Share columns between tables 

Some popular types of RDBMS include: Oracle database, MySQL, Microsoft SQL server, PostgreSQL, SQLite, and MariaDB.