Introduction to Database Previous-Paper 2014
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Post Inter Diploma in Information Technology (New Course)
(Part-II)
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
Elf Mastery by Bryant Reil
Prepare to be whisked away to a realm where creatures of myth and legend shape the destiny of our world. Join Kyla Nim, along with her extraordinary friends, as they confront the malevolent god of darkness. Can they save the Earth from eternal night? Order your copy of "Elf Mastery" today!
Basics of Computer By Muhammad Umar
Basics of Computer, Third Edition, eradicates any intimidation about the computer. With a minimal investment of time, you’ll soon be able to understand basic concepts and perform simple tasks on your computer.
Ask a Question
You have got questions? We have got answers. Let’s exchange the deal, you ask a question and we will answer. Ask a questions and receive answer from our authors or other members of the community. Let’s meet in the forum and discuss what you have to say!
