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

1. Which SQL statement is used to add a new column to an existing table?

ADD COLUMN

ALTER TABLE

INSERT INTO

CREATE COLUMN

2. 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.

3. In the context of databases, what is a stored function?

A group of related data

A precompiled collection of one or more SQL statements

A user-defined operation that returns a single value

An ordered list of values with corresponding row locations

4. Which type of relationship is represented by a foreign key in a database?

One-to-Many

Many-to-Many

One-to-One

None of the above

5. 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

6. What does the acronym SQL stand for?

Structured Question Language

System Query Language

Sequential Query Language

Structured Query Language

7. Which of the following is an example of a database trigger?

A stored procedure

An event that automatically invokes an action

A constraint that ensures data integrity

A group of related data

8. Which SQL statement is used to grant specific privileges on a database object?

GRANT PRIVILEGES

ALLOW ACCESS

GRANT ACCESS

GRANT

9. What is the purpose of the CHECK constraint in a database?

Ensures uniqueness of a column

Defines a default value

Specifies a condition that must be true for each row

Links a column to another table's primary key

10. 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.

RDBMS MCQ Test 5