Font size
WorksheetsQuiz - 1 (RDBMS- 10.2.2025)
Total questions: 89
Worksheet time: 45mins
What is a Database?
Collection of interrelated data
A set of programs
A programming language
None of the above
What is DBMS?
Database Management Structure
Database Management System
Database Maintenance System
Data Backup Management System
Which of the following is NOT a characteristic of DBMS?
Redundancy control
Data isolation
Data inconsistency
Security
Which characteristic ensures that a database system is self-descriptive?
Cataloging
Meta-data
Independence
Integrity
Which feature of DBMS reduces data redundancy?
Data independence
Normalization
Data inconsistency
Concurrency control
Which of the following is an advantage of DBMS?
Improved data sharing
Data inconsistency
Increased redundancy
Poor security
What is the primary purpose of a DBMS?
To store large volumes of data
To manage data efficiently
To allow multiple users to access data
All of the above
The three levels of schema architecture are:
Internal, Conceptual, External
Conceptual, Logical, Physical
External, Internal, Logical
Logical, Internal, Conceptual
The external schema level represents:
User's view
Internal storage
Metadata
None of the above
Data independence refers to:
Data security
Data abstraction
Data redundancy
Data dependency
Which of the following is NOT a database language?
DDL
DML
HTML
DCL
The primary role of a Database Administrator (DBA) is:
Software development
Database maintenance and security
Network troubleshooting
Hardware repairs
Which of the following is NOT a type of data model?
Hierarchical
Network
Relational
File system
An entity set is a collection of:
Attributes
Entities
Keys
Relations
In ER modeling, a primary key is:
A unique identifier for an entity
A relationship
A type of data redundancy
An attribute with null values
A distributed database system:
Stores data in a single location
Spreads data across multiple sites
Uses only relational data models
Cannot be accessed remotely
Which of the following is NOT a classification of DBMS?
Hierarchical
Relational
Blockchain
Network
RDBMS stands for:
Reliable Database Management System
Relational Database Management System
Real-time Database Management System
Random Database Management System
The relational model organizes data into:
Trees
Graphs
Tables
Documents
Which of the following is NOT a relational operation?
Insert
Select
Rename
Compile
A database transaction is:
A collection of operations that must be executed together
A single SQL statement
A single record entry
A hardware process
First Normal Form (1NF) ensures:
No partial dependencies
No duplicate columns
No multi-valued attributes
No transitive dependencies
What is a key difference between DBMS and RDBMS?
RDBMS supports tables, DBMS does not
DBMS supports relations, RDBMS does not
RDBMS does not support relationships between tables
None of the above
Which of the following is NOT a feature of RDBMS?
Table-based structure
Supports relationships between data
Allows multiple users
No support for ACID properties
The relational model was proposed by:
Edgar F. Codd
Charles Bachman
James Gosling
Dennis Ritchie
A relation in RDBMS is represented in the form of:
Rows and columns
Trees
Graphs
Linked lists
Which of the following is NOT a basic relational operation?
Selection
Projection
Sorting
Join
The Cartesian product of two relations R and S will have:
|R| × |S| tuples
|R| + |S| tuples
|R| - |S| tuples
|R| / |S| tuples
A transaction must satisfy which of the following properties?
ACID
BASE
SQL
HTTP
Which of the following is NOT a type of join in SQL?
Inner Join
Outer Join
Cross Join
Loop Join
The process of removing transitive dependencies is called:
1NF
2NF
3NF
4NF
What makes RDBMS different from DBMS?
Support for relationships among tables
Use of structured data
Use of queries
No use of indexes
Which of the following databases is NOT an RDBMS?
MySQL
Oracle
MongoDB
SQL Server
SQL stands for:
Structured Query Language
System Query Language
Standard Query Language
Simplified Query Language
Which of the following is NOT an SQL data type?
CHAR
INTEGER
BOOLEAN
STRING
The command to delete all records from a table is:
DELETE
TRUNCATE
DROP
REMOVE
The command used to modify existing data in a table is:
MODIFY
ALTER
UPDATE
CHANGE
Which SQL feature ensures data consistency and correctness?
Data redundancy
Data integrity
Data loss
Data mining
Which SQL command is used to retrieve data from a database?
GET
FETCH
SELECT
RETRIEVE
The command to insert a new row in a table is:
ADD
INSERT INTO
NEW ROW
CREATE ROW
The SQL function used to find the total number of records is:
SUM()
COUNT()
AVG()
TOTAL()
Who proposed the relational model for databases?
Edgar F. Codd
Charles Bachman
Dennis Ritchie
Bill Gates
Which of the following is NOT a feature of RDBMS?
Data redundancy
Data consistency
ACID properties
Data integrity
Which of the following is a relational database?
MySQL
MongoDB
Neo4j
Redis
In RDBMS, data is organized in the form of:
Tables
Files
Graphs
Trees
A primary key in a table:
Can have duplicate values
Cannot be null and must be unique
Can be null
Must contain only null values
A foreign key is used to:
Uniquely identify a record
Maintain referential integrity
Store redundant data
Encrypt data
Which SQL constraint ensures that a column cannot have NULL values?
UNIQUE
NOT NULL
FOREIGN KEY
DEFAULT
Which of the following is NOT an ACID property?
Atomicity
Consistency
Durability
Scalability
Which command is used to save all changes made to a database?
SAVE
COMMIT
ROLLBACK
RESTORE
Which SQL statement is used to undo a transaction?
CANCEL
DELETE
ROLLBACK
COMMIT
Which isolation level ensures the highest level of isolation in transactions?
READ COMMITTED
READ UNCOMMITTED
SERIALIZABLE
REPEATABLE READ
Which JOIN returns only matching rows from both tables?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
Which JOIN returns all records from the left table and the matched records from the right table?
INNER JOIN
LEFT JOIN
RIGHT JOIN
CROSS JOIN
Which SQL JOIN returns all records when there is a match in one of the tables?
FULL OUTER JOIN
LEFT JOIN
INNER JOIN
NATURAL JOIN
Which SQL JOIN produces the Cartesian product of two tables?
INNER JOIN
OUTER JOIN
CROSS JOIN
SELF JOIN
Which SQL JOIN is used to join a table with itself?
INNER JOIN
LEFT JOIN
SELF JOIN
FULL JOIN
A view in SQL is:
A virtual table
A copy of a table
A stored procedure
A trigger
Which SQL command is used to create a view?
CREATE TABLE
CREATE VIEW
ALTER VIEW
INSERT VIEW
Indexes in a database help to:
Improve query performance
Increase redundancy
Increase storage space
Reduce security
Which type of index stores a sorted order of values for faster retrieval?
Clustered index
Non-clustered index
Hash index
Unique index
Which of the following statements is true about an index?
It speeds up data retrieval
It is always required for a primary key
It does not impact the performance
It is only used in NoSQL databases
Which SQL command is used to grant privileges to a user?
GIVE
GRANT
ALLOW
PROVIDE
Which SQL command is used to revoke privileges?
REMOVE
DELETE
REVOKE
DENY
Which type of attack involves injecting malicious SQL code?
SQL Injection
Phishing
Brute force
Man-in-the-middle
Which database security feature prevents unauthorized access?
Encryption
Normalization
Indexing
Triggers
A role in a database is:
A predefined set of privileges
A database table
A user
A function
A stored procedure is:
A precompiled SQL statement
A temporary table
A security feature
A type of database
Which SQL statement is used to execute a stored procedure?
EXECUTE
RUN
START
BEGIN
Which SQL command is used to create a trigger?
CREATE TRIGGER
CREATE EVENT
ADD TRIGGER
TRIGGER CREATE
Which of the following is NOT a relational database?
MySQL
PostgreSQL
MongoDB
Oracle
Which SQL keyword is used to combine query results from multiple SELECT statements?
UNION
JOIN
GROUP BY
WHERE
Which SQL clause is used to specify conditions for grouped records?
WHERE
HAVING
GROUP BY
ORDER BY
Which data type is NOT used in an RDBMS?
INT
VARCHAR
BOOLEAN
OBJECT
Which of the following is an open-source RDBMS?
Microsoft SQL Server
Oracle
PostgreSQL
IBM DB2
Which of the following properties ensure that database transactions are processed reliably?
BASE
ACID
CAP
CRUD
Which of the following is NOT an ACID property?
Atomicity
Consistency
Distribution
Durability
What is the primary purpose of a database transaction?
To execute queries in sequence
To ensure data consistency
To increase speed
To prevent indexing
Which key uniquely identifies a record in a table?
Foreign key
Composite key
Primary key
Candidate key
A foreign key in a table:
Uniquely identifies a record
Refers to a primary key in another table
Must always be a numeric value
Cannot have duplicate values
Which type of key can have NULL values?
Primary key
Foreign key
Unique key
Both b and c
A composite key is made up of:
A single column
Multiple foreign keys
Multiple columns
A primary key and a unique key
Which of the following is NOT a type of database key?
Primary key
Alternate key
Secondary key
Cluster key
Which constraint ensures that a column does not accept NULL values?
PRIMARY KEY
NOT NULL
UNIQUE
CHECK
Which SQL constraint ensures all values in a column are different?
FOREIGN KEY
CHECK
UNIQUE
DEFAULT
Which SQL constraint ensures a column value falls within a specific range?
DEFAULT
CHECK
NOT NULL
UNIQUE
What does the DEFAULT constraint do?
Restricts input values
Provides a default value if none is specified
Makes a column unique
Defines a primary key
Which SQL command removes a constraint from a table?
DELETE CONSTRAINT
ALTER TABLE … DROP CONSTRAINT
REMOVE CONSTRAINT
CONSTRAINT OFF
Relational Algebra is used to:
Define the structure of a database
Perform operations on relations (tables)
Create stored procedures
Define primary keys
