Menu

RDBMS Class 11
Questions and
Answers
15/07/2022 by CBSEskilleducation

Teachers and Examiners

(CBSESkillEduction) collaborated to create
the RDBMS Class 11 Questions and
Answers. All the important Information are
taken from the NCERT Textbook
Information Technology (802) class 11.

Contents [ show ]

RDBMS Class 11
Questions and Answers
1. Write a short note on MySQL.
Answer – Based on structured query
language, MySQL is a relational database
management system (RDBMS) created by
Oracle (SQL). A systematic collection of
data is called a database. Anything from a
straightforward shopping list to a photo
gallery or a location to store the enormous
volumes of information in a business
network may be it.

2. Mention features of a DBMS.

Answer – Features of a DBMS –

Minimum Redundancy and

Duplication. …
Usage Of Query Languages. …
Multi User Access. …
Reduced amount of space and
money spent on storage. …
Data Organization. …
Customization of the Database. …
Data Retrieval. …
Data Integrity is Maintained.

RDBMS Class 11 Questions and Answers

3. What is the difference between DBMS

and RDBMS?
Answer – Database Management System is
referred to as DBMS, and Relational
Database Management System is referred
to as RDBMS. Unlike RDBMS, which stores
data in the form of tables, DBMS stores
data as a file.

4. List some features of MySQL.

Answer – Features of MySQL ae –
a. MySQL based on Client/Server
Architecture
b. Free to use
c. Highly Flexibal
d. Compatible on many operating sytem
e. High performance
f. High productivity
g. Platform independent

5. How is Primary Key different from

Candidate Key?
Answer – A record in a table is uniquely
identified by its primary key, which must be
both unique and non-null. There can only
be one primary key per table. A candidate
key can be used in conjunction with a
primary key to uniquely identify records in
a table.

RDBMS Class 11 Questions and Answers

6. Define the key(s) used in MySQL.

Answer – There are four different types of
Keys –
a. Primary Key – The group of one or more
columns used to uniquely identify each
row of a relation is called its Primary Key.

b. Cndidate Key – A column or a group of

columns which can be used as the primary
key of a relation is called a Candidate key
because it is one of the candidates
available to be the primary key of the
relation.

c. Alternate Key – A candidate key of a

table which is not selected as the primary
key is called its Alternate Key.

d. Foreign Key – A primary key of a base

table when used in some other table is
called as Foriegn Key.

7. State the similarity and difference

between the Primary Key, Candidate Key,
Alternate Key and Foreign Key
Answer –
a. Primary Key – The group of one or more
columns used to uniquely identify each
row of a relation is called its Primary Key.

b. Cndidate Key – A column or a group of

columns which can be used as the primary
key of a relation is called a Candidate key
because it is one of the candidates
available to be the primary key of the
relation.

c. Alternate Key – A candidate key of a

table which is not selected as the primary
key is called its Alternate Key.

d. Foreign Key – A primary key of a base

table when used in some other table is
called as Foriegn Key.

RDBMS Class 11 Questions and Answers

8. Which statement is used to select a

database and make it current?
Answer – To choose data from a database,
use the SELECT statement. The information
received is kept in a result table known as
the result-set.

9. How is a database related to table(s)?

Answer – In databases, a table is a
collection of data elements (values)
organised using a model of vertical
columns (named) and horizontal rows, with
a cell serving as the intersection of a row
and a column. A table can have any
number of rows but only a certain number
of columns.

10. Write SQL statement to view names of

all the tables contained in the current
database.
Answer – To display all the table in
database –
SQL> SHOW TABLES;

11. In a database there is a table Cabinet.

The data entry operator is not able to put
NULL in a column of Cabinet? What may
be the possible reason(s)?
Answer – The data entry operator cannot
enter duplicate values in a column of a
cabinet; this is likely because the column
contains a primary key.

RDBMS Class 11 Questions and Answers

12. Do Primary Key column(s) of a table

accept NULL values?
Answer – Primary Key column does not
support NULL Values.

13. There is a table T1 with combination

of columns C1, C2, and C3 as its primary
key? Is it possible to enter:
a. NULL values in any of these columns?
b. Duplicate values in any of these
columns?
Answer –
a. No
b. Not possible

18. What are the differences between

DELETE and DROP commands of SQL?

Answer – The DELETE command in Data

Manipulation Language (DML) is used to
remove tuples or records from a relation or
table. In contrast, the DDL command
DROP is used to delete named schema
elements such as relations, tables,
constraints, or the whole schema.

RDBMS Class 11 Questions and Answers

19. How many types of language are there

in the database?

DDL (Data definition language) – Data

definition language is used to design and
modify the structure of a database.
Common DDL commands are
a. Create – This command is used to create
database
b. Alter – This command is used to modify
the database.
c. Drop – This command is used to delete
database tables.

DML (Data manipulation language) – Data

manipulation language provides
commands for manipulating data in
databases.
Common DML commands are
a. Select – This command is used to display
information from the database.
b. Insert – This command is used to insert
new records in the database.
c. Delete – This command is used to delete
records from the database.
d. Update – This command is used to
modify records in the database.

20. Consider the following table

“Teachers”

Rollno Student_Name DOB A

1 Jugal 10/01/2003 M

2. Pratigya 24/03/2002 Pu

3 Sandeep 12/12/2003 De

4 Sangeeta 01/07/2004 Ba

5 Satti 05/09/2002 M

RDBMS Class 11 Questions and Answers

Write SQL commands:
a. To display all the information from the
table whose address is ‘Mumbai’.

Answer – Select * from students where

address = “Mumbai”;

b. To list the details of all the students

whose percentage is between 90 to 100.

Answer – Select * from students where

percentage >= 90 and percentage <= 100;

c. To display the name of all the students

whose gender is Female.

Answer – Select Subject from students

where Gender = ‘F’;

d. To display the list of names of all the

students in alphabetical order.

Answer – Select * from students order by

Student_name;

21. Write the SQL commands to answer

the queries based on Fabric table

FabricID Fname Type Disc

F001 Shirt Woolen 10

F002 Suit Cotton 20

F003 Tunic Cotton 10

F004 Jeans Denim 5

RDBMS Class 11 Questions and Answers

a. Write a query for insert the following
record
(“F005”, “Kurta”, “Woollen”,5)

Answer – insert into Fabric values (‘F005’,

‘Kurta’, ‘Woolen’,5);

b. Write a query to display only those

fabric whose disc is more than 10

Answer – select * from Fabric where

Disc>10;

c. To display those record whose type is

‘Woolen’

Answer – select * from Fabric where type =

‘Woolen’;

d. To modify the fabric shirt by increasing

discount by 10

Answer – update fabric set Disc = Disc + 10

where Fname = ‘Shirt’;

e. To delete the record of fabric F003 from

table

Answer – delete from Fabric where

FabricID =‘F003’;

22. Consider the following Vendor table

and write the queries

VendorID VName DateofRegistration

Mother
V001 20-01-2009
Dairy

V002 Havmor 01-04-2015

V003 Amul 12-05-2012

Kwality
V004 15-10-2013
Walls

RDBMS Class 11 Questions and Answers

a. Write a Query to display all records

Answer – Select * from Vendor;

b. Write a Query to add a new row with

the following details
(„V005‟, „Vadilal‟, „2010-03-20‟, „Pune‟)

Answer – Insert into Vendor values

(“V005‟, “Vadilal‟, “2010-03-20‟, “Pune‟);

c. Write a query to modify the location of

V003 from Kolkata to Gujrat

Answer – Update Vendor Set location=

“Gujrat‟ Where location= “Kolkata‟;

23. Consider the following table “ITEM”:

Itemno Iname Price Quantity

11 Soap 40 80

22 Powder 80 30

33 Face cream 250 25

44 Shampoo 120 100

55 Soap box 20 50

RDBMS Class 11 Questions and Answers

a. Display the total amount of each item.
The amount must be calculated as the
price multiplied by quantity for each item.

Answer – Select price * quantity from item;

b. Display the details of items whose price

is less than 50.

Answer – Select * from item where price <

50;

Employability Skills Class 11 Notes

Unit 1 : Communication Skills Class
11 Notes
Unit 2 : Self-Management Skills
Class 11 Notes
Unit 3 : Information and
Communication Technology Skills
Class 11 Notes
Unit 4 : Entrepreneurial Skills Class
11 Notes
Unit 5 : Green Skills Class 11 Notes

Employability Skills Class 11 MCQ

Unit 1 : Communication Skills Class
11 MCQ
Unit 2 : Self-Management Skills
Class 11 MCQ
Unit 3 : Information and
Communication Technology Skills
Class 11 MCQ
Unit 4 : Entrepreneurial Skills Class
11 MCQ
Unit 5 : Green Skills Class 11 MCQ

Employability Skills Class 11

Questions and Answers
Unit 1 : Communication Skills Class
11 Questions and Answers
Unit 2 : Self-Management Skills – III
Unit 3 : Information and
Communication Technology Skills
Class 11 Questions and Answers
Unit 4 : Entrepreneurial Skills Class
11 Questions and Answers
Unit 5 : Green Skills Class 11
Questions and Answers

Information Technology Class 11

Notes
Unit -1 : Computer Organization
Class 11 Notes
Unit -2 : Networking And Internet
Class 11 Notes
Unit-3 : Office Automation Tools
Class 11 Notes
Unit-4: RDBMS Class 11 Notes
Unit-5: Fundamentals of Java Class
11 Notes

Information Technology Class 11

MCQ
Unit -1 : Computer Organization
Class 11 MCQ
Unit -2 : Networking And Internet
Class 11 MCQ
Unit-3 : Office Automation Tools
Class 11 MCQ
Unit-4: RDBMS Class 11 MCQ
Unit-5: Fundamentals of Java Class
11 MCQ

Information Technology Class 11

Questions and Answers
Unit -1 : Computer Organization
Class 11 Questions and Answers
Unit -2 : Networking And Internet
Class 11 Questions and Answers
Unit-3 : Office Automation Tools
Class 11 Questions and Answers
Unit-4: RDBMS Class 11 Questions
and Answers
Unit-5: Fundamentals of Java Class
11 Questions and Answers

CBSE Skill Education, Information

Technology Class 11
Office Automation Tools Class 11
Questions and Answers
Fundamentals of Java Class 11 Notes

About Us

We are a team of teachers dedicated to

enhancing skill-based education.
Whenever we have free periods, we create
notes, MCQs, and Q&A for students, All
the important Information are taken from
the NCERT Textbook.

Subscribe to Blog using Email

Enter your email address to subscribe our

website and receive latest notification of
new posts by email.

Email

Subscribe

Recent Activity
Algorithm Flowchart
Artificial Intelligence Class 10
Artificial Intelligence Class 11
Artificial Intelligence Class 12
Artificial Intelligence Class 9
CBSE Academic
CBSE NCERT Books PDF
CBSE Skill Education
Computer Application Class 9
Computer Science Class 11
Computer Science Class 12
Employability Skills class 10
Employability Skills Class 10 MCQ
Employability Skills Class 10 MCQ Online
Test
Employability Skills Class 10 Notes
Employability Skills Class 10 Question
Answers
Employability Skills Class 11
Employability Skills Class 11 MCQ
Employability Skills Class 11 Notes
Employability Skills Class 11 Questions
and Answers
Employability Skills Class 12
Employability Skills Class 9
Employability Skills Class 9 MCQ
Employability Skills Class 9 Notes
Employability Skills Class 9 Online Test
Employability Skills Class 9 Questions and
Answers
Information Technology Class 10
Information Technology Class 10 MCQ
information technology class 10 ncert
solutions
Information Technology Class 10 Notes
Information Technology Class 11
Information Technology Class 12
Information Technology Class 9
Physical Education
Web Application Class 11
Web Application Class 12

Archives
October 2024
September 2024
August 2024
March 2024
November 2023
March 2023
February 2023
January 2023
December 2022
November 2022
October 2022
September 2022
August 2022
July 2022
June 2022
May 2022
April 2022
March 2022
February 2022

© 2024 CBSE Skill Education • Built with

GeneratePress