Class 10 Computer Science Database Management System Notes and Important Questions
Loading notes…
Notes for Class 10 Database Management System (Computer Science) are shown above.
Important Questions
Consider the following table named Employee:
Emp_ID | Name | Department | Salary |
|---|---|---|---|
101 | Riya | IT | 35000 |
102 | Sagar | HR | 30000 |
103 | Nabin | IT | 40000 |
Answer the following:
a. Which field should be used as the primary key? Give a reason.
b. Write an SQL command to display the names of employees working in the IT department.
c. Write an SQL command to increase Nabin's salary to 45000.
d. Write an SQL command to add a new employee with ID 104, name "Mina", department "Finance", and salary 32000.
Consider the following student table:
Student_ID | Name | Class | Marks |
|---|---|---|---|
101 | Anisha | 10 | 78 |
102 | Bibek | 10 | 65 |
103 | Suman | 10 | 82 |
Answer the following:
a. Identify the fields and records in the table.
b. Which field can be used as the primary key? Give a reason.
c. Write an SQL command to display the names and marks of all students.
d. Write an SQL command to change Suman's marks to 85.
Which command is used to test whether a destination device is reachable over a network?
ping
format
mkdir
copy
Consider the following table named Student:
Student_ID | Name | Class | GPA |
|---|---|---|---|
201 | Anil | 10 | 3.45 |
202 | Sarita | 10 | 3.80 |
203 | Rohan | 10 | 3.20 |
Answer the following:
a. Which field should be the primary key? Why?
b. Write an SQL command to display students having GPA greater than 3.40.
c. Write an SQL command to change Rohan's GPA to 3.50.
d. Write an SQL command to display all students in descending order of GPA.
Consider the following database table:
Roll_No | Name | Subject | Marks |
|---|---|---|---|
1 | Aarav | Computer | 75 |
2 | Bina | Computer | 82 |
3 | Kiran | Computer | 68 |
Answer the following questions:
a. What is a database?
b. Identify the primary key in the table and give a reason.
c. Write an SQL command to display all records from the table.
d. Write an SQL command to change Bina's marks to 90.
Define database and DBMS. Also, explain fields and records with suitable examples.
25 more questions locked
Upgrade to a paid plan to view all important questions
This page covers Database Management System, chapter 2 of 5 in the Class 10 Computer Science syllabus set by the National Examination Board (NEB). 29 important questions for this chapter are available, each with a full solution.
For numerical and derivation-based chapters like this one, working through past NEB questions is usually more useful than re-reading notes alone — try solving each important question above before checking the solution, then compare your working step by step.