Database Management System Class 10 IT 402
Database Management System for class 10 new syllabus first term. In this part Database Management System, we will read about DBMS and its uses. With the help of these notes for class 10 IT 402 Database Management System, you will complete your study.
Multiple Choice Questions for Database Management System Class 10
Q1. Which of the following is used to present data in a printed format?
(a) Reports
(b) Forms
(c) Queries
(d) Tables
Ans. (a) Reports
Q2. Which command is used to define the structure of your tables?
(a) DDL
(b) DCL
(c) DML
(d) TCL
Ans. (a) DDL
Q3. Facilities offered by databases are
(a) the ability to store a large amount of data in a structured format, easy update, sort query, production of reports.
(b) easy edition, spell check, perform calculations, the library of mathematical functions, replication.
(c) the ability to rotate images, copy and paste, fill scale.
(d) None of the above
Ans. (a) the ability to store a large amount of data in a structured format, easy update, sort query. production of reports.
Q4. Which of the following is not an example of the database?
(a) Cross knot game
(b) Employee payroll management
(c) Numeric calculator
(d) Customer management system
Ans. (c) Numeric calculator
Q5. The database is a combination of
(a) hardware and software
(b) hardware and operating system
(c) software and operating system
(d) utility programs
Ans. (a) hardware and software
Q6. Operations performed on databases are controlled by
(a) user
(c) DBMS
(b) hardware
(d) RDBMS
Ans. (a) user
Q7. The database is made up of all the following components except
(a) tables
(b) queries
(c) forms
(d) formula bar
Ans. (d) formula bar
Q8. All the information about a thing or a person is known as a
(a) database
(b) file
(c) field
(d) record
Ans. (d) record
Q9. Out of the following, which one is the most appropriate data field in the context of the employee table if only one of these is required?
(a) Age in years
(b) Data of birth
(c) Age in days
(d) Age in months
Ans. (b) Date of birth
Q10. Which of the following is not the main building block of a database?
(a) Lists
(b) Queries
(c) Reports
(d) Forms
Ans. (a) Lists
Q11. Which of the following best describes a form?
(a) Form enables people to enter or view data in a database easily.
(b) Form summarises and prints data.
(c) A form filters data from a database based on a criteria
(d) All of the above
Ans. (a) Form enables people to enter or view data in a database easily.
Q12. DBMS is a program that controls the creation, maintenance and use of databases. Here, DBMS referred to
(a) Digital Base Management System
(b) Data Build Management System
(c) Database Management System
(d) Database Management Service
Ans. (c) Database Management System.
Q13. A computer-based record-keeping system is known as
(a) Data Manipulation System
(b) Computerised Data System
(c) Computerised Record Keeping System
(d) DBMS
Ans. (d) DBMS
Q14. RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to
(a) Record Database Management System
(b) Relational Database Management System
(c) Reference Database Management System
(d) None of the above
Ans. (b) Relational Database Management System
Q15. A database that contains tables linked by common fields is called a
(a) Centralised database
(b) Flat file database
(c) Relational database
(d) None of the above
Ans. (c) Relational database
Q16. Duplication of data is known as
(a) data security
(b) data incomplete
(c) data redundancy
(d) None of the above
Ans. (c) Data redundancy
Q17. Key field is a unique identifier for each record. It is defined in the form of
(a) rows
(b) columns
(c) tree
(d) query
Ans. (b) columns
Q18. Which of the following fields will not make a suitable primary key?
(a) A customer's account number
(b) A date-field
(c) An auto number field
(d) A student's admission number
Ans. (b) A date-field
Q19. When you define a field for a table, which of the following parameters do access always consider optional?
(a) Field Name
(b) Data Type
(c) Field Size
(d) Description
Ans. (d) Description
Q20 Which of the following is not a data type?
(a) Picture/Graphic
(b) Date/Time
(c) Text
(d) Number
Ans. (a) Picture/Graphic
Q21. The default data type for a field is
(a) Number
(b) Auto Number
(c) Currency
(d) Text
Ans. (d) Text
Q22. For what, Memo data type is used?
(a) To add table
(b) To store objects created in other programs
(c) For long text entries
(d) For short text entries
Ans. (c) For long text entries
Q23. What data type should be chosen for a zipcode field in a table?
(a) Text
(b) Number
(c) Memo
(d) All of these
Ans. (b) Number
Q24. You create a table in MS-Access. You decided to create two fields RollNo and Date of Birth, what will be the data type of the Date-of-Birth column?
(a) Number
(b) Text
(c) Yes/No
(d) Date/Time
Ans. (d) Date/Time
Q25. Which data type helps you to handle input column that is in boolean format?
(a) OLE Object
(b) Attachment
(c) Yes/No
(d) None of these
Ans. (c) Yes/No
Q26. Which of the following commands is not a Data manipulation language?
(a) Select
(b) Insert
(c) Update
(d) Alter
Ans. (d) Alter
Q27. What is the singular form for data?
(a) Datan
(b) Datas
(c) Datum
(d) Datap
Ans. (c) Datum
Q28. A column within a table that contains only one type of information is called a:
(a) Record
(b) File
(c) Field
(d) Folder
Ans. (c) Field
Q29. A collection of related records is known as:
(a) Database
(b) File
(c) Field
(d) Record
Ans. (b) File
Q30. What storage space does the Tiny Integer data type occupy in a Base table?
(a) 1 byte
(b) 2 bytes
(c) 4 bytes
(d) 6 bytes
Ans. (a) 1 byte
Q31. How much space does the TIME data type hold in Base?
(a) 2 bytes
(b) 4 bytes
(c) 6 bytes
(d) 8 bytes
Ans. (b) 4 bytes
Q32. How much space does the Biglnt data type hold in Base?
(a) 2 bytes
(b) 4 bytes
(c) 6 bytes
(d) 8 bytes
Ans. (d) 8 bytes
Q33. In which view of the table can you view the format of the table?
(a) Data view
(b) Form view
(c) Design view
(d) None of these
Ans. (a) Data view
Q34. Which dialog box allows the addition of tables to a query?
(a) Add Data
(b) Add Data tables
(c) Add Tables
(d) None of these
Ans. (c) Add Tables
Q35. Which of the following relations is most likely NOT 1:1?
(a) Student-Teacher
(b) Student-Roll Number
(c) Student-Rank in a given year
(d) None of these
Ans. (a) Student-Teacher
Very Short Answer Type Questions
Q1. What is the database? Give an example.
Ans. A collection of related information organised as tables are known as a database e.g. INGRES, MySQL etc.
Q2. What is the difference between 'Rows' and 'Columns' in a table?
Ans. In a table, rows are called records and columns are termed a field. A row stores complete information of a record whereas column stores only similar data values for all records.
Q3. What is a field in the database? Give an example.
Ans. A field is an area, reserved for a specific piece of data. It is also known as an attribute. e.g. Customer Name.
Q4. Define forms and what is the need of using them?
Ans. A form is a window or screen that contains numerous fields or spaces to enter data. Forms can be used to view and edit your data. It is an interface in a user-specified layout.
Q5. What does DBMS stand for?
Ans. DBMS stands for Database Management System. It is a computer-based record-keeping system.
Q6. What does RDBMS stand for?
Ans. RDBMS stands for Relational Database Management System. It is a type of DBMS that stores data in the form of relations (tables).
Q7. How is data organized in an RDBMS?
Ans. A relational database is a type of database. It uses a structure that allows us to identify and access data in relation to another piece of data in the database. Data in a relational database is organized into tables.
Q8. Write the purpose of DBMS.
Ans. DBMS is used to store logically related information at a centralised location. It facilitates data sharing among all the applications requiring it.
Q9. Write any two uses of the database management system.
Ans. (i) DBMS is used to store data at a centralised location.
(ii) It is used to minimise data redundancy and data inconsistency.
Q10. Write any two advantages of using the database.
Ans. (i) It can ensure data security.
(ii) It reduces the data redundancy.
Q11. Give any two disadvantages of the database.
Ans. (i) A database system creates additional complexity and requirements.
(ii) A database system is multi-user software, which is less efficient.
Q12. A table named School (containing data of students of the whole school) is created, where each record consists of several fields including AdmissionNo (Admission Number), RollNo (Roll Number), Name. Which field out of these three should be set as the primary key and why?
Ans. AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with Roll No and Name.
Q13. When Memo data type is preferred over Text data type for a field?
Ans. When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length cannot be more than 255 characters so, Memo data type is preferred over Text data type.
Q14. What happens when text is entered in a Number type field?
Ans. When we enter text in a Number field and press Enter or press Tab key, MS-Access displays a message that "The value you entered does not match the Number data type in this column."
Q15. List datatypes available in Numeric datatype.
Ans. Datatypes available in Numeric datatype are TINYINT, SMALLCINT, MEDIUMINT, INT and BIGINT.
Q16. List datatypes available in Date datatype.
Ans. Date data type is available in Date datatype.
Q17. Write one example of a data field for which you would set the Required property to Yes?
Ans. In a table, when we declare a field as a primary key, then the field's Required property must be set to yes because, in a primary key field, we need to enter data always.
Q18. What is the purpose of Default Value field property?
Ans. If there is a situation when you want to enter the same value for all records. Then, to avoid typing the same thing many times, you can set it as a Default Value property.
Q19. What do you mean by DDL?
Ans. DDL (Data Definition Language) is used to define the structure of your tables and other objects in the data database. It allows you to create, alter and destroy database objects.
Q20. Name the components of a database.
Ans. Data, Software, Hardware and User are the major components of a database.
Q21. What is the use of software in databases?
Ans. It is a set of programs that lies between the stored data and the users of the database. It is used to control and manage the overall computerised database. It is different types of software such as MySQL, Oracle etc.
Q22. How does DBMS help deal with data inconsistency?
Ans. It helps to avoid data inconsistency. It means if a single database is used by multiple users then it also ensures that the same data is present for all the users. For example, if the two departments (HR and IT) access the data simultaneously then only one department will see the updates by the other department. DBMS solves this issue.
Q23. What is an RDBMS?
Ans. RDBMS stands for Relational Database Management System. This name is used for databases that are developed by using the relational database model as prescribed by E.F. Codd, of IBM's San Jose Research laboratory. The most popular database systems in use are RDBMS-es.
Q24. What does the primary key do?
Ans. The former case is that of the field being called a primary key. It is the field that varies from row to row. The latter case is that of a composite primary key. In this case, not one but a combination of fields make up the primary key.
Q. How can you create a table using Create command?
Ans.
(
column_A name1 data_type (Size),
column_A name2 data_type (Size),
:
);
Q23. Create a table STUDENT based on the following table instance.
| Column Name | Data Type | Length |
|---|---|---|
| ID | integer | |
| Name | varchar | 15 |
| Stream_Id | integer |
Ans. CREATE TABLE STUDENT (ID Integer, Name varchar (15), Stream-Id Integer);
Q24. Write a SQL command to create the table BANK whose structure is given below:
| Field Name | Datatype | Size | Constraint |
|---|---|---|---|
| ID_Number | integer | 10 | Primary key |
| Name | varchar | 20 | |
| B_date | date | ||
| Address | varchar | 50 |
Ans. The SQL command to create a table as per the given structure is as follows:
MySQL> CREATE TABLE BANK (ID_Number integer (10) PRIMARY KEY, Name varchar (20), B_date date, Address varchar (50));
Q25. Insert some information into a table COLLEGE, whose structure is given below:
| Roll_no | Name | Class | Branch |
|---|---|---|---|
Ans. (i) MySQL> INSERT INTO COLLEGE (ROLL_NO, NAME, CLASS, BRANCH) VALUES (1, 'ROHAN', 12, 'SCIENCE');
(ii) MySQL> INSERT INTO COLLEGE (ROLL_NO, NAME, CLASS, BRANCH) VALUES (2, 'NEHA', 12, 'SCIENCE');
(iii) MySQL> INSERT INTO COLLEGE (ROLL_NO, NAME, CLASS, BRANCH) VALUES (3, 'AMIT', 12, 'COMMERCE');
Short Answer Type Questions
Q1. Distinguish between data and information.
Ans. Distinguish between data and information are as follows:
| Data | Information |
|---|---|
| It is a raw fact. | It is a processed form of data. |
| It considers facts, symbols, images for reference or analysis. | It considers knowledge derived from study, experience or instruction. |
| e.g. 23 is data. | e.g. age=23 is information. |
Q2. What are the main purposes of a database system?
Ans.
- Storage of information.
- Retrieval of information quickly.
- Sorting, selecting data that satisfies certain and readable format.
- Produce the report in some standardised and readable format.
Q3. How are fields, record and a table related to each other? Explain with the help of an example.
Ans. Fields are one type of information. A record contains logically related fields. A table Emp name contains logically related records.
| EmpNo | Name | Salary |
|---|---|---|
| 1 | Shridhar | 20,000 |
| 2 | Raghav | 40,000 |
Here, EmpNo, Name and Salary are three different fields. 1, Shridhar, 20,000 represents one complete record.
Q4. Define query in the context of database.
Ans. A query is an inquiry into the database using the SELECT statement. These statements give you filtered data according to your conditions and specifications indication the fields, records and summaries which a user wants to fetch from a database.
Q5. What do you mean by data integrity?
Ans. Data integrity refers to the overall accuracy, completeness, and reliability of data. It can be specified by the lack of variation between two instances or consecutive updates of a record, indicating that your information is error-free.
Q6. What is the utility of the primary key in a database? Write distinct features of primary keys.
Ans. The primary key is used to uniquely identify the record in a database. It can be a column or a set of columns in the table. The main features of the primary key are as follows:
- It must contain a unique value for each record of a table.
- It does not contain null values.
Q7. State the relationship and difference between a primary and foreign key.
Ans. Relationship between primary key and foreign key:
A foreign key is a column or set of columns in one table that references the primary key columns in another table.
Difference between primary key and foreign key Primary key can't accept null values whereas foreign key can accept multiple null values.
Q8. Define the following data types: (i) AutoNumber (ii) Currency (iii) Text
Ans. (i) AutoNumber: It allows to store numbers that are automatically generated for each record. It increases the number automatically.
(ii) Currency: It allows to store monetary values that can be used in calculations accurate up to 15 digits on L.H.S and 4 digits on R.H.S of decimal points.
(iii) Text: It allows to store text or a combination of text and numbers, as well as numbers that don't require calculations such as phone numbers.
Q9. Distinguish between Text and Memo data types.
'or'
How are field types Text and Memo different from each other? Explain with the help of an example.
Ans. Distinguishing between Text and Memo are as follows:
| Text | Memo |
|---|---|
| It is used for relatively short entries. | It is used for long text paragraphs. |
| It can store up to 255 characters only. | It can store up to 65536 characters. |
| It uses field size property to control the number of characters. | It does not use field size property. |
| e.g. Emp_name | e.g. Emp_description |
Q10. A text field is initially 40 characters long and one record has an entry in this field in the MS-Access database. The field value contains 28 characters, including spaces. Now, you have reduced the length of the field to 20 characters. What will happen to the field value?
Ans. Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.
Q11. What do you mean by Entry Required field information?
Ans. Entry Required field information decides whether entering data in the field is necessary or not. So, if Entry Required is set to Yes, then that field must have some value in it. By default, the Entry required is set to Yes.
Q12. When is AutoNumber data type preferred over Numberdata type?
Ans. When you want to increment the number automatically as you add or delete the records. AutoNumber data type is preferred. Also, if the table does not have a primary key, then AutoNumber uniquely identifies the record.
Q13. How to insert a field into a table in Datasheet view?
Ans. Steps to add a field into a table are as follows:
Step 1: Right-click on the table and click Datasheet View.
Step 2: To insert a new column, click the Insert in Datasheet tab or right-click the header (Field Name) of the field that follows the new field.
Step 3: Click at Insert Column from the menu.
Q14. Write the steps to create a form using the Split Form command.
Ans. To create a form using a Split Form command, follow the given steps:
Step 1: First, select the table for which you want to create a form.
Step 2: Click the Create tab in the ribbon.
Step 3: Select the Split Form option from the Forms group.
After this, the form will be shown in the upper part and the lower part will show the datasheet view.
Q15. What do you mean by the UPDATE command?
Ans. UPDATE command is used to update a single record or multiple records in a table. The UPDATE command is used to modify the existing rows in a table.
Syntax
UPDATE <table name> SET<Columnl> =<value 1>, <Column 2>=<value 2>,... WHERE <condition>;
Q16. Write SQL command to create the table VEHICLES with given constraint and also add some information in it.
| Column Name | Data type (Size) | Constraint |
|---|---|---|
| Reg_No | char (15) | Primary Key |
| Reg_Date | date | |
| Owner_Name | varchar (20) | |
| Address | varchar 40 |
Ans. To create a table using the CREATE TABLE command
mysql> (CREATE TABLE VEHICLES (RegNo char(15)Primary key, Reg_Date date, Owner_Name varchar (20), Address varchar (40));
To add information using the INSERT command
mysql>INSERT INTO VEHICLES(Reg_No, Reg Date, Owner Name, Address) VALUES (100, 12-12-13, 'VIKAS', 'MEERUT');
Long Answers Type Questions
Q1. Discuss the components of a database.
Ans. Refer to text
Q2. Distinguish between a record and a field in a table with an example.
Ans. Distinguish between a record and a field in a table are as follows:
Record
- It is a collection of data items that represent a complete unit of information about a thing or a person.
- A record refers to a row in the table.
- Record is also known as a tuple.
- e.g. If Employee is a table, then the entire information of an employee is called a record.
Field
- It is an area in the record reserved for a specific piece of data.
- A field refers to a column in the table.
- The field is also known as attribute.
- e.g. If Employee is a table, then empld, empName, department, Salary are the fields.
Q3. Define Database Management System. Write two advantages of using a database management system for school.
Ans. Database Management System (DBMS) is a collection of programs that enable users to create, maintain a database and control all the access to the database. The primary goal of the DBMS is to provide an environment that is both convenient and efficient for users to retrieve and store information. The advantages of using DBMS for school are as follows:
(i) In school, DBMS is used to store the data about students, teachers and any other related things at a centralised location.
(ii) It provides security to the personal information of the school, stored in it.
Q4. List the data types used in a DBMS/RDBMS.
Ans. Refer to text on Page no. 110
Q5. Write one example of each field, for which you would use (i) Text data type (ii) Memo data type
Ans.
(i) Text data type: It allows to store text or combination of text and numbers as well as numbers that don't require calculations such as phone numbers. This data type allows a maximum of 255 characters to store.
e.g. If Employee is a table and Emp_No, Name and Description are fields, then the name will be a Text field. Because Name is a character entry field.
(ii) Memo data type: It allows long blocks of text that uses text formatting.
e.g. In the Employee table, the field Description will be of Memo data type, because the length of the description of the employee may be large.
Q6. Distinguishing between Number and AutoNumber data type field. Give an example of each.
Ans. Distinguishing between Number and AutoNumber data type fields are as follows:
Number
- It holds numeric values which are used for calculations.
- The field length of the data type is 1, 2, 4, 8 or 16 bytes.
- It does not support field property New values.
- Number type can store any integer/float value depending on decimal precision specified.
- e.g. In a table Employee, Salary is a Number type field.
AutoNumber
- It allows storing numbers that are automatically generated for each record.
- The field length of this data type is 4 bytes.
- It supports the field property New values.
- Autonumber will have values calculated by the system.
- e.g. In a table Bank, the Account No is an Auto Number field as, for every new customer, this field will automatically increase and will provide a new number.
Q7. Explain Data Manipulation Language (DML) in SQL database?
Ans. DML provides various commands used to access and manipulate data in the existing database. This manipulation involves inserting data into the database tables, retrieving existing data, deleting data from existing tables and modifying existing data.
DML is mostly incorporated in the SQL database. The basic goal of DML is to provide efficient human interaction with the system.
The DML are of two types:
1. Procedural DMLs: These require a user to specify what data is needed and how to get it.
2. Non-Procedural DMLs: These require a user to specify what data is needed without specifying and how to get it.
Q8. How to design a report using Report Wizard?
Ans. To design a report using Report Wizard, follow the given steps:
Step 1: First, select the table for which you want to design reports.
Step 2: Click on Create tab from the ribbon.
Step 3: In the Reports group, select the Report Wizard option. Report Wizard dialog box will appear on the screen.
Step 4: Choose fields from here which exist in Available fields and click on the Next button.
Step 5: After this, the next screen will appear, click on the Next button. The next screen will appear.
Step 6: Here, you can sort your fields in ascending or descending order and click on the Next button.
Step 7: The next screen will appear with Layout and Orientation options.
Step 8: You select any layout from the Layout section and Portrait or Landscape from the Orientation section. Click on the Next button.
Step 9: The next screen will appear where you can give the title for your report. Click on Finish.
Q9. Define the following terms. (i) Insert Command (ii) Select Command (iii) Delete Command (iv) DCL Command (v) Template
Ans.
(i) Insert Command: It is used to add a single record or multiple records into a table.
Syntax
Insert into <table_name> (col1, col2...) values (val1, val2):
(ii) Select Command: It is used to query or retrieve data from a table in the database.
Syntax
Select column_list from table_name;
(iii) Delete Command: To discard unwanted data from a database, the delete command is used.
Syntax
Delete from <table_name> WHERE <condition>:
(iv) DCL Command: DCL commands are used to assign security levels in the database which involves multiple user setups. They are used to grant defined roles and access privileges to the users.
(v) Template: It is a complete tracking application with predefined tables, forms, reports, queries, macros and relationships.
Q10. Write SQL queries for the questions from (a) to (e) on the basis of table class.
| No | Name | Stipend | Subject | AvgMark | Grade |
|---|---|---|---|---|---|
| 01 | Vikas | 1200 | Medical | 67 | B |
| 02 | Boby | 1400 | Humanities | 78.4 | B |
| 03 | Tarun | 1000 | Medical | 64.8 | C |
| 04 | Varun | 1600 | Non-Medical | 84 | A |
| 05 | Atul | 1800 | Non-Medical | 92 | A |
(a) Select all the non-medical stream students from the class table.
Ans. mysql> SELECT * FROM Class WHERE Subject= 'Non-medical';
(b) List the names that have grade A sorted by stipend.
Ans. mysql> SELECT Name FROM Class WHERE Grade=`A' ORDER BY Stipend:
(c) Arrange the records of class name wise.
Ans. mysql> SELECT * FROM Class ORDER BY Name;
(d) List the records whose grade is B or C.
Ans. mysql> SELECT * FROM Class WHERE Grade IN ('B', 'C');
(e) Insert the new row with the following data. (06, 'Jack', 2800, 'Humanities', 98, 'A')
Ans. mysql> INSERT INTO Class VALUES (06, 'Jack', 2800, 'Humanities', 98, 'A');
Q11. Write SQL commands for the questions from (a) to (e) on the basis of table SHOP.
| S_NO | P_Name | S_Name | Qty | Cost | City |
|---|---|---|---|---|---|
| S1 | Biscuit | Priyagold | 120 | 12.00 | Delhi |
| S2 | Bread | Britannia | 200 | 25.00 | Mumbai |
| S3 | Chocolate | Cadbury | 350 | 40.00 | Mumbai |
| S4 | Sauce | Kissan | 400 | 45.00 | Chennai |
(a) Display all products whose quantity is between 100 and 400.
Ans. mysql> SELECT * FROM SHOP WHERE Qty BETWEEN 100 and 400;
(b) Display data for all products sorted by their quantity.
Ans. mysql> SELECT * FROM SHOP ORDER BY Qty:
(c) To list S_Name, P_Name, Cost for all the products whose quantity is less than 300.
Ans. mysql> SELECT S_Name, P_Name, Cost FROM SHOP WHERE Qty <300;
(d) To display S_NO, P_Name, S_Name, Qty in descending order of quantity from the SHOP table.
Ans. mysql> SELECT S_NO, P_Name, S_Name, Qty FROM SHOP ORDER BY Qty DESC;
(e) Give S_Name for products whose name starts with 'B':
Ans. mysql> SELECT S_Name FROM SHOP WHERE P_Name LIKE 'B%':
It may helpful for you.
Employability Skills (Part-A)
TERM-I
Unit 1: Communication Skills-II
Unit 2: Self-Management Skills-II
Unit 3: ICT Skills-II
TERM-II
Unit 4: Entrepreneurial Skills-II
Unit 5: Green Skills-II
Subject Specific Skills (Part-B)
TERM-I
Unit 1: Digital Documentation (Advanced)
Unit 2: Electronic Spreadsheet (Advanced)
Unit 3: Database Management System
TERM-II