Solved question paper for RDBMS May-2020 (DIPLOMA 3rd)
Solved Question Paper
Relational database management system May-2020
PSBTE • DIPLOMA • Information Technology • 3rd • May-2020
RDBMS for Punjab State Board of Technical Education Diploma in Engineering Information Technology 3rd semester helps students view subject-wise previous year question papers and old papers for exam practice. Using these papers can make revision easier, show how questions are usually asked, and help students understand the exam pattern for semester 3 preparation. BRpaper is not the official website of Punjab State Board of Technical Education or any board or university. It only helps students find and access previous year question papers and related exam preparation material for this subject.
Solved Questions
Solved-
Explain the various types of DBMS users?Long Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
May 2019 Explain the various users of the Database?
-
May 2018 Explain various types of DBMS users.
-
May 2017 Briefly describe the different kinds of users of DBMS?
-
May 2017 Briefly describe the different kinds of users of DBMS?
-
May 2015 Explain the various types of DBMS users.
-
May 2008 What are the different types of database end users? Discuss the main activities of each.
-
Dec 2008 Briefly describe the different kinds of users of a DBMS.
-
-
What do you mean by data independence?Long Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
Dec 2024 What is a Data Independence? Explain its various types.
-
May 2022 What is a data Independence? Explain its various types.
-
May 2019 What is Data Independence? Explain various types of Data Independence?
-
Dec 2019 What do you mean by Physical and Logical Data Independence?
-
May 2017 What is data independence? Differentiate between logical and physical data independence?
-
May 2017 What is data independence?
-
May 2017 Differentiate between logical and physical data independence?
-
May 2016 What do you mean by data independence? Explain its types.
-
Dec 2016 What do you mean by data independence? Explain.
-
Dec 2015 What is data independence? Explain two levels of data independence in brief.
-
Dec 2010 Explain data independence and its types.
-
-
What are integrity constraints? Explain.Long Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
May 2018 Explain entity integrity constraints.
-
May 2017 What are various integrity constraints? Explain.
-
May 2017 What are various integrity constraints? Explain.
-
Dec 2015 Explain the types of various integrity constraints.
-
-
Explain primary key by giving suitable example?Long Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
Dec 2015 Explain Primary Key with example.
-
Dec 2015 Explain Secondary Key with example.
-
Dec 2010 Explain the meaning of following with suitable examples: Primary key
-
Dec 2010 Explain the meaning of following with suitable examples: Foreign key
-
-
Explain the difference between functional dependency and multivalued dependency.Long Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
Explain the following: (a) Shared lock (b) Foreign key.Long Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
May 2020 Explain the following a) Shared lock b) Foreign key.
-
-
Explain the properties of transaction?Long Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
May 2022 What do you mean by a transaction?
-
May 2022 What is a transaction? What are the properties of transactions?
-
May 2019 What is a transaction? Explain various states of a transaction?
-
May 2017 Define transaction?
-
May 2017 List the various properties of a transaction?
-
May 2017 Define transaction?
-
May 2017 List the various properties of a transaction?
-
May 2017 Define transaction? List the various properties of a transaction?
-
-
What do you mean by SQL? What are the characteristics of SQL? Explain.Long Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
What do you mean by DBMS? What are the advantages of DBMS? Explain.Long Answer 10 Marks May-2020 • PSBTE DIPLOMA
-
Dec 2024 Explain at least five advantages of a Database System.
-
May 2022 Explain at least five advantages of a Database System.
-
May 2019 Explain the advantages and disadvantages of DBMS?
-
Dec 2019 What are advantages of Database System?
-
Dec 2018 What is DBMS? Explain main advantages of DBMS in brief.
-
May 2017 Discuss the various advantages and disadvantages of DBMS.
-
May 2017 Discuss the various advantages and disadvantages of DBMS.
-
May 2016 What are various advantages and disadvantages of DBMS? Explain.
-
May 2015 Explain the various advantages and disadvantages of DBMS.
-
May 2008 Discuss the main advantages of using a DBMS.
-
-
Explain the ER diagram. What are its uses? Give suitable examples?Long Answer 10 Marks May-2020 • PSBTE DIPLOMA
-
Dec 2024 What is an ER Diagram? Draw various symbols used in it? Give suitable example with a diagram
-
May 2022 What is an ER Diagram? Draw various symbols used in it? Give suitable example with a diagram.
-
May 2018 Explain various components of an ER-diagram.
-
Dec 2018 Explain E-R model by giving a suitable diagram.
-
Dec 2016 Explain E-R model in detail by giving a suitable diagram.
-
Dec 2015 Explain ER Diagram and its components.
-
Dec 2015 What are the uses of ER Diagram?
-
Dec 2015 Give suitable example of ER Diagram.
-
-
What is normalization? Explain 1NF, 2NF and 3NF.Long Answer 10 Marks May-2020 • PSBTE DIPLOMA
-
Dec 2024 What is Normalization? Explain first and Second Normal Forms by giving Example.
-
May 2022 What is Normalization? Explain first and Second Normal Forms by giving Example.
-
May 2019 What is Normalization? Explain all normal forms (1st, 2nd, 3rd)?
-
Dec 2019 Explain first two Normal Forms of Normalization?
-
Dec 2019 What is normalization? What is its importance? Discuss 1NF, 2NF and 3NF with examples.
-
May 2018 Explain 1NF with examples.
-
May 2018 Explain 2NF with examples.
-
May 2018 Explain 3NF with examples.
-
May 2018 What is the importance of normalization? Explain 1NF, 2NF and 3NF with examples.
-
Dec 2018 What is Normalization? Explain 2NF and 3NF with example.
-
May 2017 Explain the 1st normal form with example?
-
May 2017 Explain the 2nd normal form with example?
-
May 2017 What is normalization? Explain the 1st and 2nd normal forms with example?
-
May 2016 What is normalization? Explain 1NF, 2NF and 3NF with examples.
-
Dec 2016 What is normalization? Explain the various normal forms with suitable examples.
-
May 2015 What is normalization? Explain 1NF, 2NF, 3NF with examples.
-
Dec 2015 What is normalization? Explain types of normal forms.
-
-
Differentiate between SQL and PL/SQL. Explain block structure of PL/SQL?Long Answer 10 Marks May-2020 • PSBTE DIPLOMA
-
May 2022 Write one difference between SQL and PL/SQL.
-
May 2022 Give at least five differences between SQL and PL/SQL.
-
Dec 2016 What is the difference between SQL and PL/SQL?
-
May 2015 Difference between SQL and PL/SQL?
-
Dec 2015 What is the difference between SQL and PL/SQL?
-
-
Explain DDL and DML commands with examples?Long Answer 10 Marks May-2020 • PSBTE DIPLOMA
-
May 2022 Explain the following SQL Commands with their syntax.
-
May 2018 Explain DDL commands with examples.
-
May 2018 Explain DML commands with examples.
-
May 2018 Explain SQL data types, DDL and DML commands with examples.
-
Dec 2018 Discuss five SQL commands with examples.
-
Dec 2016 Explain five SQL commands with examples.
-
-
Explain the following a) Shared lock b) Foreign key.Short Answer 5 Marks May-2020 • PSBTE DIPLOMA
-
May 2020 Explain the following: (a) Shared lock (b) Foreign key.
-
Explore all data
FAQ
Frequently Asked Questions
Answers about this subject, solved papers, and preparation.
01 What can I find on this RDBMS subject page?
This page helps students find RDBMS previous year question papers and old papers for PSBTE Diploma in Engineering Information Technology 3rd semester.
02 How can RDBMS previous year papers help in exam preparation?
They help you revise key topics, understand the question style, and get familiar with the exam pattern used in previous semesters.
03 Can I use this page to find subject-wise IT 3rd semester papers?
Yes, this subject page is meant for students looking for subject-wise previous year question papers for PSBTE Diploma IT 3rd semester.
04 Are these official RDBMS papers from the board?
No. BRpaper is not the official website of Punjab State Board of Technical Education or any university or board.
05 Will this page help me find repeated or important questions?
Previous year papers can help you spot repeated question styles and commonly asked topics, which is useful for revision.