Introduction to Database Previous-Paper 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
Database?
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.
i ) RDBMS
ii) DCL.
iii) Transitive dependence
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!
