First Semester M.Com first Internal Examination 2017

PAPER- IT Application in Commerce

Duration: 1 ½ hrs Marks: 40

Part A

Answer any five questions which carry 2 marks.

1. What is RDBMS?
2. What data warehousing?
3. What is primary key?
4. What is sorting in MS Access?
5. Mention any four important database packages?
(5 x 2= 10 mark)

Part B

Answer any four questions. Each question carries 5 marks

6. What is database? Explain different database models?
7. Who is database administrator? What his functions?
8. What are the different financial factions available in MS Excel?
9. What are the various data types available in MS Access?
10. Explain queries, forms and reports in MS Excel?
(4 x 5 =20 marks)
Part C
Answer any one question. Each question carries 10 marks.
11. What are the different statistical factions available in MS Excel?
12. Give a brief account of the functions used in MS Excel?
(1 x 10=10marks)