Introduction to Database Previous-Paper 2014

Categories : DIT , DIT Previous Papers 2014

Khyber Pakhtunkhwa Board of Technical Education Peshawar
Post Inter Diploma in Information Technology (New Course)
1st Term Examination 2014
Paper: Introduction to Database

Time allowed: 3 hours

Max marks: 100

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

Q.1: – a) What is Database? What are the advantages of Database?

b) What is Primary Key and Secondary Key? “

Q.2:-  a) What is DBMS? What are the functions of DBMS?

b) Differentiate between DBA and DBMS.

Q.3 :- a) What is ERD? Explain with the help of examples.

b) What do you mean by degree of Relationship explain.

Q.4:- a) What is Normalization? Explain its three types.

b) Differentiate between Entity and Attributes.

Q.5:- a) Define DML. Explain insert, update and delete statement.

b) Write down the purpose, syntax and example of CONCAT and MOD functions.

Q.6:- a) What is DDL statements? Explain Create and Drop statements.

b) Differentiate between Commit and Roll Back statements.

Q.7:- a) What is Conversion function?

b) Define view and data dictionary.

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

i) Strong Entity and Weak Entity
ii) Composite and Foreign Key
iii) DCL statement

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