Rigorous Rdbms Test - 66+ MCQs: RDBMS test: Evaluate Your Database Management Knowledge with RDBMS Questions and Answers

1. What is the purpose of the DISTINCT keyword in a SELECT statement?

To filter rows based on a condition

To sort the result set

To remove duplicate rows from the result set

To group rows based on a condition

2. Compare and contrast the concepts of ACID and BASE in the context of database transactions.

ACID (Atomicity, Consistency, Isolation, Durability) ensures reliable and secure transactions. BASE (Basically Available, Soft state, Eventually consistent) prioritizes availability and responsiveness.

ACID and BASE are interchangeable terms describing the same principles of database transactions.

ACID and BASE are unrelated concepts in database transactions.

ACID and BASE both prioritize availability and responsiveness in database transactions.

3. Explain the concept of multi-version concurrency control (MVCC) in the context of database transactions.

MVCC allows multiple versions of the same data to coexist, enabling concurrent transactions without blocking. It ensures consistency and isolation in database transactions.

MVCC has no impact on concurrency control in database transactions.

MVCC only applies to single-node databases and is irrelevant in distributed systems.

MVCC increases data redundancy and dependency in a database.

4. Which of the following is an example of an INNER JOIN?

LEFT JOIN

OUTER JOIN

CROSS JOIN

EQUIJOIN

5. In a relational database, what is a foreign key?

A column that uniquely identifies each row in a table

A column that links to another table's primary key

A column that allows NULL values

A column with a default value

6. Explain the concept of database normalization and its importance in database design.

Normalization is the process of reducing data redundancy and dependency in a database. It ensures efficient storage and avoids update anomalies.

Normalization involves adding redundancy to improve query performance in a database. It is not crucial for database design.

Normalization is a technique to increase data redundancy for faster retrieval.

Normalization is the process of creating duplicate data for backup purposes in a database.

7. Examine the role of the EXPLAIN statement in SQL and how it can be used to optimize queries.

The EXPLAIN statement provides insight into the query execution plan, allowing database administrators to analyze and optimize query performance.

The EXPLAIN statement is used to execute queries and has no impact on optimization.

The EXPLAIN statement is only relevant for simple queries and has limited impact on optimization.

The EXPLAIN statement is used to retrieve data from multiple tables but does not affect query performance.

8. Which SQL statement is used to add new data to a database?

INSERT INTO

CREATE

ADD

NEW DATA

9. Which SQL statement is used to revoke previously granted privileges on a database object?

REVOKE

DENY

REMOVE PRIVILEGES

DISALLOW ACCESS

10. What is the purpose of the JOIN operation in SQL?

To filter rows based on a condition

To combine rows from two or more tables based on a related column

To sort the result set

To group rows based on a condition

RDBMS MCQ Test 5