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
Preventing Dropout and Overcoming School Failure – 30 Ways for Older Teens and Young Adults to Achieve Academic Success
Stay in school and overcome school failure. Get Better Grades with easy to follow study skills. Improve your confidence and your performance on tests and exams. Become highly motivated as you overcome obstacles to your learning. Excellent for high school, college and university students. Know you can do it, even if you are a slow learner.
Get your copy today and start overcoming school failure with easy-to-follow study skills!