Class 10 Relational Database Management Systems (Basic) IT (402)

A. Fill in the blanks.

1. A ​database​ is an organized collection of data.

2. A ​database management system is a software package that can be used for creating and
managing databases.

3. A ​RDBMS​ is a database management system that is based on the relational model.

4. Three popular DBMS software are ​Microsoft Access​, ​OpenOffice.org​ & ​MySQL​.

5. A ​Primary Key​ is a unique value that identifies a row in a table.

6. Composite Key is a combination of ​one or more​ columns.

7. A table is a set of data elements that is organized using a model of vertical ​columns and
horizontal ​rows​.

8. A ​column​ is a set of data values of a particular type, one for each row of the table.

9. A ​row​ represents a single, data item in a table.

10. ​Datatypes​ are used to identify which type of data we are going to store in the database.

11. ​Create table​ DDL command is used to create a table.

12. Common DDL statements are ​create​, ​alter​ and ​drop​.

13. The types of languages used for creating and manipulating the data in the Database are ​Data
Definition Language (DDL)​ & ​Data Manipulation Language (DML)​.

14. A ​DDL​ is a standard for commands that define the different structures in a database.

15. A ​DML​ is a language that enables users to access and manipulate data in a database.

16. A ​query language​ is a part of DML involving information retrieval only.

17. A popular data manipulation language is ​SQL​.

18. ​Relationships​ are the basic building blocks of a database.

19. There are ​three​ types of Relationships in a table.

20. A ​table​ helps the user to systematically store information in the database.

21. A ​form enables users to view, enter, and change data directly in database objects such as
tables.

22. ​SELECT statement retrieves zero or more rows from one or more database tables or database
views.

23. By default, data is arranged in ​ascending​ order using ORDER BY clause.

24. ​UPDATE​ statement is used for modifying records in a database.

25. ​DELETE​ statement is used to remove one or more records in a Database.

Page 1 of 6
Class 10 Relational Database Management Systems (Basic) IT (402)
26. To create a form you need to select the ​form​ option available under Database section.

27. A ​query​ helps to collect specific information from the pool of data in the database.

28. ​Report​ is used to display the summary of data.

29. ​GUI​ are the interfaces with which the user interacts.

30. Data from multiple tables can be stored in ​labels​.

B. Question Answer.

1. What does DBMS stand for?

Ans. ​The full form of DBMS is Database Management System.

2. What does RDBMS stand for?

Ans. ​The full form of RDBMS is Relational Database Management System.

3. How is data organized in a RDBMS?

Ans. ​The Relational Database Management System (RDBMS) organizes the data into tables.
RDBMS tables are organized like other tables that have rows and columns. Rows are called
records and columns are called fields.

4. State the relationship and difference between a primary and foreign key?

Ans. ​I​n relation, a table will have only "one primary key", but foreign keys can be multiple. ​Primary
key uniquely identifies a record in the table. Foreign key is a field in the table that is the primary
key in another table.

5. In how many ways tables can be created in Base?

Ans. ​Users can create a Database table in two ways.

1. Top-to-bottom approach: In this approach, first fields are defined and later domains and data
elements are defined.

2. Using the Wizard to create a table

Step 1: Select fields.

Step 2: Set field data types and formats.
Step 3: Set primary key.
Step 4: Create the table.

6. Why are data types used in DBMS /RDBMS?

Ans. ​Data types are classified into five categories listed below.
● Numeric Types
● Alphanumeric Types
● Binary Types
● Date time
● Other Variable types

Page 2 of 6
Class 10 Relational Database Management Systems (Basic) IT (402)
7. List datatypes available in Numeric Datatype?

Ans. ​The different types of numeric data types are:

● Boolean
● Tinyint
● Smallint
● Integer
● Bigint
● Numeric
● Decimal
● Real
● Float
● Double

8. List datatypes available in Alphanumeric Data Type?

Ans. ​The different types of Alphanumeric Data Type are:

● Longvarchar
● Char
● Varchar
● Varchar_Ignore Case

9. Define the structure of a table.

Ans. ​A table is a set of data elements (values) that is organized using a model of vertical columns
(which are identified by their name) and horizontal rows. A table has a defined number of columns,
but can have any number of rows. Each row is identified by the values appearing in a particular
column identified as a unique key index or the key field.

10. Differentiate between Tuples and Attributes of a table.

Ans. ​A row also called a Record or Tuple represents a single, data item in a table.

Whereas

A column is a set of data values of a particular simple type, one for each row of the table.

11. Name different Binary data types.

Ans. ​The different Binary data types are:

● Longvarbinary
● Binary
● Varbinary

12. What is the file extension for databases created using OpenOffice.Org Base?

Ans. ​The file extension for databases created using OpenOffice.Org Base is *.odb

Page 3 of 6
Class 10 Relational Database Management Systems (Basic) IT (402)
13. List any three file formats that can be managed using OpenOffice.OrgBase?

Ans. ​Three file formats that can be managed using OpenOffice.org base are:

*.odt – This file format is used by OpenOffice.org Writer application for creating documents. This is
the counterpart of .doc extension of MS Word.

*.ods – This file format is used by OpenOffice.org Calc application for creating spreadsheets. This
is the counterpart of .xls extension of MS Excel.

*.odp – This file format is used by OpenOffice.org Presentation application for creating
presentations. This is the counterpart of .ppt extension of MS Powerpoint.

14. How many types of relationships can be created in Base? Explain each of them.

Ans. ​There are three types of relationships which can be created in tables:

1. ONE to ONE: ​In this relationship, both the tables must have primary key columns.

2. ONE to MANY OR MANY to ONE: ​In this relationship, one of the tables must have a
primary key column. It signifies that one column of the primary key table is associated with
all the columns of the associated table.

3. MANY to MANY: ​In this relationship, no table has the primary key column.

15. What do you mean by Sorting? In how many ways it can be done?

Ans. ​Data sorting is any process that involves arranging the data into some meaningful order to
make it easier to understand, analyze or visualize. Sorting can be done in either ascending order
of descending order.

16. Explain Referential Integrity with the help of an example.

Ans. ​Referential integrity is used to maintain accuracy and consistency of data in a relationship. In
Base, data can be linked between two or more tables with the help of primary key and foreign key
constraints. Referential integrity helps to avoid:

● Adding records to a related table if there is no associated record available in the primary
key table.
● Changing values in a primary if any dependent records are present in associated table(s).
● Deleting records from a primary key table if there are any matching related records
available in associated table(s).

17. Name DML commands.

Ans. ​The DML commands are:

● S​ELECT – retrieve data from a database.

● INSERT – insert data into a table.
● UPDATE – updates existing data within a table.
● DELETE – deletes all records from a table, the space for the records remain

Page 4 of 6
Class 10 Relational Database Management Systems (Basic) IT (402)
18. What is the purpose of using queries?

Ans. ​A query can either be a request for data results from your database or for action on the data,
or for both. A query can give you an answer to a simple question, perform calculations, combine
data from different tables, add, change, or delete data from a database.

19. Which clause of the Select statement helps to display specific data?

Ans. ​The SELECT statement WHERE clause helps to display specific data.

20. Differentiate between Where and Orderby clause of SQL statements.

Ans. ​The difference between Where and Orderby clause of SQL statements is:

● WHERE specifies which rows to retrieve.

● ORDER BY specifies an order in which to return the rows.

21. State the purpose of Update Command with the help of an example.

Ans. ​Update statement is used for modifying records in a database. The general syntax of the
update statement is as follows:

UPDATE <table_name>

SET <column_name> = value [, column_name = value ...]

[WHERE <condition>];

Example:

Update SDetails

set Location = “Bhubaneswar‟

where Rollno = 14;

22. Why is there a need to create Forms?

Ans. A form provides the user a systematic way of storing information into the database. It is an
interface in a user specified layout that lets users to view, enter, and change data directly in
database objects such as tables.

23. What is the purpose of creating Reports?

Ans. ​A report helps to display the data in a summarized manner. It is used to generate the overall
work outcome in a clear format. You can create reports in the database.

24. What are the prerequisites to create a Form and Reports?

Ans. ​Forms allow you to both add data to tables and view data that already exists. Reports
present data from tables and also from queries, which then search for and analyze data within
these same tables.

Page 5 of 6
Class 10 Relational Database Management Systems (Basic) IT (402)
25. Differentiate between Forms and Reports.

Ans. ​The difference between Forms and Reports is:

Form Report

● A form provides an interface that allows ● Reports are used to present data
users to enter, change and view the from tables or queries in a format
data in a database table.Forms are that can be printed.
made up of elements such as textboxes ● We cannot make changes to the
and labels. data in a report.
● We can make changes to the data in a
form.

26. Can a form display data from queries?

Ans. ​Yes, a form can display data from queries.

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

Ans. ​In three different ways we can create Forms and Reports in database:

● A blank form and report.

● Create a form and report by using a template.
● Create a form and report using wizard.

Page 6 of 6