Introduction to Database Previous (Past) Paper 2015
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
1st Term Examination 2015
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.
Q.1: a) What is Database? What are advantages of modern database?
b) Differentiate between data and information also explain different
types of data.
Q.2: a) What are the elements of ERD model?
b) What is a relationship explain its various types with the help
of appropriate examples.
Q.3: a) What is normalization? What kind anomalies are removed by
b) Explain 1st, 2nd and 3rd normal form.
Q.4: Define DML. Also explain Insert, Update and Delete query with the
help of syntax and examples
Q.5: What is constraint? Explain Nout Null Constraint, Primary Key
and Unique Constraint with the help of examples.
Q.6: a) What is the difference between Group by clause
and order by clause.
b) Define key, Explain Foreign key help of examples.
Q.7: Explain the following functions with syntax and suitable examples.
Q.8: Write short notes on the following.
ii) Data Control Language.