Page 313 - IT 402 v2.0 class 10
P. 313
Alphanumeric Types: Various data types are char, varchar, long varchar etc. They are used to store the text.
Binary Types: inary data types are used for storing data in binary formats. inary data types in a database can
be using for storing photos music files etc.
DATE TIME: ate time data types are used for describing date and time values for the field used in the table of
a database. Date time data types in a database can be used for storing information such as date of birth, date
of admission, date of product sale, etc.
. hich one of the following is an example of MS
a Mongo b indows registry
c ublisher d Oracle
ns. d
9. The ............................. has evolved since the s to ease increasing di culties in designing building and maintaining
complex information systems.
a nowledge concept b Formula concept
c atabase concept d Forms concept
ns. c
. Malini wants to store a huge amount of information about her one in a database. Should not be repeated in her
file. er friend argi explained her various benefits of storing data in MS. It helps in preventing controlling
duplication of data. hich of the following terms is used to refer to duplication data
a ata sharing b ata privacy
c ata redundancy d ata integrity
ns. c
. xplain the term Sorting
ns. Sorting means rearrangement of the data either in the ascending order smaller value to bigger value or
in the descending order bigger value to smaller value . he records will be rearranged with respect to the
sorted field.
12. Explain any two types or relationship that can be created in tables.
Ans. Two types of relationships are as follows:
One to one: In this type “ ach record of one table is related to only one record of another able”. It is represented
as a : relationship. In the above created table. ON S N can be in ON SS in a session.
One to many: In this type “ ach record of one table is related to multiple ecords of another table.” It is
represented as a :n relationship. et us take the example of the above tables where ON S N can have
M I S S. Similarly ON teaches M I SS S.
. hat is difference between Form and eport
Ans. he differences between form and report are as follows:
Form: Form is a database object which is used to create an interactive user interface by connecting it with a table.
ach field of a table is displayed in a text box with a Field label on one side so that the user can enter edit and
view records in an e cient way. he data added deleted updated through a form will be reflected in the table
connected to the form.
Report: eport is the formatted data displayed from one or more tables or ueries. his layout of the information
is based on a criteria. It is also known as the summary of a table and helps in data analysis. For example, creating
a report of students who secured 80% and above.
Database Management 311

