Page 312 - IT 402 v2.0 class 10
P. 312
i. he marks obtained by the student with ollNo. is
ii. What is the name of the student, who has got the highest marks and what is the amount of scholarship awarded
to him her
iii. ow many records are there in the table
L if e S k il l s & V al ue s
iv. ow many fields are there in the table
2. Sandip is working in a renowned software company as a trainee. ithout the consent of atabase dministrator
he tried to make some changes in the database but database does not allow such permissions. Due to which
feature of database Sandip is unable to make possible changes in the database
. he management of a medical store et ellSoon Medicos decides to computeri e its inventory.
i. Suggest any two tables which must be present in the database. ou can also suggest fields of the tables along
with their data types.
ii. Mention any two benefits that the management will have by computeri ing the inventory.
Previous Years’ Questions
1. hich of the following is not an example of MS
a ostgreS b S ite
c Fox ro d Impress
ns. d
2. A ............................. is an interface in a user specified layout that lets users to view enter and changes data directly
in database ob ects such as tables.
a frame b form
c relation d report
ns. b
. hich of the following is expanded form of S
a Systematic uery anguage b Structure uery anguage
c Software uery anguage d Structural uery anguage
ns. b
4. ............................. is usually suitable for less amount of data. elational Flat File
Ans. Flat File
5. inary data types in a database can be used for storing ............................. .
a photos music files etc. b integer values
c only image files d only video files
ns. a
. hat is primary key ow is it different from foreign key
ns. primary key is a uni ue value that identifies a row in a table. he foreign key identifies a column or set of
columns in one referencing table that refers to a column or set of columns in another referenced table.
. xplain any four data types of MS.
Ans. Numeric Data Type: Numeric Types: Numeric data types are used for describing numeric values for the field used
in the table of a database. Numeric data types in a database can be used for storing information such as mobile
number, roll number, door number, year of school admission, true or false statements, statistical values, etc.
310 Touchpad Information Technology-X

