Introduction To Database Previous-Paper 2013


0
Categories : DIT , DIT Previous Papers 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

Like, Share, and Follow Us!

Leave a Reply

Your email address will not be published. Required fields are marked *


Copyright © 2024 Basics of Computer