Class 10 Computer Science Database Management System Notes and Important Questions
Learn
Loading PDF viewer…
Notes for Class 10 Database Management System (Computer Science) are shown above.
Practice
Important Questions
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.
Define database and DBMS. Also, explain fields and records with suitable examples.
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.
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.
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.
Which command is used to test whether a destination device is reachable over a network?
ping
format
mkdir
copy
25 more questions locked
Upgrade to a paid plan to view all important questions
Exam
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 model answer.
Read through the notes above, then try each important question for this chapter before checking its solution — comparing your working against past NEB and model questions is one of the most efficient ways to revise.