WorksheetsDB_2_ER
Total questions: 20
Worksheet time: 10mins
What is a primary function of a database system?
Operating system management
Data storage and retrieval
Web browsing
Network routing
Which of the following best defines a database?
A spreadsheet for storing temporary data
A collection of interrelated data
A text document with structured records
A file storing user credentials
What is one advantage of using a database over a traditional file system?
Less disk space usage
Easier user interface
Reduced data redundancy
No need for any software
Which component of a DBMS interacts with the end user?
Database engine
Query processor
DDL compiler
Application interface
What is a key difference between relational and non-relational databases?
Relational databases use XML
Non-relational databases use tables
Relational databases use tables with fixed schemas
Non-relational databases do not store any data
Which of the following is an example of a non-relational database?
MySQL
Oracle
MongoDB
PostgreSQL
What does ER in ER Model stand for?
Entity Relationship
External Record
Extended Reference
Entity Range
What is the role of attributes in an ER diagram?
They define the relationship
They provide the primary key
They describe the characteristics of an entity
They connect tables
Which of the following is used to uniquely identify a record in a relational model?
Tuple
Attribute
Primary Key
Entity
In a relational model, a row is also known as a:
Field
Attribute
Tuple
Domain
In a relational database, what is a relation?
A data type
A table
A SQL query
A relationship between ER entities
Which of the following best describes the term “schema” in a relational database?
The name of the database
A set of rules for data encryption
The structure of the database tables
A type of data query
Which operation retrieves specific rows from a table that satisfy a given condition?
Union
Join
Selection
Projection
What does the relational model use to establish relationships between tables?
Triggers
Foreign keys
Views
Queries
Which of these is NOT a type of relationship in an ER model?
One-to-One
One-to-Many
Many-to-Many
Recursive-to-Table
Which is NOT a feature of relational databases?
Tables with rows and columns
Predefined schema
Flexible document storage
Use of primary and foreign keys
What type of relationship is described by a student being enrolled in multiple courses?
One-to-One
One-to-Many
Many-to-Many
Recursive
Which term refers to a column in a table?
Tuple
Attribute
Entity
Record
Which of the following is an advantage of the ER model?
It is limited to one-to-one relationships
It provides a clear visual representation of data and relationships
It is only used by NoSQL databases
It prevents the use of attributes
Which of the following statements about the file-based system is TRUE?
It is more secure than a database
It handles concurrency better than databases
It lacks data independence
It prevents data redundancy
