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

Disclaimer: This website is NOT associated with CBSE, for official website of CBSE visit - www.cbse.gov.in

(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

Accent CustName Transaction Balance
A101 Ram Prasad Withdrawal 10,000
A102 Kamal Deposit 1,50000
A103 Ramadan Deposit 12,000
A104 Sunita Withdrawal 36,000

 

 

 

(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’?...[..]