RDBMS 1 Mark questions

Unit I: Introduction to RDBMS & SQL

1.​ What is RDBMS?​

Ans: RDBMS (Relational Database Management System) is a database system
that stores data in tables with relationships between them.
2.​ True or False: In RDBMS, data is stored in the form of tables.​
Ans: True
3.​ Fill in the blank:​
The diagram that represents the logical structure of a database is called E-R
Diagram.
4.​ 1NF allows duplicate rows in a table.True/False:
Ans: False
5.​ What is the purpose of Normalization?​
Ans: To reduce data redundancy and improve data integrity.
6.​ Which SQL command is used to create a new table?​
Ans: CREATE TABLE
7.​ Full form of SQL: Structured Query Language
8.​ Fill in the blank:​
The SQL command used to delete a table structure is DROP TABLE.
9.​ Which SQL data type is used to store large text data?​
Ans: TEXT or VARCHAR
10.​Which command is used to modify an existing table structure?​
Ans: ALTER TABLE

Unit II: Data Persistence, SQL & Managing Tables

11.​Which SQL command is used to insert new records into a table?​
Ans: INSERT
12.​True or False: The DELETE command removes all rows from a table but
keeps its structure.​
Ans: True
13.​Fill in the blank:​
The SQL command used to retrieve specific records is SELECT.
14.​Which SQL clause is used to sort records?​
Ans: ORDER BY
15.​What is the purpose of the WHERE clause in SQL?​
Ans: To filter records based on a condition.
16.​True or False: The DISTINCT keyword is used to remove duplicate records
from a result set.​
Ans: True
17.​Fill in the blank:​
The SQL operator used to check if a value falls within a specified range is
BETWEEN.
18.​Which operator is used to check equality in SQL?​
Ans: = (equal)
19.​What does the LIKE operator do in SQL?​
Ans: It is used for pattern matching in string data.
20.​Which constraint ensures that a column does not accept NULL values?​
Ans: NOT NULL

Unit III: Joins, Subqueries & Aggregate Functions

21.​What is a JOIN in SQL?​

Ans: A JOIN is used to combine rows from two or more tables based on
a related column.
22.​True or False: INNER JOIN returns only matching rows from both
tables.​
Ans: True
23.​Fill in the blank:​
The SQL function that returns the highest value in a column is MAX().
24.​Write the name of an aggregate function?​
Ans: SUM(),Max(),Min(),Avg(),Count()
25.​What is the purpose of the GROUP BY clause?​
Ans: It groups rows that have the same values in specified columns.
26.​True or False: The HAVING clause can be used without GROUP BY.​
Ans: False
27.​Fill in the blank:​
The SQL function used to count the number of rows is COUNT().
28.​True/False: Subqueries can return multiple rows. True
29.​What is a subquery in SQL?​
Ans: A query within another SQL query.
 30.​Which SQL function returns the highest value in a column? MAX()
31.​Which function calculates the average of a column? AVG()

Unit IV: SQL Objects, Data & Transactional Control Commands

31.​What is a view in SQL?​

Ans: A view is a virtual table that contains the result of a SQL query.
32.​True or False: The REVOKE command is used to remove user access
rights.​
Ans: True
33.​Fill in the blank:​
The SQL command used to save a transaction permanently is COMMIT.
34.​Which is a DCL command?​
Ans: GRANT
35.​What is the purpose of the ROLLBACK command?​
Ans: It is used to undo changes made in a transaction before committing.
36.​True or False: An index improves query performance in SQL.​
Ans: True
37.​What does TCL stand for in SQL?​
Ans: Transaction Control Language.
38.​Which of the following is NOT a transactional control command?​
a) COMMIT​
b) ROLLBACK​
c) SAVEPOINT​
d) SELECT​
Ans: d) SELECT
39.​True or False: A view can be created from multiple tables.​
Ans: True
40.​Define a transaction in SQL. A transaction is a sequence of operations
performed as a single unit.
Unit V: Relational Algebra

41.​What is relational algebra?​

Ans: It is a procedural query language used to retrieve data from
relational databases.
42.​True or False: Relational algebra consists of a set of operations to
manipulate relations.​
Ans: True
43.​Fill in the blank:​
A key that uniquely identifies each row in a table is called Primary Key.
44.​Which of the following is NOT a type of key?​
a) Primary Key​
b) Candidate Key​
c) Foreign Key​
d) Duplicate Key​
Ans: d) Duplicate Key
45.​What is a super key?​
Ans: A set of attributes that uniquely identify a row in a table.
46.​True or False: Projection is used to select specific columns from a table.​
Ans: True
47.​Fill in the blank:​
The operation used to select specific rows from a relation is Selection.
48.​Which relational algebra operation combines two tables based on a
common attribute?​
a) Selection​
b) Projection​
c) Join​
d) Cartesian Product​
Ans: c) Join
49.​True or False: Set operations like UNION and INTERSECTION are part
of relational algebra.​
Ans: True
50.​True/False: A relation can have multiple candidate keys. True
 RDBMS QUESTION BANK

Answer the following Questions. (5 Marks/3 Marks)

UNIT-1

1.​ What is RDBMS? Explain its features.

2.​ What is the purpose of E-R diagram? Explain One-to-Many Relationship with
suitable example.
3.​ Difference between DBMS and RDBMS.
4.​ Explain Normalization.
5.​ Discuss CREATE TABLE command with Constraints.
6.​ Discuss ALTER Command.
7.​ Explain SQL Datatypes.

UNIT-2

8.​ What is Data Constraints? Explain Primary key, Foreign key and Check
Constraints with suitable example.
9.​ What is the use of Not Null constraint?
10.​Explain LIKE, IN and LOGICAL Operators.
11.​What is the use of Order by clause?
12.​Explain DML commands with suitable examples.(select, insert, update, delete)

UNIT-3

13.​What is Subquery? Explain single-row subquery and multiple-row subquery.

14.​What is Joins? Explain Inner join and Outer joins with appropriate examples.
15.​Explain 5 aggregate functions with appropriate examples.
16.​Explain Group by and Having clause with suitable examples.
17.​Explain Aggregate Functions.(sum(), count(), avg(), max(), min())
18.​Perform given Queries:
1. Display faculties whose name starts with 'K'.
2. Find those faculty records whose classroom numbers are 102,105,108.
3. Find the average salary of each department.
4. Find the name of faculty whose salary is greater than Peter’s salary.
5. Find those employees who belongs to ‘computer’ department and have salary
more than 45000.

UNIT-4

19.​What is View? Discuss Updatable view.

20.​Write a short note on INDEX OR Explain B-Tree Index and how to create an
INDEX?
21.​What is the use of commit, rollback commands with appropriate example

UNIT-5

22.​What is Relational Algebra? Draw and explain the structure of a Relational

Algebra.
23.​What is Super key and Alternate Key?
24.​Explain 5 aggregate functions with appropriate examples.
25.​What is the purpose of Selection and Projection Operation with appropriate
examples.
26.​Write down the Relational Algebra Queries for the emp table.
1.​ Display the detail of employee whose salary more than
10000.
2.​ Display the detail of employee belongs to ‘HR’ Dept and
having salary more than 20000.
3.​ Display the Names and empno who belongs to ‘Admin’ Dept
and having salary more than 20000.
4.​ Display the Names of an employees along with their Dept
Names whose salary between 15000 and 30000.
5.​ Display the Names of an employees who empno is either 4
or 8.