Relational Database Management System RDBMS MCQs
Relational Database Management System RDBMS MCQs
These Relational Database Management System RDBMS multiple-choice questions and their answers will help you strengthen your grip on the subject of Relational Database Management System RDBMS. You can prepare for an upcoming exam or job interview with these Relational Database Management System RDBMS MCQs.
So scroll down and start answering.
1: In a database table, each row is called a(n) __________ and each column is called a __________.
A. Select the text.
B. Web layout view
C. Record, field
D. Pushpin icon
2: What is a relational database management system?
A. A database management system based on the hierarchical model
B. A database management system that uses a network structure
C. A database management system that stores data in tables and enforces relationships between them
D. A database management system that organizes data in a key-value format
3: What is a primary key in a relational database?
A. A unique identifier for a record in a table
B. A field that stores the sum of a set of values in a table
C. A foreign key that references another table
D. A field that contains calculated values based on other fields
4: What is the purpose of referential integrity in a relational database?
A. To ensure that each field in a table has a valid data type
B. To ensure that the database can handle a large volume of data
C. To enforce relationships between tables and maintain data consistency
D. To optimize query performance in the database
5: Which of the following is an example of a relational database management system?
A. Oracle
B. MongoDB
C. Redis
D. Elasticsearch
6: What is a foreign key in a relational database?
A. A unique identifier for a record in a table
B. A field that stores the sum of a set of values in a table
C. A primary key that references another table
D. A field that contains calculated values based on other fields
7: What is the purpose of a join operation in a relational database?
A. To combine records from multiple tables based on a related column
B. To calculate aggregate functions on a set of records in a table
C. To sort the records in a table based on a specified column
D. To create a new table by combining data from multiple tables
8: Which normal form requires that every non-key attribute is fully dependent on the primary key?
A. First normal form (1NF)
B. Second normal form (2NF)
C. Third normal form (3NF)
D. Boyce-Codd normal form (BCNF)
9: What is the purpose of indexing in a relational database?
A. To enforce referential integrity between tables
B. To store large objects such as images or documents in the database
C. To improve the performance of data retrieval operations
D. To organize data in a hierarchical structure
10: Which SQL keyword is used to retrieve data from a relational database?
A. SELECT
B. INSERT
C. UPDATE
D. DELETE
11: What is a transaction in a relational database?
A. A unit of work that consists of multiple database operations
B. A foreign key that references another table
C. A field that contains calculated values based on other fields
D. A unique identifier for a record in a table
List of Relational Database Ma...
Available in:
Relational Database Management System RDBMS MCQs
