Punjab Technical University 2006-1st Sem B.Sc Information Technology -IT RDBMS - Question Paper

BSIT(05)-104
RDBMS
BSc IT, first Semester (2096)


Time: 3 Hours Maximum Marks:75


Note: This ques. paper has 2 parts. part A is compulsory. Attempt any nine questions out of twelve ques. from part B.

Section – A
Short ans ques. : Marks: two every
1. List the responsibilities of Data Base Administrator.
2. What is info processing?
3. What is the need for DBMS?
4. What is relational data structure?
5. Explain different symbols used in E-R diagram.
6. What do you mean by Printing Reports?
7. How will you create Forms with Access 2000?
8. Distinguish ranging from Reports and Queries.
9. Explain editing and deleting Data in a Form.
10. Explain data base properties.
11. What is the function of Query processor?
12. How will you test for the absence of duplicate Tuoles?
13. Explain choose Queries in QBE.
14. What are the advantages of QBE?
15. What do you mean by APPEND Query?
2x15=30

Section B
1. Explain the various models of DBMS.
2. Explain Relational Data Integrity with an example.
3. Define the following:
(a) RDBMS
(b) Characteristics of DBMS approach.
4. Explain the distributed Database and its advantages over the centralized system.
5. Explain the various features of ACCESS 2000.
6. Define the following:
(a) Using ans Wizard in ACCESS 2000.
(b) Using the index tab to get Help.
7. Explain sorting and filtering records with an example.
8. Define the following:
(a) Arranging buttons on the toolbar.
(b) Navigating ranging from records in a form.
9. Give example using SQL for the retrieval using Exist.
10. Explain SQL in ACCESS.
11. What do you mean by Security and Protection of Database?
12. Define the following:
(a) Advantages of SQL.
(b) Creating Tables with SQL.
5x9=45

Earning:   Approval pending.