What is Database? Class-10-Unit-3-Ch-2 (PART-B)-2026-27:

CBSE-SOLUTIONS

CLASS-10

PART-B

UNIT-III-Chapter-2 Database Management System (Advanced)

To view my YoutTube channel Click here

Click here to view shorts from YouTube Channel

A. Multiple Choice Questions

1.What identifies the content of a field? 

(a) Data (b) Field value (c) Field name (d) Table name
Answer: (c) Field name
2. Which of the following is not a field type in MS Access? 

(a) Hyperlink (b) Number (c) Currency (d) True/false
Answer: (d) True/false

3. Field validation is set in fields: 

(a) Input Mask property (b) Validation Rule property (c) Default Value property (d) Validation Act property
Answer: (b) Validation Rule property
4. Which of the following wizard is used to create Lookup fields? 

(a) Table Wizard (b) Form Wizard (c) Field Wizard (d) Lookup Wizard
Answer: (d) Lookup Wizard
5. Text datatype in MS Access stores: 

(a) Upto 64000 characters (b) Upto 255 characters (c) Upto 1024 characters (d) Upto 13064 characters
Answer: (b) Upto 255 characters
6. Which of the following is not a Microsoft Access database object? 

(a) Queries (b) Tables (c) Forms (d) SQL
Answer: (d) SQL
7. What is the full form of SQL? 

(a) Sequence Query Language (b) Structured Query Language (c) Structured Query Layout (d) Sequential Query Language
Answer: (b) Structured Query Language
8. Which of the following is a basic object of a database? 

(a) Form (b) Query (c) Table (d) Report
Answer: (c) Table
9. A form can be prepared for: 

(a) Automating the task (b) Accepting input (c) Printing labels (d) None of these
Answer: (b) Accepting input
10. Which of the following is not an aggregate function in SQL? (a) SUM() (b) MAX() (c) AVG() (d) CONCAT()
Answer: (d) CONCAT()
11. __________ DDL command is used to create a table. 

(a) ALTER (b) CREATE (c) DESIG (d) NEW
Answer: (b) CREATE
12. __________ DDL command is used to change the structure of a database. 

(a) CHANGE (b) TRUNCATE (c) ALTER (d) MODIFY
Answer: (c) ALTER
13. __________ property is used to filter the data either in the ascending or descending order. 

(a) Sort (b) Arrange (c) Query (d) Criteria
Answer: (a) Sort
14. __________ helps us to retrieve the filtered data based upon specified conditions. 

(a) Report (b) Table (c) Query (d) Form
Answer: (c) Query
15. Which of the following is not a logical operator? 

(a) NOT (b) DOT (c) AND (d) OR
Answer: (b) DOT
16. In database, __________ helps us to retrieve the filtered data based upon some conditions. 

(a) Forms (b) Reports (c) Queries (d) Table
Answer: (c) Queries
17. Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task. 

(a) Table (b) Form (c) Relationships (d) Sorting
Answer: (c) Relationships
18. __________ data type takes the values in the form of 0 and 1 in the database. 

(a) Integer (b) Text (c) Boolean (d) Memo
Answer: (c) Boolean

B. State 'T' for True or 'F' for False

1. Maximum size of text field is 256 characters. 

Answer: False 
2. An error message appears when an incorrect or restricted value is entered in a field with a validation rule. 

Answer: True
3. There can be multiple primary keys in a table. 

Answer: False 
4. Validation Rule box is used to specify the requirements for data entered into the field. 

Answer: True
5. A query is an object of MS-Access. 

Answer: True
6. A query produces the output result like a table. 

Answer: True
7. Without a table, report can be generated. 

Answer: False
8. The UPDATE command is used for producing the query result. 

Answer: False 
9. AND is an arithmetic operator. 

Answer: False 
10. SUM() is an aggregate function in SQL. 

Answer: True
11. A form can be used to accept input from the users. 

Answer: True
12. Data entered in a form can update a table directly. 

Answer: True
13. A form can be modified in Design view. 

Answer: True

C. Fill in the blanks

1. __________ view provides the tool for creating field in a table/report.

Answer: Design

2. _________ is a field which when used as a primary key numbers each record sequentially.

Answer: AutoNumber
3. Primary key is used to ________ identify records in a table.

Answer: uniquely
4. A Number field can store upto ______ bytes.

Answer: 8
5. A _____ is a collection of records where each and every record contains similar kind of information.

Answer: table

D. Short Answer Type Questions

1. Distinguish between Number and Auto Number data type fields. 

Answer:
Number: Stores numerical values used for calculations, entered manually by the user.
AutoNumber: Generates a unique, sequential number automatically for each new record.
2. What are the views available in MS Access? 

Answer:
Datasheet View
Design View
Layout View
3. What are the steps to open MS Access? 

Answer:
Click the Start button.
Select All Programs / All Apps.
Go to Microsoft Office and click Microsoft Access.
4. What is a Query? 

Answer: A query is an object in a database used to search, filter, and extract specific records from one or more tables according to specified conditions.
5. Name the data types used in MS Access. 

Answer: Short Text, Long Text, Number, AutoNumber, Date/Time, Currency, Yes/No, OLE Object, Hyperlink, Attachment, and Lookup Wizard.
6. What are select queries used for? 

Answer: Select queries are used to retrieve and display specific data from database tables without changing the original record values.
7. How can a record be deleted from database in MS Access? 

Answer:
Open table in Datasheet View.
Click the row selector next to the record.
Right-click and choose Delete Record (or press Delete key).
Click Yes to confirm.
8. What is a Primary key? 

Answer: A primary key is a field or set of fields that uniquely identifies each record in a table. It cannot contain duplicate or null values.
9. What is a lookup wizard? 

Answer: Lookup Wizard is a feature in MS Access that creates a drop-down list to select values from another table or predefined options list.
10. What is the difference between datasheet view and design view? 

Answer:
Datasheet View: Used to enter, edit, and view records directly in row and column format.
Design View: Used to customize table structure, create fields, and assign data types and properties.
11. What is the Default value property? 

Answer: Default Value is a field property that automatically inserts a specific default value into a field whenever a new record is created.
12. Differentiate between Flat File and Relational Database. 

Answer:
Flat File Database: Data is saved in a single table or file (e.g., CSV, text file) with no linked tables.
Relational Database: Data is stored across multiple related tables linked using Primary and Foreign keys.
13. What is the use of report? Write the steps to open Report Wizard. 

Answer:
Use: Reports format, summarize, and display data for printing and analysis.
Steps:Go to the Create tab on the Ribbon.
Click Report Wizard in the Reports group.
14. What is the use of a query? 

Answer: A query allows searching, filtering, aggregating, updating, and manipulating stored table records based on criteria.
15. What are the types of queries? 

Answer: Select Query, Action Query (Append, Delete, Update, Make-Table), Parameter Query, and Summary/Aggregate Query.
16. Write the steps to open Simple Query Wizard? 

Answer:
Click the Create tab.
Select Query Wizard under the Queries group.
Select Simple Query Wizard and click OK.
17. What is the use of WHERE clause in an SQL statement? 

Answer: The WHERE clause filters SQL query output records so that only rows meeting the specified criteria are selected.
18. What is the use of a form? 

Answer: A form provides an easy graphical interface for entering, modifying, and viewing database table records one by one.
19. What is the use of AutoForm command or wizard? 

Answer: AutoForm automatically generates a basic form containing all columns/fields from the selected source table with a single click.
20. What is the use of Design View of a form? 

Answer: Design View gives full control to edit layout controls, alter formatting, change design styles, and add buttons/labels to a form.
21. What does the button >> do in Form Wizard? 

Answer: The >> button moves all fields from the available fields list to the selected fields list together.
22. How can you open the database in Design View? 

Answer: Right-click the table/object name in the left Navigation Pane and select Design View.
23. How can you modify a form in Design View? 

Answer: Open the form in Design View, select controls to drag or resize them, and open the Property Sheet to adjust field settings.

24. What is the Layout View in MS-Access? 

Answer: Layout View lets you adjust design settings while viewing real data rows in real-time.

25. In how many ways Forms and Reports can be created in a database? 

Answer: They can be created in 3 ways:
Automatic Tool (Form / Report button)
Wizard (Form Wizard / Report Wizard)
Design View
26. State the purpose of UPDATE command with the help of an example. 

Answer:
Purpose: The UPDATE command alters existing field values in a table.
Example:

• UPDATE Employee SET Salary = 50000 WHERE EmpID = 101;

27. Define the following:

Answer:
Table: A set of rows and columns storing related information.
Primary Key: A unique non-null column identifying every row uniquely.
Foreign Key: A column matching a Primary Key in another table to build relations.

E. Long Answer Type Questions

1. What do you understand by Query? Explain its types. 

Answer: A query is an SQL or Access tool used to fetch, filter, or manipulate table records.
Select Query: Retrieves and presents matching data.
Parameter Query: Displays a prompt window asking for dynamic user search criteria.
Action Query: Modifies data structure or values (Update, Delete, Append).
Crosstab Query: Formats data values into summarized matrix rows and columns.

2.  What are the steps for setting a Primary key? 

Answer:

1. Right-click the table and open Design View.
2. Click the field row selector you want to set as Primary Key.
3. Click Primary Key under the Design tab on the Ribbon.

3. Discuss various field types that are available in MS Access. 

Answer:
Short Text: Text and numeric inputs up to 255 characters.
Long Text: Long descriptive notes up to 65,535 characters.
Number: Standard numeric inputs for mathematical operations.
Date/Time: Date values and system clock values.
Currency: Financial numbers formatted with currency symbols.
AutoNumber: Automatic unique sequential values.
Yes/No: Binary/Boolean true or false fields.

4. What is the difference between (a) Short Text and Long Text (b) Number and AutoNumber. 

Answer:
(a) Short Text vs Long Text: Short Text stores max 255 characters (names, simple values), while Long Text stores up to 65,535 characters (large notes, detailed descriptions).
(b) Number vs AutoNumber: Number fields take manual numeric entries, while AutoNumber fields fill automatic incrementing sequence values for every new record.

5. Define Field Properties. 

Answer: Field properties define formatting behavior, input limits, validation constraints, and default behaviors for individual columns in a table.

6. State and explain any three types of DDL commands. 

Answer:
CREATE: Builds new tables or databases (CREATE TABLE TableName...).
ALTER: Modifies existing table structures (ALTER TABLE TableName ADD...).
DROP: Deletes tables or complete database structures permanently (DROP TABLE TableName).

7. How can you create a query in SQL View? Explain. 

Answer:
Go to the Create tab and click Query Design.
Close the Show Table window without adding tables.
Click SQL View from the top left menu.
Type your SQL statement and click Run (!) button.

8. What is Data Definition Language (DDL) and Data Manipulation Language (DML)? Give one example of each. 

Answer:
DDL (Data Definition Language): Defines, changes, or drops database structure schema.
Example: CREATE TABLE Student (ID INT, Name VARCHAR(20));
DML (Data Manipulation Language): Inserts, modifies, deletes, or fetches data records inside existing structures.
Example: INSERT INTO Student VALUES (1, 'Rahul');

9. (a) Write a Query to create a table with the following structure: 

Table Name: Product

Field	Datatype
PID	Char(4)
Pname	Varchar(20)
Description	Varchar(20)
Price	Decimal

Answer:CREATE TABLE Product ( PID CHAR(4), Pname VARCHAR(20), Description VARCHAR(20), Price DECIMAL(10, 2) );

9. (b) Consider the following Vendor table and write the queries: 

Table Name: Vendor

Vendor.ID	V.Name	Date of Registration	Location
V001	Mother Diary	20-01-2009	Delhi
V002	Havmor	01-04-2015	Gujrat
V003	Amul	12-05-2012	Kolkata
V004	Kwality Walls	15-10-2013	Mumbai

(i) Write a Query to display all records. 

Answer:

SELECT * FROM Vendor;

(ii) Write a Query to add a new row with the following details ('V005', 'Vadilal', '2010-03-20', 'Pune'). 

Answer:

INSERT INTO Vendor (VendorID, VName, DateofRegistration, Location)

VALUES ('V005', 'Vadilal', '2010-03-20', 'Pune');

(iii) Write a query to modify the location of V003 from Kolkata to Gujrat. 

Answer:

UPDATE Vendor SET Location = 'Gujrat' WHERE VendorID = 'V003';

10. Structure and Queries for table Item:

Column name	Type	Size
Item.no	-----------	-----------
I.name	-----------	-----------
Price	-----------	-----------
Quantity	-----------	-----------

(a) Suggest suitable data type and size of each column.
Answer:

Column name	Type	Size
Item.no	INT / INTEGER	4
I.name	VARCHAR	20
Price	DECIMAL / CURRENCY	(8, 2)
Quantity	INT / INTEGER	4

(b) Consider the following table Item:

Item.no	I.name	Price	Quantity
11	Soap	40	80
22	Powder	80	30
33	Face cream	250	25
44	Shampoo	120	100
55	Soap box	20	50

• Write queries to:

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

Answer:

SELECT Itemno, Iname, Price, Quantity, (Price * Quantity) AS Total_Amount FROM Item;

(ii) Display the details of items whose price is less than 50. 

Answer:

SELECT * FROM Item

WHERE Price < 50;

YOU MAY LIKE:
CBSE  Solutions-Class-10-Unit-I:
CBSE  Solutions-Class-10-Unit-II:
CBSE  Solutions-Class-10-Unit-III:
CBSE  Solutions-Class-10-Unit-IV:
CBSE  Solutions-Class-10-Unit-V:
CBSE  Solutions-Class-10-PART-B-Unit-I:
CBSE  Solutions-Class-10-PART-B-Unit-II:
CBSE  Solutions-Class-10-PART-B-Unit-III-CH-1: