(Model Paper) Download CBSE Class X, 2nd Pre Board Information Technology Paper (2010)

1) Answer the following questions:-

a) Define alternate key.

b) Study the following data and answer the questions that below:

Table: ACCOUNT

(i) Suggest the data type should be used for each of the fields in the above.

(ii) Suggest a field from the above table, which can be set as primary key.

c) What is the significance of NULL value?

d) Which property would you set if you want to be sure that a First Name Field has a value for each record?

e) For what purpose is the AllowZeroLength property used?

f) When is AutoNumber data type preferred over Number data type?

g) What validation check can be applied to the ADMISSION NUMBER field of STUDENT table so that admission number always starts with either ‘E’ or ‘V’?...[..]