Download PTU PGDCA 2020 March 1st Sem 50504 Relational Database Management System Question Paper

Download PTU (I.K. Gujral Punjab Technical University Jalandhar (IKGPTU) Post Graduate Diploma in Computer Applications (PGDCA) 2020 March 1st Sem 50504 Relational Database Management System Previous Question Paper

www.FirstRanker.com
1 | M-50504 (S2)-1393
Roll No. Total No. of Pages : 02
Total No. of Questions : 09
PGDCA (2018 Batch) (Sem.?1)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : PDCA-104
M.Code : 50504
Time : 3 Hrs. Max. Marks : 60
INSTRUCTION TO CANDIDATES :
1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks
each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students
have to attempt any FOUR questions.
3. SECTION-C contains THREE questions carrying TEN marks each and students
have to attempt any TWO questions.

SECTION-A
1) Answer briefly :
a) Differentiate between primary and candidate key.
b) What do you mean by relation in RDBMS?
c) State the different type of data constraints.
d) What is the use of Views?
e) Explain the use of entity relationship model.
f) Illustrate the use of sub query with example.
g) What are the commands in data control statements?
h) Define Third Normal Form.
i) What are the advantages of Indexes?
j) State the data types used in PL/SQL.
www.FirstRanker.com www.FirstRanker.com
www.FirstRanker.com
FirstRanker.com - FirstRanker's Choice
www.FirstRanker.com
1 | M-50504 (S2)-1393
Roll No. Total No. of Pages : 02
Total No. of Questions : 09
PGDCA (2018 Batch) (Sem.?1)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : PDCA-104
M.Code : 50504
Time : 3 Hrs. Max. Marks : 60
INSTRUCTION TO CANDIDATES :
1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks
each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students
have to attempt any FOUR questions.
3. SECTION-C contains THREE questions carrying TEN marks each and students
have to attempt any TWO questions.

SECTION-A
1) Answer briefly :
a) Differentiate between primary and candidate key.
b) What do you mean by relation in RDBMS?
c) State the different type of data constraints.
d) What is the use of Views?
e) Explain the use of entity relationship model.
f) Illustrate the use of sub query with example.
g) What are the commands in data control statements?
h) Define Third Normal Form.
i) What are the advantages of Indexes?
j) State the data types used in PL/SQL.
www.FirstRanker.com www.FirstRanker.com
www.FirstRanker.com
www.FirstRanker.com
2 | M-50504 (S2)-1393
SECTION-B
2) What is Database management system? State its advantages and disadvantages.
3) Discuss the different types of relational operators with examples.
4) Write SQL query to show the use of create, insert, update and drop commands.
5) Explain various Scalar functions available with example.
6) What are the Iterative control statements in PL/SQL? Explain with examples.

SECTION-C
7) What are the possible dependencies which can exist in database? How can we convert a
database in First normal form to Second normal form?
8) What are the steps involved in developing ER diagram? Identify the different types of
entities and relationships in university management system.
9) What are joins? Explain the different types of joins with examples.









NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any
page of Answer Sheet will lead to UMC against the Student.
www.FirstRanker.com www.FirstRanker.com
www.FirstRanker.com
FirstRanker.com - FirstRanker's Choice