WorksheetsDatabase Management System Quiz
Total questions: 52
Worksheet time: 52mins
What does a Database Management System (DBMS) do?
Handles physical storage of data
Manages and organizes data efficiently
Only allows data retrieval
Only handles hardware storage issues
What is an example of a real-time DBMS application?
Searching files in Windows Explorer
A library management system
Storing text files in a folder
Writing code in a text editor
Which is NOT a feature of DBMS?
Data redundancy
Data security
Backup and recovery
Scalability
What does DDL stand for in SQL?
Data Development Language
Data Definition Language
Data Description Language
Data Deployment Language
Which of the following is NOT a DML operation?
INSERT
DELETE
UPDATE
CREATE
What is the purpose of the WHERE clause in SQL?
To modify table structures
To filter rows based on a condition
To group rows
To sort the result set
What type of user interacts with a database indirectly through an application?
Naive User
Database Administrator
Application Developer
System Analyst
Which is an advantage of a DBMS?
Increased data duplication
Difficult access control
Centralized data management
No security mechanisms
What is a view in a database?
A stored procedure
A virtual table
A physical table
A type of index
Which of the following is NOT a type of database user?
End User
Network Administrator
System Analyst
Database Designer
What is a surrogate key in database normalization?
A natural key
A primary key with user-defined values
A generated unique identifier
A secondary key
Which SQL command is used to remove a table?
DELETE TABLE
REMOVE TABLE
DROP TABLE
ERASE TABLE
In which normal form does a relation have no multivalued dependencies?
2NF
BCNF
4NF
5NF
What is the main purpose of using indexing in a database?
To define table structure
To improve query performance
To ensure data integrity
To manage transactions
What does ACID stand for in transactions?
Atomicity, Consistency, Isolation, Durability
Accuracy, Consistency, Integrity, Durability
Atomicity, Clarity, Isolation, Dependency
Accuracy, Clarity, Isolation, Dependency
Which concurrency protocol uses timestamps?
Lock-based protocol
Time-based protocol
Timestamp ordering protocol
Optimistic concurrency protocol
What is the role of a foreign key in a relational database?
Uniquely identifies each row
Links data between tables
Ensures data redundancy
Acts as a surrogate key
Which of the following is NOT an aggregate function in SQL?
COUNT
SUM
AVG
SUBSTR
What is an Entity-Relationship (E-R) model primarily used for?
Defining keys in a table
Designing database structure and relationships
Performing database normalization
Creating SQL queries
Which type of index organizes data in a tree-like structure?
Hash index
B+ Tree index
Sequential index
Clustered index
What does a database schema define?
The software used to manage the database
The way data is structured and organized
The physical storage devices used
The network used for database access
What does a logical schema include?
File storage formats
Tables, columns, data types, and relationships
Indexing and partitions
Hardware specifications
What is the primary purpose of a view schema?
To define physical storage formats
To create user-specific views of data
To manage database indexing
To organize file storage
Which layer of the three-tier schema architecture deals with physical storage?
Internal Schema
Conceptual Schema
External Schema
View Schema
Logical data independence refers to changes in the:
Internal schema affecting external schemas
Conceptual schema not impacting external schemas
External schema affecting the internal schema
Physical schema not affecting the conceptual schema
What is the purpose of the Recovery Manager in DBMS?
To process user queries
To recover the database to a consistent state after a failure
To optimize database queries
To schedule concurrent query execution
Which DBMS component is responsible for enforcing data integrity?
Data Dictionary Manager
Query Optimizer
Integrity Checker
Recovery Manager
What does the term "data independence" in DBMS signify?
Independent access to files without DBMS
Layers of the database not impacting each other
Storage of data independent of user queries
Independent processing of multiple queries
What is an example of a weak entity?
An entity with a primary key
An entity without a key attribute
An entity with composite attributes
An entity with a multi-valued attribute
Which architecture centralizes all database components on a single server?
Client-server architecture
Distributed architecture
Centralized architecture
Peer-to-peer architecture
In the ER model, what symbol represents attributes?
Rectangle
Ellipse
Diamond
Line
What does the diamond symbol in an ER diagram represent?
Entities
Attributes
Relationships
Multi-valued attributes
What does a row in a relational database table represent?
Attribute
Relation
Tuple
Schema
What is the term for a column in a table according to the relational model?
Attribute
Schema
Domain
Tuple
Which term describes the logical structure of a database?
Database instance
Database schema
Relation schema
Relational algebra
What is the purpose of a candidate key?
To act as a foreign key
To uniquely identify a row
To combine multiple relations
To store duplicate rows
Which key is a minimal set of attributes that can uniquely identify a row?
Superkey
Primary key
Foreign key
Candidate key
In relational algebra, what does the projection operation do?
Filters rows based on a condition
Combines two tables
Returns specific columns from a table
Renames attributes
What is the symbol for the selection operation in relational algebra?
π
σ
∪
×
What type of query language is relational algebra classified as?
Declarative
Procedural
Non-procedural
Imperative
What is the purpose of the Cartesian product operation in relational algebra?
Select rows that satisfy a condition
Combine all rows from two relations
Return the difference between two relations
Create a new schema
What is the result of the union operation in relational algebra?
Common rows from two relations
Rows present in one relation but not the other
Rows from both relations, combined
A new schema with renamed attributes
Which operator in relational algebra allows renaming of attributes?
π
σ
ρ
×
What must be true for two relations to perform a union operation?
The relations must have the same attributes.
The relations must have a common primary key.
The relations must be stored in the same schema.
The relations must have no null values.
What is a foreign key used for?
Uniquely identifying rows in a relation
Establishing a relationship between two relations
Filtering rows in a query
Renaming attributes in a relation
What is the result of the set difference operation in relational algebra?
All rows from two relations combined
Rows in the first relation not present in the second
Common rows from two relations
Renamed attributes in the output
What does the domain of an attribute represent?
The set of all possible values for the attribute
The primary key of a relation
The relationship between attributes
The physical location of the attribute
What does the term 'relation instance' refer to?
The schema of a relation
A specific set of rows in a relation
A foreign key in a relation
The attributes of a relation
What is the purpose of the assignment operation in relational algebra?
To rename relations
To store intermediate results in variables
To project specific columns
To join two relations
Which operator is used to find common tuples in two relations?
∪
∩
−
×
What does the relational model use to represent relationships among values?
Tables and attributes
Rows and columns
Tuples and relations
Domains and schemas
What does the null value in a relational database signify?
A foreign key
A primary key
An unknown or missing value
A duplicated value
