Introduction to Database Previous-Paper 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
100 DAYS OF MULTIPLICATION FACTS PROBLEMS
100 Days of Multiplication Facts Problems has 6000 multiplication facts problems for daily practice and focuses on digits 0-20. There are 100 worksheets, each having 60 problems. You can record the date, time, and score at the top of every page. To make the students fluent with multiplication facts and recall them without delay, several problems are repeated, or the digits are switched.
Order Now
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
You have got questions? We have got answers. Let’s exchange the deal, you ask a question and we will answer. Ask a questions and receive answer from our authors or other members of the community. Let’s meet in the forum and discuss what you have to say!
