Introduction to Database Previous Paper 2020
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
(Part -II)
1st Term Examination 2020
Paper: Introduction to Database
Time allowed: 3 hours
Max marks: 100
Note: Attempt any five questions. All questions carry equal marks. Mobile phone & programmable calculators are not allowed.
Q1. Briefly explain Database models.
Q2. a) Differentiate data and information.
b) Define the following terms.
i. Database
ii. Meta data
iii. Data dictionary
Q3. (a) Define “relationship” and explain various types of relations with examples and diagrams.
(b) What is attribute Explain its types.
Q4. What is constraint? Explain Not Null, primary key and unique key constraints.
Q5. Explain following terms.
i. Referential integrity
ii. Anomalies and its types
iii. Strong and weak entity
iv. Composite key
Q6. a) What is ERD? Explain with the help of example.
b) What do you know by degree of relationship? Explain.
Q7. a) What clause is used to sort table data in descending order? Explain with example.
b) Differentiate “Commit” and “Roll back” statement.
Q8. Write short note on any two of the following.
a) Simple and complex view
b) Role and privilege
c) Round and truncate function
Related Posts
User Story Confusion: Creating and Breaking Them Down
Unlock the secrets of user story confusion with the Carnsa Development series! Join Bob, the bright son of the Carnsa family, as he enlists the help of his granny to break down user stories into manageable chunks. Discover proven techniques and strategies to help you and your team create and implement user stories with ease.
Order your copy of 'User Story Confusion: Creating and Breaking Them Down' now!
