Important SQL Commands Class 10 IT Code 402 Questions and Answers Unit 3 RDBMS

Share with others

SQL commands Class 10
SQL commands Class 10

SQL Commands Class 10 IT Code 402

SESSION 4: RETRIEVE DATA USING QUERY

Q1. What do you mean by query in Open Office Base?

Q2. In how many ways you can create query in Open Office Base?

Q3. Name the Query language which is used in Base?

Q4. Which command is used to retrieve data from the table?

SQL Commands Class 10 IT Code 402

Q5. Name two categories of SQL Commands.

Q6. Differentiate between DDL and DML Commands.

Q7. Identify the DML Commands from the following :

  1. Create
  2. Alter
  3. Insert
  4. Delete

Q8. __________ is the most commonly used Data Manipulation Language(DML) command.

SQL Commands Class 10 IT Code 402

Q9. Name two clauses which can be used with Select Command.

Q10. Write the Select command to display all the records of table “book”.

Q11. Write the shortcut to execute query in “Create query in SQL view” of Base.

Q12. What is the purpose of Where clause in Select Command?

SQL Commands Class 10 IT Code 402

Q13. What is the purpose of Order by clause in Select Command?

Q14. Write the queries for the following table : Emp

Emp_idEnameSalary
1Suman20000
2Sanjay32000
3Ravi30000
SQL Commands Class 10

a. Display the salary of all the employees after incrementing by Rs 1000.

b. Display the Employee id and salary of all the employees after decreasing by Rs 500.

c. Display the Name and salary of all the employees after incrementing it as thrice the amount of present salary.

d. Display the Employee id, Name and salary of all the employees after decrementing it as half the amount of present salary.

e. Display the Employee id and Name of all the employees.

SQL Commands Class 10 IT Code 402

Q15. Write the queries for the following table : Student

AdmnoNameClassHouse
1001Sonam9Blue
1002Ravi10Yellow
1003Poonam10Green
SQL Commands Class 10

a. Display the entire table

b. Display the list of students whose house color is blue.

c. Display the admission number of students whose house color is green.

d. To view records in ascending order of Admission Number.

e. Display the records of Class 10 Students.

f. Display the class of ‘Ravi’

g. Insert the given record : 1004, “Aman”, 11, “Blue”

SQL Commands Class 10 IT Code 402

Q16. Which command is used for the following task in database?

  1. To insert a new record
  2. To modify the existing data.
  3. To delete a record
  4. To display record

Q17. Write the queries for the following table : Item

ItemnoInamePriceQty
12Pen1017
13Eraser515
14Notebook1520
SQL Commands Class 10

a. Write a query to insert a new record of following details

15, “Pencil”, 20, 10

b. Write a query to display detail of items whose quantity is more than 10.

c. Write a query to change the quantity of Item number 13 to 25.

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

e. Display the name of item whose price is 10.

f. Display all the records in descending order of price.

g. Identify the Primary key from table Item.

h. Write the suitable data type of field “Iname”.

i. Write a query to increase the price of all items by Rs2.

j. Write a query to decrease the price of all items by Rs2 whose price is less than 20.

Q18. By default, data is arranged in _________ order using ORDER BY clause.

Q19. Which clause is used for the following:

a. To display specific record.

b. To display records in a particular order.

Q20. Consider the following table: STUDENT [C.B.S.E. – 2021]

ADMNONAMEGRADEDOBMARKSHOUSEGENDER
1001RUPAL910/04/200676GREENM
1002RASHMI908/12/200587REDF
1003ARNAV1025/05/200481GREENM
1004SUMONA923/08/200568REDF
1005ARUN916/07/200572GREENM
1006TIA922/09/200591BLUEF
1007ROSHAN1026/08/200489BLUEM

Write SQL Commands:

a) To Display the details of all students of Green House.

b) To increase the marks by 5 whose ADMNO is 1005.

c) To display the details of all students whose MARKS are less than 80.

d) Display the list of all students in descending order of MARKS.

Q21. Identify any two Column name/Attribute and their data types from a given table: PLAYER. [C.B.S.E.]

PIDPNAMERUNSGENDERDOB
P101SACHIN13000M10/04/2001
P102KAPIL7000M12/02/1998
P103SAURABH 12000M13/04/2001
P104VIRAT12500M17/03/2005

Q22. Consider the following table: EMPLOYEE [C.B.S.E.]

EMPIDNAMESALARYDOJCOMMDEPTGENDER
1001ROHAN700010/04/2006300SALESM
1002RISHU1200008/12/2005100FINANCEF
1003DEVANSH900025/05/2004500SALESM
1004SUMAN1000023/08/2005300MARKETINGF
1005ARYAN1100016/07/2005500SALESM
1006TAMANNA1500022/09/2005200FINANCEF
1007ROHIT800026/08/2004900SALESM

Write SQL Commands :

a) To display the details of all employees of SALES Department.

b) To increase the SALARY by 1000 whose EMPID is 1007.

c) To display the details of all employees whose SALARY is more than 10000.

d) To display the list of all employees in descending order of SALARY.

Q23. Consider the following table: Sales [Sample Paper-2022]

Sale_IdProd_NamePriceDiscount
1101Laptop650002500
1103Pen Tab295001000
1105Desktop500001550
1106Printer120002000
  1. How many fields and records are there in Sales table?
  1. Write SQL commands for the following:
    i. Display Sales ID and price of all products whose discount is more than 1000.
    ii. Display the details alphabetically by product name.
    iii. Display product name and sales price after deducting the discount from the price.
    Note: Sales price can be calculated as (price-discount)

Q24. Consider the following table: Teachers

NUMBERNAMEAGESUBJECTDATEOFJOINSALARYGENDER
1JUGAL34COMPUTER10/01/201912000M
2PRATIGYA31SCIENCE24/03/201920000F
3SANDEEP32MATHS12/12/201930000M
4SANGEETA35SCIENCE01/07/202040000F
5SATTI42MATHS05/09/202025000M
6SHYAM50SCIENCE27/06/202130000M
7SHIV OM44COMPUTER25/02/2021 21000M
8SHALAKHA33MATHS31/07/202020000F

Write SQL commands:
a. To show all the information about IT teachers.
b. To list the details of all the teachers who are getting salary between 20000 to 35000.
c. To display the subject of all the teachers whose age is more than 40 years.
d. To display the list of names of all the teachers in alphabetical order.

Q25. Consider the following table “Datesheet” and write the queries for the following: [CBSE Sample Paper – 2023]

Sub_CodeSub_NameDateofExamDays
E001English11-03-2021Monday
H002Hindi15-03-2021Friday
S003Social Sci18-03-2021Monday
S004Science21-03-2021Thursday

i. Write a SQL command to display the records in ascending order by date of exam.
ii. Write a query to display the above date sheet.
iii. Write a query to display the subject name and date of the exam held on ‘Monday’
iv. Write a SQL command to display the date of exam and Sub_Name of Science subject.

Q26. Consider the following table “School” and write the queries for the following:

Roll_noStudent_NameDateofBirthClass
R12Aman11-03-201210
R43Sumit15-03-20159
R23Dhriti18-03-201010
R1Parth21-03-20109
  1. Write a query to display all records in alphabetical order of Name.
  2. Write a query to change the class of “Dhriti” from 10 to 7.
  3. Write a query to display the above table.
  4. Write a query to display Roll number and Name of Class 10 students.
  5. Display detail of all students of class 9.
  6. Insert a new record with value: ‘R24’, ‘Kamal’, ’15-05-2010′, 8
  7. Display detail of all students whose class is greater than 9.


SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT SYSTEM

SESSION 2: CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS

SESSION 3: PERFORM OPERATIONS ON TABLE

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD



SQL commands Class 10
SQL commands Class 10

SQL Commands Class 10 IT Code 402

Disclaimer : I tried to give you the correct answers of above SQL Commands Class 10 but if you feel that there is some mistake in above SQL Commands, feel free to contact me at csiplearninghub@gmail.com


SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402

SQL Commands Class 10 IT Code 402


Share with others

7 thoughts on “Important SQL Commands Class 10 IT Code 402 Questions and Answers Unit 3 RDBMS”

Leave a Reply

error: Content is protected !!