Introduction to Database Previous Paper 2016
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
1st Term Examination 2016
Paper: Introduction to Database
Time allowed: 3 hours
Max marks: 100
Note: Attempt any five questions by selecting at least one question from each section. All questions carry equal marks. Mobile phone and programmable calculator are not allowed.
Q1: a) What are the functions of database management system?
b) Explain database model and its types in detail.
Q2: Define association and explain its types with suitable examples and diagrams.
Q3: Define normalization. Also explain 1″, 29 and 3 normal form in detail.
Q4: Define DML. Also explain Insert, Update and Delete statement (query) with the help of syntax and examples.
Q5: What is DCL? Explain COMMIT and ROLLBACK statements with the help of examples.
Q6: a) Explain select statement with the help of syntax and suitable examples.
b) Explain where clause with the help of example.
Q7: Explain following views in detail. What is the importance of view in multiuser environment?
Q8: Write short notes on any two of the following.
a) ER Diagram
b) Primary Key Constraint