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

FirstRanker.com
Firstranker's choice

Roll No. [ TTTT ] Total No. of Pages : 02

--- Content provided by‍ FirstRanker.com ---

PGDCA (2018 Batch) (Sem.-1)
RELATIONAL DATABASE MANAGEMENT SYSTEM
Subject Code : PDCA-104
M.Code : 50504

--- Content provided by⁠ FirstRanker.com ---

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.

--- Content provided by​ FirstRanker.com ---

SECTION-A

1) Answer briefly :

1. Differentiate between primary and candidate key.
2. What do you mean by relation in RDBMS?
3. State the different type of data constraints.

--- Content provided by​ FirstRanker.com ---

4. What is the use of Views?
5. Explain the use of entity relationship model.
6. Illustrate the use of sub query with example.
7. What are the commands in data control statements?
8. Define Third Normal Form.

--- Content provided by‍ FirstRanker.com ---

9. What are the advantages of Indexes?
10. State the data types used in PL/SQL.

SECTION-B

2. What is Database management system? State its advantages and disadvantages.
3. Discuss the different types of relational operators with examples.

--- Content provided by⁠ FirstRanker.com ---

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

6. What are the possible dependencies which can exist in database? How can we convert a database in First normal form to Second normal form?

--- Content provided by​ FirstRanker.com ---

7. What are the steps involved in developing ER diagram? Identify the different types of entities and relationships in university management system.
8. 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.

FirstRanker.com

--- Content provided by‌ FirstRanker.com ---