Question

Which of the following is a primary characteristic of a Relational Database?

• A. Data is stored in collections of documents.
• B. Data is organised into tables with rows and columns.
• C. Designed for unstructured data.
• D. No schema required.

Hint:

Remember:
• Relational Database = Tables + Rows + Columns.
• Uses SQL for data management.
• Examples: MySQL, Oracle, PostgreSQL, SQL Server.

Answer 1

The Correct Option is B

Concept: A Relational Database Management System (RDBMS) stores data in the form of tables. Each table consists of rows (records) and columns (fields). Relationships between different tables are established using Primary Keys and Foreign Keys. Some popular relational databases are:
• MySQL
• Oracle Database
• PostgreSQL
• Microsoft SQL Server

Step 1: Understand how data is stored in an RDBMS.
In a relational database: \[ \boxed{\text{Data is stored in tables consisting of rows and columns.}} \] Each row represents one record, while each column represents a particular attribute of that record.

Step 2: Identify the key features of a relational database.
A relational database provides:
• Structured data storage.
• Fixed schema.
• Relationships between tables using keys.
• SQL (Structured Query Language) for managing data.

Step 3: Analyse the given options.

• Data stored in collections of documents -- Feature of NoSQL document databases.
• Data organised into tables with rows and columns -- Correct.
• Designed for unstructured data -- Characteristic of NoSQL databases.
• No schema required -- Incorrect for relational databases, as they require a predefined schema.

Step 4: Final conclusion.
Hence, the primary characteristic of a relational database is: \[ \boxed{\text{Data is organised into tables with rows and columns.}} \]