Introduction to Database Previous-Paper 2012

Categories : DIT , DIT Previous Papers 2012

Khyber Pakhtunkhwa Board of Technical Education Peshawar
Post Inter Diploma in Information Technology (New Course)
(2nd Semester)
1st Term Examination 2013
Paper: Introduction to Data Base 

Time allowed: 3 hours

Max marks: 50

Note: Attempt any five questions. All questions carry equal marks. Mobile Phone  Programmable Calculators are not allowed.

Q.1:-a)Define and explain the following terms data, information, Meta Data and
       b)Define entity also define its properties with a simple example.

Q.2:-a)Write down simple examples of SQL which shows the use of Truncate & AND (logical operator) separately.
      b)Define entity also define its properties with a simple example.

Q.3:-a)Define function with character manipulation functions.
       b)Define DML also explain the terms with example insert, delete, update.

Q.4:-Define Key, Primary Key, simple composite candidate key with theoretical &
SQL examples.

Q.5:-a)Define Grant and Revoke with the help of theoretical & SQL examples.
       b)Define association / relationship with the help of ER diagram & theoretical
definition along with its types.

Q.6:-a)Define Normalization and its types.
        b)Write down the SQL examples for Maximum & average group functions.

Q.7: -a) Define transaction also explain with the help of example the terms commit
& Roll back.
        b)Define ERD. Mention at least three symbols with example & explain each.

Q.8:-Define and explain any two of the following.

ii) DCL.
iii) Transitive dependence

Related Posts

Like, Share, and Follow Us!

Leave a Reply

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

Copyright © 2024 Basics of Computer