Page 187 - IT-802_class_12
P. 187
2. Mention the different languages present in DBMS.
3. Explain the concepts of a Primary key and Foreign key with an example.
4. What are the differences between DROP and DELETE command?
5. What are different types of joins in SQL?
6. i. Mention at least 2 work areas which uses Database Management Systems.
ii. Jatin has given the following query from the table Student but he is unable to execute it successfully. Write the correct
query after rectifying the error. [CBSE Sample Paper 2021]
Select Name, Marks
From student Table
Where Name =”P%”
7. Consider the following table and write SQL statements [CBSE Sample Paper 2021]
Table Menu
ID Item Description Price
P001 Sambar Vada South Indian 40
P002 Dal Maakhani North Indian 150
P003 Noodles Chinese 100
P004 Idli Sambhar South Indian 50
P006 Sarson Saag North Indian 170
P007 Dosa South Indian 120
P008 Pizza Italian 200
i. To add a new row with the following data
“P009”, “Lemon Rice”, “South Indian”, 140
ii. Display details of all Menu items in the descending order of Price.
iii. Display Item and Description of those Items whose price is between 100 and 150.
iv. Add a new column Rating datatype as int to the table Menu.
Subject Enrichment
C. Competency-based/Application-based question:
Anju wants to retrieve, update, insert and delete data in a database, which SQL command should she use. Write the common
statements of that command.
Lab aCtiVity
Subject Enrichment
1. Consider the following Student table:
Table Name: STUDENT
STUD_ID STUDENT_NAME CLASS MARKS BONUS MARKS AGE TEACHER_ID
1001 AMIT X 90 NULL 17 NULL
1009 SUMIT XI 88 4 18 1205
1004 AJAY XII 78 7 19 1206
1002 ARUN IX 94 NULL 16 1203
Database Concepts—RDBMS Tool 185

