FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE
📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

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

This post was last modified on 31 March 2020

Tags:PTUPGDCA2020MarchPrevious Question Paper1st SemRelational Database Management SystemRDBMS50504Question PaperPDFDownload
Download Document
Download Document
PTU B-Sc CS-IT 2020 March Previous Question Papers


FirstRanker.com
Firstranker's choice

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

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

Total No. of Questions : 09

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

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

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.

    4. --- 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.

    4. --- 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.

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

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

SECTION-B

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

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

  3. Write SQL query to show the use of create, insert, update and drop commands.
  4. Explain various Scalar functions available with example.
  5. What are the Iterative control statements in PL/SQL? Explain with examples.

SECTION-C

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

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

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


This download link is referred from the post: PTU B-Sc CS-IT 2020 March Previous Question Papers

This post was last modified on 31 March 2020