Introduction To Database Previous-Paper 2013
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:100
Note: Attempt any five questions. All questions carry equal marks. Mobile Phone & Programmable Calculators are not allowed.
Q.1: -a) What is Database? Explain.
b) What is DBMS? Why DBMS is very important for database.
Q.2:-a) What is the difference between Hierarchical and Relational data model? What is DBA? List the function of DBA.
b) What is Entity? Explain Entity integrity & Domain Integrity.
Q3:-a) Define Attributes. Explain Single value and Multivalued Attributes.
b)Define Attributes. Explain Single value and Multivalued Attributes.
Q.4:-a) What is Binary Relationship? Explain its types with examples.
b) Define Stored attributes & Derived attributes.
Q. 5:-a) What is Normalization? Explain 1st Normal Form.
b) Define Anomalies and their different types.
Q.6:-a) What is SQL? Explain DDL and DML.
b) What is the difference between COMMIT and ROLLBACK statements?
Q.6:-a) What is SQL? Explain DDL and DML.
b) What is the difference between COMMIT and ROLLBACK statements?
Q.7: -a) What is the difference between Primary Key & Foreign Key? Explain with the
help of table.
b) Explain Upper, NSTR and LAID functions.
Q.8:- Define and explain any two of the following.
i) TO-CHAR & TO-NUMBER functions
ii) Network data model
iii) Associative entities.
Related Posts
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
Do you have any questions? Rest assured, we're here to provide answers. Join us in our forum where you can engage in fruitful discussions, ask your queries, and receive insightful responses from our esteemed authors and community members. We look forward to your active participation and valuable contributions as we collectively explore various topics. Let's come together and share your thoughts!
