Karnataka State Open University (KSOU) 2010-1st Sem B.Sc Information Technology Database Management System I -- Question Paper
Illlllllllllllllllllllllll BSIT 14 (OS)
First Semester B.Sc. (I.T.) Examination, June/July 2010 DATABASE MANAGEMENT SYSTEM - I
Max. Marks : 75
Time : 3 Hours
Instruction: Answer all questions from Part A, and answer any five
questions from Part B.
(12x2+1x1=25)
PART - A
1. List any two objectives of DBMS.
2. Differentiate data and information.
3. Define hashing.
4. Define database.
5. Define filters.
6. Define Reports.
7. What is Multimedia Database ?
8. What is primary and secondary Index ?
9. What is the view of wizard ?
10. Define RDBMS.
11. Define field.
12. Explain direct file organization.
13. What is a filter ?
1. Explain the following :
i) Distributed database.
ii) Multimedia database.
2. Explain record organization with an example.
3. Explain the following :
i) Sequential file
ii) Indexed sequential file.
4. Define record. Explain Fixed Length Record and Variable Length Record with example.
5. Difference between direct and sequential file organization.
6. Mention objective of access database and explain.
7. Write a note on :
i) Sort Tables
ii) Join Tables.
8. How to create a report ? Explain with an example.
|
Attachment: |
| Earning: Approval pending. |
