Solved question paper for RDBMS May-2016 (DIPLOMA 3rd)
Solved Question Paper
Relational database management system May-2016
PSBTE • DIPLOMA • Information Technology • 3rd • May-2016
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-
DDL stands for __________ and DML stands for __________.Fill in the Blanks 1.5 Marks May-2016 • PSBTE DIPLOMA
-
Dec 2019 What is the full form of DDL?
-
Dec 2019 What is the full form of DDL
-
Dec 2018 DDL stands for ________.
-
May 2016 DDL stands for __________________and DML stands for____________________.
-
-
Define Information.Short Answer 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2022 Define Information.
-
-
What do you mean by a weak entity set?Short Answer 1.5 Marks May-2016 • PSBTE DIPLOMA
-
Dec 2008 Explain the following. Give an example: Weak entity set
-
-
Name the different joins.Short Answer 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2018 Explain various types of joins in SQL.
-
-
Write the syntax of create command.Short Answer 1.5 Marks May-2016 • PSBTE DIPLOMA
-
Expand DBMS and SQL.Short Answer 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2016 Expand DBMS and SQL?
-
May 2015 Expand DBMS.
-
-
Name the three levels in architecture of DBMS.Short Answer 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2019 Explain DBMS Architecture?
-
Dec 2019 What do you understand by DBMS architecture?
-
May 2018 Explain various levels of DBMS architecture.
-
Dec 2018 Explain DBMS architecture with diagram.
-
May 2017 Explain the architecture of DBMS.
-
Dec 2016 Explain DBMS architecture with diagram.
-
May 2015 Explain the DBMS architecture.
-
Dec 2010 Explain the three level architecture of DBMS.
-
-
Define Schema.Short Answer 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2019 Schema of database
-
May 2018 Define Database schema.
-
May 2018 Define the terms: Database schema
-
May 2017 Define the following term: Schema
-
May 2017 Define Schema.
-
-
Number of columns and rows in a relation is called __________ and __________ respectively.Fill in the Blanks 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2016 Number of columns and rows in a relation is called___________ and __________respectively.
-
-
__________ and __________ commands are DCL commands.Fill in the Blanks 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2016 ________ and ________ commands are DCL commands.
-
-
What do you mean by data independence? Explain its types.Long Answer 6 Marks May-2016 • 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 2020 What do you mean by data independence?
-
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?
-
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.
-
-
Discuss the various types of users.Long Answer 6 Marks May-2016 • PSBTE DIPLOMA
-
Briefly describe the operators used in SQL.Long Answer 6 Marks May-2016 • PSBTE DIPLOMA
-
Explain the various types of attributes in ER model.Long Answer 6 Marks May-2016 • PSBTE DIPLOMA
-
What is the purpose of Where, Order by and Group by clause.Long Answer 6 Marks May-2016 • PSBTE DIPLOMA
-
Discuss the various DBMS interfaces.Long Answer 6 Marks May-2016 • PSBTE DIPLOMA
-
Dec 2018 Write a short note on DBMS interfaces.
-
Dec 2016 Write a short note on DBMS Interfaces.
-
Dec 2015 What are DBMS interfaces? Explain in brief.
-
-
Define multi valued dependency and join dependency in normalization.Long Answer 6 Marks May-2016 • PSBTE DIPLOMA
-
What are various data types in PL/SQL?Short Answer 6 Marks May-2016 • PSBTE DIPLOMA
-
Dec 2016 What are the various data types in PL/SQL?
-
-
What are various advantages and disadvantages of DBMS? Explain.Long Answer 10 Marks May-2016 • 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 2020 What do you mean by DBMS? What are the advantages of DBMS? Explain.
-
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 2015 Explain the various advantages and disadvantages of DBMS.
-
May 2008 Discuss the main advantages of using a DBMS.
-
-
What is normalization? Explain 1NF, 2NF and 3NF with examples.Long Answer 10 Marks May-2016 • 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 2020 What is normalization? Explain 1NF, 2NF and 3NF.
-
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?
-
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.
-
-
What do you mean by data models? Explain various record based data models with examples.Long Answer 10 Marks May-2016 • PSBTE DIPLOMA
-
May 2015 What are data models? Explain different types of data models.
-
Dec 2015 What do you mean by data models? Explain types of data models.
-
Dec 2015 What do you mean by data models?
-
Dec 2015 What are various data models? Explain.
-
-
Explain the various locking methods used for Data Security.Long Answer 10 Marks May-2016 • PSBTE DIPLOMA
-
Dec 2015 What are various locking methods used in data security?
-
-
Explain PL/SQL Block structure with example.Long Answer 10 Marks May-2016 • PSBTE DIPLOMA
-
May 2018 Explain the block structure of PL/SQL.
-
May 2018 Explain the block structure and benefits of PL/SQL.
-
Dec 2018 Explain PL/SQL Block structure in detail.
-
Dec 2016 Write a short note on PL/SQL Block Structure.
-
May 2015 Explain PL/SQL block structure.
-
-
DDL stands for __________________and DML stands for____________________.Fill in the Blanks 1.5 Marks May-2016 • PSBTE DIPLOMA
-
Dec 2019 What is the full form of DDL?
-
Dec 2019 What is the full form of DDL
-
Dec 2018 DDL stands for ________.
-
May 2016 DDL stands for __________ and DML stands for __________.
-
-
Expand DBMS and SQL?Short Answer 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2016 Expand DBMS and SQL.
-
May 2015 Expand DBMS.
-
-
Number of columns and rows in a relation is called___________ and __________respectively.Fill in the Blanks 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2016 Number of columns and rows in a relation is called __________ and __________ respectively.
-
-
________ and ________ commands are DCL commands.Fill in the Blanks 1.5 Marks May-2016 • PSBTE DIPLOMA
-
May 2016 __________ and __________ commands are DCL commands.
-
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.