NEW
Font size
WorksheetsDBMS
Total questions: 20
Worksheet time: 10mins
What is the primary purpose of the relational model in databases?
Organize data in tables
Create graphical representations
Perform complex calculations
Manage network connections
What is a database schema?
A visual representation of database tables
A set of rules for database normalization
A collection of database objects, including tables and relationships
A database backup file
In the context of a relational database, what is a key?
A physical lock securing the database server
A unique identifier for a record in a table
A type of encryption algorithm
A graphical representation of data relationships
What does a schema diagram visually represent?
Database operations
Table structures and their relationships
SQL queries
Database security measures
Which of the following is a fundamental relational algebra operation?
Join
Aggregate
Project
Update
What is the purpose of the SELECT operation in relational algebra?
Combine rows from different tables
Filter rows based on a condition
Add new records to a table
Sort the table in ascending order
Which additional relational algebra operation is used to combine rows from two tables?
Union
Join
Project
Intersect
What is the purpose of the EXTEND operation in extended relational algebra?
Add new attributes to a table
Remove existing attributes from a table
Create a new table
Sort the table in descending order
How are null values represented in a relational database?
As the number 0
As an empty string
As a special marker or indicator
Null values are not allowed in relational databases
What does the term "modification of the database" refer to?
Querying the database
Updating, inserting, or deleting records in the database
Changing the database schema
Creating a backup of the database
In relational databases, what is the purpose of the UPDATE operation?
Add new records to a table
Remove records from a table
Modify existing records in a table
Combine rows from different tables
What is the role of relational query languages in database management?
Define the physical storage structure of the database
Perform mathematical operations on the database
Provide a way to interact with the database using queries
Ensure data consistency in the database
Which of the following is an example of a relational database management system (RDBMS)?
MongoDB
Oracle
Redis
Cassandra
What is the purpose of the PROJECT operation in relational algebra?
Combine rows from different tables
Filter rows based on a condition
Remove unwanted columns from a table
Sort the table in ascending order
In a relational schema, what is a foreign key?
A key that uniquely identifies a record in a table
A key that is used for encryption
A reference to a primary key in another table
A key that allows null values
What is the primary goal of normalization in the context of a relational database?
Maximize data redundancy
Minimize data security
Organize data to reduce data duplication and dependency
Increase query performance
Which relational algebra operation is used to eliminate duplicate rows from a table?
Union
Join
Project
Intersect
What is the purpose of the INTERSECT operation in relational algebra?
Combine rows from different tables
Retrieve common rows from two tables
Remove unwanted columns from a table
Sort the table in descending order
How does the JOIN operation in relational algebra work?
Concatenates two tables vertically
Combines rows from two tables based on a common attribute
Creates a new table with only unique values
Removes unwanted columns from a table
What is the significance of primary keys in the relational model?
They uniquely identify a record in a table
They allow null values in a table
They are used for encryption
They define the physical storage structure of the database
