Introduction to Database Previous Paper 2016


Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
(Part -II)
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 

Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2024 Basics of Computer