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

1. Which SQL statement is used to update data in a database?

INSERT INTO

MODIFY

UPDATE

ALTER

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

3. Which of the following is not a primary key constraint?

UNIQUE

NULL

PRIMARY

FOREIGN KEY

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

5. What does CRUD stand for in the context of databases?

Create, Retrieve, Update, Delete

Compile, Run, Update, Debug

Copy, Remove, Undo, Delete

Categorize, Revert, Update, Debug

6. In the context of databases, what is a transaction?

A group of related data

A set of SQL statements executed as a single unit of work

An index created on a specific column

A constraint that ensures data integrity

7. Which SQL clause is used to filter the results of a SELECT statement?

ORDER BY

GROUP BY

WHERE

HAVING

8. In the context of databases, what is a cursor?

A group of related data

A virtual table based on the result of a SELECT statement

A pointer used to iterate over a set of rows

An ordered list of values with corresponding row locations

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. What is the purpose of the HAVING clause in SQL, and how is it different from the WHERE clause?

HAVING is used for filtering rows based on conditions, while WHERE is used for grouping rows.

HAVING is used for grouping rows, while WHERE is used for filtering rows based on conditions.

HAVING and WHERE are interchangeable in SQL.

HAVING is used for sorting rows, while WHERE is used for filtering rows based on conditions.

11. Which of the following is an example of an aggregate function in SQL?

JOIN

COUNT

WHERE

GROUP

12. Which of the following is an example of a DDL (Data Definition Language) statement?

SELECT

UPDATE

DELETE

CREATE TABLE

13. In database terms, what does ACID stand for?

All Columns Indexed and Defined

Atomicity, Consistency, Isolation, Durability

Advanced Constraints and Index Definitions

Aggregate, Combine, Insert, Delete

14. In the context of databases, what is a database trigger?

A stored procedure

An event that automatically invokes an action

A constraint that ensures data integrity

A group of related data

15. What is the purpose of the ROW_NUMBER() function in SQL?

To filter rows based on a condition

To assign a unique number to each row within a partition

To sort the result set

To group rows based on a condition

16. What does the acronym SQL stand for?

Structured Question Language

System Query Language

Sequential Query Language

Structured Query Language

17. What is the purpose of the HAVING clause in SQL?

To filter rows based on a condition

To sort the result set

To group rows based on a condition

To filter the result set after grouping

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

GRANT PRIVILEGES

ALLOW ACCESS

GRANT ACCESS

GRANT

19. In the context of databases, what is a materialized view?

A group of related data

A virtual table based on the result of a SELECT statement

A constraint that ensures data integrity

A precomputed snapshot of a query result

20. Discuss the concept of database denormalization and situations where it might be considered beneficial.

Denormalization involves intentionally introducing redundancy in a database to improve query performance. It may be considered beneficial in scenarios with complex queries and read-heavy workloads.

Denormalization is always detrimental to database performance and should be avoided.

Denormalization is only suitable for write-heavy workloads and has no impact on query performance.

Denormalization is a technique to remove all redundancy from a database, improving overall performance.

RDBMS MCQ Test 4