Database management system

1. What is a relational database?

a) A database that stores data in tables b) A database that uses graphs to store data c) A database that uses documents to store data d) A database that uses key-value pairs

2. Which of the following is a basic operation in relational algebra?

a) Selection b) Insertion c) Deletion d) Update

3. What is the purpose of the SELECT operation in relational algebra?

a) To filter rows based on a condition b) To combine two tables c) To delete rows from a table d) To update rows in a table

4. What is a tuple in a relational database?

a) A row in a table b) A column in a table c) A relationship between tables d) A key in a table

5. What is the difference between relational algebra and tuple relational calculus?

a) Relational algebra is procedural, while tuple relational calculus is declarative b) Relational algebra is declarative, while tuple relational calculus is procedural c) Relational algebra is used for queries, while tuple relational calculus is used for updates d) There is no difference

6. Which of the following is a relational algebra operation for combining two tables?

a) Join b) Project c) Select d) Rename

7. What is the purpose of the PROJECT operation in relational algebra?

a) To select specific columns from a table b) To filter rows based on a condition c) To combine two tables d) To delete rows from a table

8. What is a primary key in a relational database?

a) A unique identifier for a row in a table b) A column that references another table c) A column that stores numeric data d) A column that stores text data

9. What is the purpose of the JOIN operation in relational algebra?

a) To combine rows from two or more tables based on a related column b) To filter rows based on a condition c) To select specific columns from a table d) To delete rows from a table

10. What is the purpose of the RENAME operation in relational algebra?

a) To change the name of a table or column b) To filter rows based on a condition c) To combine two tables d) To delete rows from a table

Relational Databases MCQs

Your Score: /10