Page 311 - IT 402 v2.0 class 10
P. 311
Section B
(Subjective Type Questions)
A. Answer the following questions:
. hat is database
. hat do you mean by MS
. efine the following terms:
i. Table
ii. Fields
iii. ecords
. hat are the two ways of creating table in OpenO ce ase.
5. hat do you mean by ata type ive example of two data type used in OpenO ce ase.
. hat is the difference between har and archar data type
. hat do you mean by Sorting
. hat is eferential Integrity
. hat is Form in OpenO ce ase
. rite two ways of creating form in OpenO ce ase.
. ifferentiate between Forms and eport.
. hat do you mean by uery in OpenO ce ase
. In how many ways you can create uery in OpenO ce ase
. hat do you mean by eport in OpenO ce ase
5. ist Numeric and lphanumeric atatypes in OpenO ce ase. S Sample aper
. our friend owns a chemist shop he needs to keep records of the medicines with their id s date of purchase
expiry date price etc. in a database program. ut he does not have any knowledge about the database. xplain
to him the following to get a better understanding of the MS concepts. S Sample aper
. hat is MS xplain in brief.
. Name any two database programs which can be used to create a table and store the data as per the re uirement.
. hich field can be set as a rimary ey
. Is it possible to make more than one field as a primary key in your table es No . ustify your answer.
. efine the following:
. Sorting with respect to MS
. eferential Integrity
. Many-to-Many elationship with respect to MS
4. Foreign key
B. Application based questions: Cr itical T h ink ing
. onsider the following database Student.
Student
Roll No. First Name Last Name Class Marks Obtained (%) Scholarship Awarded (`)
1205 Mohan Garg 12th 99.9 50000
1009 Dushyant Singh 10th 98.7 45000
1101 Swati ana 11th 95.4 30000
945 avindra Saini 9th 97.5 35000
1015 itika Thakur 10th 98.6 40000
Database Management 309

