WorksheetsDBMS A.Y 2025-26 2c
Total questions: 15
Worksheet time: 8mins
Which of the following is a major difference between a Database System and a File System?
File system supports redundancy
Database system has no security
Database system reduces data redundancy
File system supports data independence
Which characteristic of DBMS allows data to be stored only once and shared by multiple users?
Data security
Data redundancy
Data consistency
Data independence
Which of the following is NOT an advantage of a DBMS?
Data security
Reduced redundancy
Increased inconsistency
Data sharing
Who is responsible for database design, security, and access control?
End user
Database Administrator (DBA)
Application programmer
System analyst
The three-tier schema architecture provides data independence by separating:
Hardware and software
User and database
Physical, logical, and external levels
Tables and records
In Client-Server architecture, the database is mainly stored on:
Client system
Application layer
Database server
User interface
An Entity in ER model represents:
A relationship
A real-world object
An attribute
A key
Which of the following is a multivalued attribute?
Age
Roll number
Phone numbers
Date of birth
A weak entity is one that:
Has no attributes
Depends on another entity for identification
Has multiple keys
Has no relationships
Specialization is a process of:
Combining entity sets
Breaking an entity set into sub-entities
Converting ER model to relational model
Creating relationships
A relation in relational model is represented as:
Tree
Graph
Table
File
Which constraint ensures that a primary key value cannot be NULL?
Domain constraint
Entity integrity constraint
Referential integrity constraint
Key constraint
Which SQL command is used to create a table?
INSERT
CREATE
SELECT
UPDATE
Which clause is used to group rows that have the same values?
ORDER BY
WHERE
GROUP BY
HAVING
Which of the following is used to retrieve data from multiple tables using a subquery?
DELETE
JOIN
Nested query
TRUNCATE
