Solved question paper for RDBMS May-2017 (DIPLOMA 3rd)
Solved Question Paper
Relational database management system May-2017
PSBTE • DIPLOMA • Information Technology • 3rd • May-2017
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-
Full form of BCNF is _________.Fill in the Blanks 1.5 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2018 BCNF stands for _________.
-
May 2017 Full form of BCNF is _________.
-
-
The set of all possible values an attribute can have is called its ________.Fill in the Blanks 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 The set of all possible values an attribute can have is called its ________.
-
-
Draw the symbol for entity and derived attribute.Short Answer 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Draw the symbol for entity and derived attribute.
-
-
An ________ diagram represents the overall logical structure of a database in a graphical form.Fill in the Blanks 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2019 An ________ diagram represents the overall logical structure of database in graphical form.
-
May 2017 An ________ diagram represents the overall logical structure of a database in a graphical form.
-
-
Define cardinality?Short Answer 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Define cardinality?
-
-
_______ command is used to take back privileges from the user.Fill in the Blanks 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2019 ________ Command is used to take back privileges from the user.
-
Dec 2019 ________ command is used to take back privileges given to a user.
-
Dec 2019 ____ command is used to take back privileges given to a user.
-
May 2017 _______ command is used to take back privileges from the user.
-
May 2015 ......................... Command is used to take back the privileges given to a user.
-
-
Name any one DBMS.Very Short Answer 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Name any one DBMS.
-
-
Write the syntax of UPDATE command with example.Short Answer 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Write the syntax of UPDATE command with example.
-
-
SQL is a non-procedural language.True / False 1.5 Marks May-2017 • 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. (T/F)
-
Dec 2016 SQL is a procedural language.
-
-
Commit means save the work done.True / False 1.5 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2019 Commit means save work done.
-
May 2017 Commit means save the work done.
-
-
What is data independence? Differentiate between logical and physical data independence?Long Answer 6 Marks May-2017 • 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?
-
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.
-
-
Explain various types of relationships among entities?Long Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Explain various types of relationships among entities?
-
-
What are various integrity constraints? Explain.Long Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2020 What are integrity constraints? Explain.
-
May 2018 Explain entity integrity constraints.
-
May 2017 What are various integrity constraints? Explain.
-
Dec 2015 Explain the types of various integrity constraints.
-
-
Define transaction?Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2022 What do you mean by a transaction?
-
May 2022 What is a transaction? What are the properties of transactions?
-
May 2020 Explain the properties of transaction?
-
May 2019 What is a transaction? Explain various states of a 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?
-
-
List the various properties of a transaction?Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2022 What do you mean by a transaction?
-
May 2022 What is a transaction? What are the properties of transactions?
-
May 2020 Explain the properties of transaction?
-
May 2019 What is a transaction? Explain various states of a transaction?
-
May 2017 Define 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?
-
-
Define the following term: Primary keyVery Short Answer 2 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2024 Define Primary key.
-
May 2022 Define Primary key.
-
Dec 2019 Define Primary Key, Foreign Key and Database.
-
May 2017 Define Primary key.
-
-
Define the following term: EntityVery Short Answer 2 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2024 Define Entity.
-
May 2022 Define Entity.
-
May 2019 Entity
-
May 2017 Define Entity.
-
Dec 2010 Define Entity.
-
-
Define the following term: SchemaVery Short Answer 2 Marks May-2017 • PSBTE DIPLOMA
-
May 2019 Schema of database
-
May 2018 Define Database schema.
-
May 2018 Define the terms: Database schema
-
May 2017 Define Schema.
-
May 2016 Define Schema.
-
-
Briefly describe the different kinds of users of DBMS?Long Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2020 Explain the various types of DBMS users?
-
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 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.
-
-
Discuss the various advantages and disadvantages of DBMS.Long Answer 10 Marks May-2017 • 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 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.
-
-
Full form of BCNF is _________.Fill in the Blanks 1.5 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2018 BCNF stands for _________.
-
May 2017 Full form of BCNF is _________.
-
-
The set of all possible values an attribute can have is called its ________.Fill in the Blanks 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 The set of all possible values an attribute can have is called its ________.
-
-
Draw the symbol for entity and derived attribute.Short Answer 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Draw the symbol for entity and derived attribute.
-
-
An ________ diagram represents the overall logical structure of a database in a graphical form.Fill in the Blanks 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2019 An ________ diagram represents the overall logical structure of database in graphical form.
-
May 2017 An ________ diagram represents the overall logical structure of a database in a graphical form.
-
-
Define cardinality?Short Answer 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Define cardinality?
-
-
_______ command is used to take back privileges from the user.Fill in the Blanks 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2019 ________ Command is used to take back privileges from the user.
-
Dec 2019 ________ command is used to take back privileges given to a user.
-
Dec 2019 ____ command is used to take back privileges given to a user.
-
May 2017 _______ command is used to take back privileges from the user.
-
May 2015 ......................... Command is used to take back the privileges given to a user.
-
-
Name any one DBMS.Very Short Answer 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Name any one DBMS.
-
-
Write the syntax of UPDATE command with example.Short Answer 1.5 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Write the syntax of UPDATE command with example.
-
-
SQL is a non-procedural language.True / False 1.5 Marks May-2017 • 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. (T/F)
-
Dec 2016 SQL is a procedural language.
-
-
Commit means save the work done.True / False 1.5 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2019 Commit means save work done.
-
May 2017 Commit means save the work done.
-
-
What is data independence?Short Answer 6 Marks May-2017 • 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 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.
-
-
Differentiate between logical and physical data independence?Short Answer 6 Marks May-2017 • 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 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.
-
-
Explain various types of relationships among entities?Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2017 Explain various types of relationships among entities?
-
-
What are various integrity constraints? Explain.Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2020 What are integrity constraints? Explain.
-
May 2018 Explain entity integrity constraints.
-
May 2017 What are various integrity constraints? Explain.
-
Dec 2015 Explain the types of various integrity constraints.
-
-
Define transaction?Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2022 What do you mean by a transaction?
-
May 2022 What is a transaction? What are the properties of transactions?
-
May 2020 Explain the properties of transaction?
-
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 List the various properties of a transaction?
-
May 2017 Define transaction? List the various properties of a transaction?
-
-
List the various properties of a transaction?Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2022 What do you mean by a transaction?
-
May 2022 What is a transaction? What are the properties of transactions?
-
May 2020 Explain the properties of transaction?
-
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 Define transaction? List the various properties of a transaction?
-
-
Define Primary key.Very Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2024 Define Primary key.
-
May 2022 Define Primary key.
-
Dec 2019 Define Primary Key, Foreign Key and Database.
-
May 2017 Define the following term: Primary key
-
-
Define Entity.Very Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2024 Define Entity.
-
May 2022 Define Entity.
-
May 2019 Entity
-
May 2017 Define the following term: Entity
-
Dec 2010 Define Entity.
-
-
Define Schema.Very Short Answer 6 Marks May-2017 • 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 2016 Define Schema.
-
-
Briefly describe the different kinds of users of DBMS?Short Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2020 Explain the various types of DBMS users?
-
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 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.
-
-
Discuss the various advantages and disadvantages of DBMS.Long Answer 10 Marks May-2017 • 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 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.
-
-
What is normalization?Short Answer 10 Marks May-2017 • PSBTE DIPLOMA
-
May 2018 What is the importance of normalization?
-
-
Explain the 1st normal form with example?Short Answer 10 Marks May-2017 • 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 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.
-
-
Explain the 2nd normal form with example?Short Answer 10 Marks May-2017 • 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 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.
-
-
Explain the architecture of DBMS.Long Answer 10 Marks May-2017 • 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 2016 Name the three levels in 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.
-
-
Explain the various data types used in SQL?Short Answer 10 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2024 What is SQL? Explain various data types of SQL.
-
May 2022 What is SQL? Explain various data types of SQL.
-
May 2019 Explain various data types of SQL?
-
May 2018 Explain SQL data types with examples.
-
-
SQL is a non-procedural language. (T/F)True / False 1.5 Marks May-2017 • 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.
-
Dec 2016 SQL is a procedural language.
-
-
Commit means save the work done. (T/F)True / False 1.5 Marks May-2017 • PSBTE DIPLOMA
-
Dec 2019 Commit means save work done. (T/F)
-
-
Define transaction? List the various properties of a transaction?Long Answer 6 Marks May-2017 • PSBTE DIPLOMA
-
May 2022 What do you mean by a transaction?
-
May 2022 What is a transaction? What are the properties of transactions?
-
May 2020 Explain the properties of transaction?
-
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?
-
-
Define the following terms
a) Primary key
b) Entity
c) Schema
Short Answer 6 Marks May-2017 • PSBTE DIPLOMA-
May 2017 Define the following terms\na) Primary key\nb) Entity\nc) Schema
-
-
What is normalization? Explain the 1st and 2nd normal forms with example?Long Answer 10 Marks May-2017 • 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 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.
-
-
Define the following terms
a) Primary key
b) Entity
c) SchemaShort Answer 6 Marks May-2017 • PSBTE DIPLOMA-
May 2017
Define the following terms
a) Primary key
b) Entity
c) Schema
-
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.