Page 310 - IT 402 v2.0 class 10
P. 310
. In MS data is organised in the form of ............................. .
i. able ii. ecord
iii. Field iv. None of these
5. hich of the following is not a database program
i. MyS ii. Oracle
iii. riter iv. OpenO ce ase
. Sorting means to arrange data in ............................. order.
i. increasing ii. decreasing
iii. increasing or decreasing iv. None of these
. hich of the following acts as an interface to view enter and change data in database
i. eport ii. able
iii. uery iv. Form
8. A ............................. helps to display the data in a summarised form.
i. eport ii. Form
iii. uery iv. None of these
. hich of the following application is not appropriate to store data about ank customers
S Sample aper
i. Open O ce ase ii. MS ccess
iii. Open O ce riter iv. MS xcel
. Multiple copies of the same file leads to ............................. . S Sample aper
i. Data Inconsistency ii. Data Consistency
iii. ata edundancy iv. Foreign ey
. Identify the property which help to set the number of characters in text varchar type field of a table in
MS. S Sample aper
i. ntry e uired ii. efault alue
iii. Si e iv. ength
. he length of the field value of text data type is ............................. characters by default in MS.
S Sample aper
i. 10 ii. 25
iii. 20 iv. 50
. Identify the mode where we can modify in the structure of table S Sample aper
i. atasheet view ii. Structure view
iii. Design view iv. All of these
14. ............................. store data in a single table which is suitable to store less amount of Data.
S Sample aper
i. Flat File ii. elational
iii. Mini File iv. Single File
B. State whether these statements are true or false.
1. Data Integrity means that data is accurate and consistent in the database.
2. There can be multiple primary key in a table.
3. A record in table is also known as Attribute.
. ueries are commands that are used to define the structure and modify the data in a table.
5. In ase we can create a form using design view.
308 Touchpad Information Technology-X

