Select The Diploma in Information Technology (DIT) Papers

E- Commerce and Web Technology 1st Term 2019
Operating System 1st Term 2019
Computer Network 1st Term 2019
Computer Programming C/C++ 2019
Introduction to Data Base 2019
MS Access 1st Term 2019
Office Automation 1st Term 2019
Ms-Access DIT Part 2nd Exam 2013 2nd Term
Introduction to Data Base DIT Part 2nd Exam 2014 2nd term
Ms-Access DIT Part 2nd 1st Term examination 2013
Ms- Access DIT Part 2nd 1st Term Exam 2014
Introduction to Data Base DIT Part 2nd 1st Term Exam 2014
E-Commerce & Web Technology DIT part second 2nd Term 2013
E-Commerce & Web Technology DIT part second 1st Term 2013
E-Commerce & Web Technology DIT part second 2014
Operating System DIT Part First 2013
Operating System DIT Part First 2012
Solved exam papers of C/C++ DIT Part First Exam 1st Term 2013
Solved exam papers of C/C++ DIT Part First Exam 1st Term 2012
Solved exam papers of C/C++ DIT Part First Exam 2nd Term 2013
DIT Part 2nd Solved Exam paper of Graphic Designing
Solved exam papers of IT DIT part 1st Exam 2103
DIT Exam paper of E-Commerce and Web Designing 2014
DIT Exam paper of Data Base 2014
DIT Exam paper of MS Access 2014
DIT Exam paper of Graphic Design 2014
DIT(Part 1st) Solved Exam Paper 1st Term Exam 2012 IT
DIT(Part 1st) Solved Exam Paper 1st Term Exam 2012 IT
Exam Paper of Office Automation for DIT Part First 2013
Exam paper of Computer Networks for DIT Part First 2013
Exam paper of ICT DIT Part First 2013
Exam paper of C/C++ language DIT Part First 2013
Exam paper of Operating System DIT Part First 2013

Exam Paper of DIT

Exam Paper of Database 2019

Khyber Pakhtunkhwa Board of Technical Education Peshawar

Diploma in Information Technology

(Part-II)

1st Term Examination 2019

Paper Introduction to database

Time Allowed: - 03 Hrs Marks: - 100

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

Q.1: -What is database Model and explain different types of database models.

Q.2:Define the following.

 a)ERD

 c)Attributes

b)Degree of Relationship

  1. d) Information

Q.3:-

  1. a) What is normalization? And also define de-normalization.
  2. b) What kind of anomalies are removed by normalization.

Q.4:What is DDL? Also explain ALTER and RENAME statement with the help of appropriate examples.

Q.5:What is “Constraints" Explain Unique, Primary Key and Foreign Key constraint with the help of examples.

 Q.6:Discuss Role and Privileges. Also explain create user and Drop user statements with examples.

Q.7:Explain numeric functions with syntax and examples.

 a)ROUND

b)TRUNC MOD

d)COALESCE

Q.8: Write short notes on any two of the following.

  1. a) Referential Integrity
  2. b) Secondary Key
  3. c) Delete statement




View and Download More Papers !

Exam paper of Operating System DIT Part First 2013

Exam paper of C/C++ language DIT Part First 2013

Exam paper of ICT DIT Part First 2013

Exam paper of Computer Networks for DIT Part First 2013

Exam Paper of Office Automation for DIT Part First 2013

DIT(Part 1st) Solved Exam Paper 1st Term Exam 2012 IT

DIT(Part 1st) Solved Exam Paper 1st Term Exam 2012 IT

DIT Exam paper of Graphic Design 2014

DIT Exam paper of MS Access 2014

DIT Exam paper of Data Base 2014

DIT Exam paper of E-Commerce and Web Designing 2014

Solved exam papers of IT DIT part 1st Exam 2103

DIT Part 2nd Solved Exam paper of Graphic Designing

Solved exam papers of C/C++ DIT Part First Exam 2nd Term 2013

Solved exam papers of C/C++ DIT Part First Exam 1st Term 2012

Solved exam papers of C/C++ DIT Part First Exam 1st Term 2013

Operating System DIT Part First 2012

Operating System DIT Part First 2013

E-Commerce & Web Technology DIT part second 2014

E-Commerce & Web Technology DIT part second 1st Term 2013

E-Commerce & Web Technology DIT part second 2nd Term 2013

Introduction to Data Base DIT Part 2nd 1st Term Exam 2014

Ms- Access DIT Part 2nd 1st Term Exam 2014

Ms-Access DIT Part 2nd 1st Term examination 2013

Introduction to Data Base DIT Part 2nd Exam 2014 2nd term

Ms-Access DIT Part 2nd Exam 2013 2nd Term

Office Automation 1st Term 2019

MS Access 1st Term 2019

Introduction to Data Base 2019

Computer Programming C/C++ 2019

Computer Network 1st Term 2019

Operating System 1st Term 2019

E- Commerce and Web Technology 1st Term 2019