Introduction to Database Previous (Past) Paper 2015


1 comment

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

Like, Share, and Follow Us!

1 comment on “Introduction to Database Previous (Past) Paper 2015

    Muhammad Khan

    • January 29, 2019 at 8:53 am

    very informative , Thanks for uploading DIT Past Papers 2018 . In Sha ALLAH you will get reward from Almighty ALLAH keep Sharing such post.

Leave a Reply

Your email address will not be published. Required fields are marked *


Copyright © 2024 Basics of Computer