Introduction to Database Previous (Past) Paper 2015
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
(Part -II)
1st Term Examination 2015
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.
Q.1: a) What is Database? What are advantages of modern database?
b) Differentiate between data and information also explain different
types of data.
Q.2: a) What are the elements of ERD model?
b) What is a relationship explain its various types with the help
of appropriate examples.
Q.3: a) What is normalization? What kind anomalies are removed by
normalization
b) Explain 1st, 2nd and 3rd normal form.
Q.4: Define DML. Also explain Insert, Update and Delete query with the
help of syntax and examples
Q.5: What is constraint? Explain Nout Null Constraint, Primary Key
and Unique Constraint with the help of examples.
Q.6: a) What is the difference between Group by clause
and order by clause.
b) Define key, Explain Foreign key help of examples.
Q.7: Explain the following functions with syntax and suitable examples.
a. Round
b. Trunc
c. LTRIM
d. RTRIM
Q.8: Write short notes on the following.
i) DBMS
ii) Data Control Language.
Related Posts
1 comment on “Introduction to Database Previous (Past) Paper 2015”
Leave a Reply
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!
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!
Muhammad Khan
very informative , Thanks for uploading DIT Past Papers 2018 . In Sha ALLAH you will get reward from Almighty ALLAH keep Sharing such post.