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.
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 | Address | Mobile_no | Gender | Percentage |
|---|---|---|---|---|---|---|
1 | Jugal | 10/01/2003 | Mumbai | 5555555555 | M | 98 |
2. | Pratigya | 24/03/2002 | Pune | 4444444444 | F | 82 |
3 | Sandeep | 12/12/2003 | Delhi | 8888888888 | M | 91 |
4 | Sangeeta | 01/07/2004 | Banglore | 6666666666 | F | 96 |
5 | Satti | 05/09/2002 | Mumbai | 7777777777 | M | 89 |
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 |
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 | Location |
|---|---|---|---|
V001 | Mother Dairy | 20-01-2009 | Delhi |
V002 | Havmor | 01-04-2015 | Gujrat |
V003 | Amul | 12-05-2012 | Kolkata |
V004 | Kwality Walls | 15-10-2013 | Mumbai |
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 |
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