Solved question paper for RDBMS Dec-2016 (DIPLOMA 3rd)
Solved Question Paper
Relational database management system Dec-2016
PSBTE • DIPLOMA • Information Technology • 3rd • Dec-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-
The overall design of the database is called ____________.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2018 The overall design of the database is called_________.
-
-
DML stands for ____________.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2019 What is the full form of DML?
-
Dec 2019 What is the full form of DML
-
Dec 2015 Write full form of DML.
-
-
DMA stands for ____________.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
PL/SQL stands for ____________.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
May 2019 PL/SQL is a __________ structured language.
-
Dec 2019 What is the full form of PL/SQL?
-
Dec 2019 What is the full form of PL/SQL
-
Dec 2018 PL/SQL is _________ language.
-
-
____________ are the associations among the various entities.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2010 ... is the association among several entities.
-
-
____________ is a set of allowable values for one or more attributes.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2018 A _________is the set of allowable values for one or more attributes.
-
-
____________ is used to uniquely identify a record in a table.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
____________ is a relationship between two attributes such that the value of one attribute finds the value in the other.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
A related set of values is referred as ____________.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
SQL is ____________ language.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
Data in ____________ form does not have repeated group.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
____________ is a primary key of another table.Fill in the Blanks 1 Marks Dec-2016 • PSBTE DIPLOMA
-
A data dictionary is an essential part of a DBMS.True / False 1 Marks Dec-2016 • PSBTE DIPLOMA
-
SELECT command creates a new table.True / False 1 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2015 SELECT command creates new table.
-
-
SQL is a procedural language.True / False 1 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2019 SQL is Non Procedural Language.
-
Dec 2019 SQL is Non Procedural Language. (T/F)
-
May 2017 SQL is a non-procedural language.
-
May 2017 SQL is a non-procedural language.
-
May 2017 SQL is a non-procedural language. (T/F)
-
-
What is Database? What are its benefits?Long Answer 6 Marks Dec-2016 • PSBTE DIPLOMA
-
Explain DBMS architecture with diagram.Long Answer 6 Marks Dec-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.
-
May 2016 Name the three levels in architecture of DBMS.
-
May 2015 Explain the DBMS architecture.
-
Dec 2010 Explain the three level architecture of DBMS.
-
-
What do you mean by data independence? Explain.Long Answer 6 Marks Dec-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?
-
May 2016 What do you mean by data independence? Explain its types.
-
Dec 2015 What is data independence? Explain two levels of data independence in brief.
-
Dec 2010 Explain data independence and its types.
-
-
Write short note on integrity constraints.Short Answer 6 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2018 Write a short note on Integrity Constraints.
-
-
What is the difference between SQL and PL/SQL?Short Answer 6 Marks Dec-2016 • PSBTE DIPLOMA
-
May 2022 Write one difference between SQL and PL/SQL.
-
May 2022 Give at least five differences between SQL and PL/SQL.
-
May 2020 Differentiate between SQL and PL/SQL. Explain block structure of PL/SQL?
-
May 2015 Difference between SQL and PL/SQL?
-
Dec 2015 What is the difference between SQL and PL/SQL?
-
-
What is database security? Discuss the various methods of database security.Long Answer 6 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2018 Write a short note on database security?
-
-
What are the various data types in PL/SQL?Short Answer 6 Marks Dec-2016 • PSBTE DIPLOMA
-
May 2016 What are various data types in PL/SQL?
-
-
What is normalization? Explain the various normal forms with suitable examples.Long Answer 10 Marks Dec-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?
-
May 2016 What is normalization? Explain 1NF, 2NF and 3NF with examples.
-
May 2015 What is normalization? Explain 1NF, 2NF, 3NF with examples.
-
Dec 2015 What is normalization? Explain types of normal forms.
-
-
Explain E-R model in detail by giving a suitable diagram.Long Answer 10 Marks Dec-2016 • 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 2020 Explain the ER diagram. What are its uses? Give suitable examples?
-
May 2018 Explain various components of an ER-diagram.
-
Dec 2018 Explain E-R model 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.
-
-
Explain five SQL commands with examples.Long Answer 10 Marks Dec-2016 • PSBTE DIPLOMA
-
May 2022 Explain the following SQL Commands with their syntax.
-
May 2020 Explain DDL and DML commands with examples?
-
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.
-
-
Explain the responsibilities of data base administrator.Long Answer 10 Marks Dec-2016 • PSBTE DIPLOMA
-
Dec 2015 Explain the role of DBA and different database end users. Discuss the main activities of each.
-
Dec 2010 Explain the term DBMS. Discuss the responsibilities of DBA.
-
-
Write a short note on PL/SQL Block Structure.Short Answer Dec-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.
-
May 2016 Explain PL/SQL Block structure with example.
-
May 2015 Explain PL/SQL block structure.
-
-
Write a short note on DBMS Interfaces.Short Answer Dec-2016 • PSBTE DIPLOMA
-
Dec 2018 Write a short note on DBMS interfaces.
-
May 2016 Discuss the various DBMS interfaces.
-
Dec 2015 What are DBMS interfaces? Explain in brief.
-
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.