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
Related Posts
Basics of Computer By Muhammad Umar
Basics of Computer, Third Edition, eradicates any intimidation about the computer. With a minimal investment of time, you’ll soon be able to understand basic concepts and perform simple tasks on your computer.
Ask a Question
Do you have any questions? Rest assured, we're here to provide answers. Join us in our forum where you can engage in fruitful discussions, ask your queries, and receive insightful responses from our esteemed authors and community members. We look forward to your active participation and valuable contributions as we collectively explore various topics. Let's come together and share your thoughts!
