ST.
XAVIER'S SCHOOL, MUZAFFARPUR
CLASS - X SUB - IT
ASSIGNMENT
CHAPTER - DATABASE
Multiple Choice Questions (MCQs):
1. Which of the following is a DBMS?
a) Excel b) Oracle c) Word d) PowerPoint
Answer: b) Oracle
2. Which language is used to query a database?
a) HTML b) SQL c) Java d) Python
Answer: b) SQL
3. Which is an example of a relational database?
a) Microsoft Access b) Microsoft Word c) Notepad d) Excel
Answer: a) Microsoft Access
4. Which of the following is a type of database model?
a) Hierarchical b) Relational c) Object-oriented d) All of the above
Answer: d) All of the above
5. What is a field in a database?
a) A set of records b) A single data element
c) A table of information d) A collection of queries
Answer: b) A single data element
6. Which of the following is true about SQL?
a) SQL is used to design a database
b) SQL is used to perform calculations
c) SQL is used to manipulate and retrieve data from databases
d) SQL is used to create animations
Answer: c) SQL is used to manipulate and retrieve data from databases
7. Which of the following is not a type of SQL command?
a) DML b) DDL c) DCL d) DLL
Answer: d) DLL
8. Which of the following is used to remove a table from a database?
a) DROP TABLE b) DELETE TABLE
c) REMOVE TABLE d) REMOVE FROM
Answer: a) DROP TABLE
9. Which SQL command is used to add a new record to a table?
a) INSERT b) ADD c) CREATE d) UPDATE
Answer: a) INSERT
10. Which of the following is true about a primary key in a database?
a) It can contain duplicate values
b) It can be left empty
c) It uniquely identifies each record in a table
d) It is used to store images
Answer: c) It uniquely identifies each record in a table
Fill in the Blanks:
1. A ___ is used to store data in a database.
Answer: Table
2. The SQL command used to delete all records from a table is ___.
Answer: DELETE
3. ___ is used to modify an existing record in a database.
Answer: UPDATE
4. The ___ key is used to uniquely identify a record in a table.
Answer: Primary
5. In SQL, the ___ clause is used to filter records based on a specified condition.
Answer: WHERE
6. A ___ is a collection of tables in a database.
Answer: Schema
7. The ___ clause is used to group records based on common attributes.
Answer: GROUP BY
8. The ___ command is used to retrieve data from a database.
Answer: SELECT
9. A ___ relationship in a database refers to a relationship where one record in a table is linked to
multiple records in another table.
Answer: One-to-many
10. ___ is a language used to manage and manipulate databases.
Answer: SQL
Short Answer Type Questions:
1. What is a Database Management System (DBMS)?
2. Explain the difference between DDL and DML commands.
3. What is a foreign key? Give an example.
4. What is normalization in database design?
5. Write the syntax of the SQL SELECT statement.
6. What is the purpose of the WHERE clause in SQL?
7. Define primary key and explain its importance.
8. What is the difference between DELETE and DROP commands in SQL?
9. What do you mean by data redundancy?
10. What are the advantages of using a relational database?
Long Answer Type Questions:
1. Discuss the various types of relationships in a relational database. Explain with examples.
2. Describe the normalization process and explain its different forms (1NF, 2NF, 3NF).
3. Explain the role of SQL in database management. Write down some commonly used SQL
commands.
4. Describe the various steps involved in designing a database. Discuss the concepts of entity,
attribute, and relationship.
5. What are the different types of keys in a relational database? Explain the significance of each.
Assertion-Based Questions:
1. Assertion: A database can store a large amount of data.
Reason: A DBMS is designed to manage large datasets efficiently.
a) Both assertion and reason are true, and the reason is the correct explanation of the
assertion.
b) Both assertion and reason are true, but the reason is not the correct explanation of the
assertion.
c) The assertion is true, but the reason is false.
d) The assertion is false, but the reason is true.
Answer: a)
2. Assertion: SQL is a programming language used to manipulate and retrieve data.
Reason: SQL stands for Structured Query Language.
a) Both assertion and reason are true, and the reason is the correct explanation of the
assertion.
b) Both assertion and reason are true, but the reason is not the correct explanation of the
assertion.
c) The assertion is true, but the reason is false.
d) The assertion is false, but the reason is true.
Answer: a)
3. Assertion: In a relational database, each table must have a primary key.
Reason: The primary key is used to uniquely identify each record in a table.
a) Both assertion and reason are true, and the reason is the correct explanation of the
assertion.
b) Both assertion and reason are true, but the reason is not the correct explanation of the
assertion.
c) The assertion is true, but the reason is false.
d) The assertion is false, but the reason is true.
Answer: a)
4. Assertion: SQL commands are case-sensitive.
Reason: SQL keywords such as SELECT, INSERT, and UPDATE must always be written in
uppercase.
a) Both assertion and reason are true, and the reason is the correct explanation of the
assertion.
b) Both assertion and reason are true, but the reason is not the correct explanation of the
assertion.
c) The assertion is false, but the reason is true.
d) The assertion is true, but the reason is false.
Answer: c)
5. Assertion: A DBMS helps in maintaining data integrity.
Reason: DBMS systems are designed to ensure accuracy and consistency of data.
a) Both assertion and reason are true, and the reason is the correct explanation of the
assertion.
b) Both assertion and reason are true, but the reason is not the correct explanation of the
assertion.
c) The assertion is true, but the reason is false.
d) The assertion is false, but the reason is true.
Answer: a)
Case-Based Questions:
1. Case: A company has a database for managing employees. The table "Employees" contains
fields such as EmployeeID, Name, Department, and Salary. Write the SQL query to retrieve all
employees working in the "HR" department.
Answer: `SELECT FROM Employees WHERE Department = 'HR';`
2. Case: A school's database contains a table "Students" with fields such as RollNo, Name, Age,
and Marks. The school wants to update the marks of a particular student (RollNo = 5). Write the
SQL query for this task.
Answer: `UPDATE Students SET Marks = 85 WHERE RollNo = 5;`
3. Case: The "Orders" table in an e-commerce system contains OrderID, CustomerID, ProductID,
and OrderDate. The company needs to find all orders placed in the last 30 days. Write an SQL
query to find these orders.
Answer: `SELECT FROM Orders WHERE OrderDate > DATE_SUB(CURDATE(), INTERVAL 30
DAY);`
4. Case: You are designing a database for a bookstore. The database has two tables: "Books"
(BookID, Title, Author, Price) and "Sales" (SaleID, BookID, Date, Quantity). Write a query to get the
total sales for each book.
Answer: `SELECT Books.Title, SUM(Sales.Quantity) AS TotalSales FROM Sales JOIN Books
ON Sales.BookID = Books.BookID GROUP BY Books.Title;`
Application-Based Questions (8–10 lines each)
1. A school wants to maintain a database of students. Design a table STUDENT with the
following fields: RollNo, Name, Class, Section, DOB, ContactNo. Also, specify the suitable data
types and Primary Key.
2. Create a database table LIBRARY (BookID, Title, Author, Price, Publisher).
Write SQL queries to:
a) Insert 3 records.
b) Display books by a particular author.
c) Display all books costing more than ₹500.
3. An online shopping company wants to keep track of their orders in a table ORDERS (OrderID,
CustomerName, Product, Quantity, Price).
Write SQL queries to:
a) Display the total amount of each order.
b) Show the orders where Quantity > 5.
c) List all customers who purchased ‘Laptop’.
4. A company database contains two tables:
CUSTOMER (CustID, CustName, City)
ORDER (OrderID, CustID, OrderDate, Amount)
Write SQL queries to:
a) Display customer names with their order amount using JOIN.
b) Display all orders placed in the month of June.
c) Find the total sales amount city-wise.
5. Consider the following table EMPLOYEE (EmpID, Name, Dept, Salary).
Write SQL commands for:
a) Display all employees from ‘IT’ department.
b) Increase salary by 10% of all employees.
c) Show the names of employees earning more than ₹40,000.
---
