Multiple Choice Questions on Relational Database Concepts

📚 Quick Study Guide

🔍 Relational databases organize data into tables with rows (records) and columns (fields). 🔑 A primary key uniquely identifies each record in a table. It cannot be NULL. 🔗 A foreign key establishes a link between two tables. It refers to the primary key in another table. 🧮 SQL (Structured Query Language) is the standard language for managing and querying relational databases. 💡 Normalization reduces data redundancy and improves data integrity by organizing data into tables in such a way that database integrity constraints properly enforce dependencies. 🤝 Joins combine rows from two or more tables based on a related column. 🔒 Transactions ensure that a series of operations are treated as a single unit of work. Either all operations succeed, or none do.

🧪 Practice Quiz

1. Which of the following is the most appropriate definition of a relational database?
1. A database that stores data in a hierarchical structure.
2. A database that stores data in tables with rows and columns.
3. A database that stores data in a network structure.
4. A database that stores data as objects.
2. What is the purpose of a primary key in a relational database?
1. To establish a relationship between two tables.
2. To uniquely identify each record in a table.
3. To enforce data integrity constraints.
4. To sort the data in a table.
3. Which SQL command is used to retrieve data from a relational database?
1. UPDATE
2. INSERT
3. SELECT
4. DELETE
4. What is a foreign key in a relational database?
1. A key used to encrypt the data in a table.
2. A key that uniquely identifies each database.
3. A key that refers to the primary key in another table.
4. A key used for data compression.
5. What is normalization in a relational database?
1. The process of backing up the database.
2. The process of optimizing query performance.
3. The process of reducing data redundancy and improving data integrity.
4. The process of securing the database from unauthorized access.
6. Which type of join returns all rows from the left table and matching rows from the right table?
1. INNER JOIN
2. RIGHT JOIN
3. FULL OUTER JOIN
4. LEFT JOIN
7. What is a transaction in a relational database?
1. A single SQL statement.
2. A series of operations treated as a single unit of work.
3. A user's session with the database.
4. A report generated from the database.