Introduction to Database Previous-Paper 2019


0
Categories : DIT , DIT Previous Papers 2019

Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
(Part -II)
1st Term Examination 2019
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.

Section A

Q1. What is database model and explain different types of database models.
Q2. Define the following.

a. ERD
b. Degree of relationship
c. Attributes
d. Information

Q3. (a) what is normalization? And also define de. Normalization.

(b) What kind of anomalies are removed by normalization.

Section B

Q4. What is DDL? Also explain ALTER and RENAME statement with the help of appropriate examples.
Q5. What is “constraints” explain unique, primary key and foreign key constraint with the help of examples.
Q6. Discuss Role and privileges. Also explain crater user and Drop user statements with examples.

a. ROUND
b. TRUNC
c. MOD
d. COALESUC

Section C

Q7. Explain numeric function with syntax and examples.
Q8. Write short notes on any two of the following.

a) Referential integrity
b) Secondary key
c) Delete statement

Related Posts

Like, Share, and Follow Us!

Leave a Reply

Your email address will not be published.

Copyright © 2022 Basics of Computer