Solved question paper for RDBMS May-2018 (DIPLOMA 3rd)

Home
psbte
diploma
it
3rd
rdbms
May-2018

Solved Question Paper

Relational database management system May-2018

PSBTE • DIPLOMA • Information Technology • 3rd • May-2018

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.

Question papers (year-wise) Solutions

Solved Questions

Solved

______ is responsible for authorizing access to the database.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
______ is a superset of SQL.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
A _______ key is used to represent relationship between two tables.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
A _______ is a constraint between two sets of attributes in a relation.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

A _______ is an executing program that forms a logical unit of database processing.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The ______ operator allows the selection of rows that contain values within a specified range.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The term _______ refers to a row in a table.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The _______ model represents database as a collection of tables.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

The _______ property requires that a transaction be executed to completion.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The _______ keyword is used to eliminate the duplicate records from the result of SQL query.

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
DCL stands for _______

Fill in the Blanks 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2010 DCL stands for
PL/SQL is a block-structured language.

True / False 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 PL/SQL is a block-structured language. (T/F)

Every relation in BCNF is also in 3NF.

True / False 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Every relation in BCNF is also in 3NF. (T/F)
The database schema and an instance of the database are the same thing.

True / False 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 The database schema and an instance of the database are the same thing. (T/F)
NULL value means absence of data.

True / False 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 NULL value means absence of data. (T/F)
What are the characteristics that distinguish the database approach from traditional file processing approach?

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

Explain various levels of DBMS architecture.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2019 Explain DBMS Architecture?

Dec 2019 What do you understand by 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.

Dec 2016 Explain DBMS architecture with diagram.

May 2015 Explain the DBMS architecture.

Dec 2010 Explain the three level architecture of DBMS.
Explain domain constraints.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Explain entity integrity constraints.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2020 What are integrity constraints? Explain.

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 referential integrity constraints.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2015 Explain the relational constraints.

Explain various types of joins in SQL.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2016 Name the different joins.
Explain two-phase locking protocols.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Explain various components of an ER-diagram.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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?

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.
Explain the use of Commit command in SQL.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Explain the use of Rollback command in SQL.

May 2018 Explain the use of Commit, Rollback, Grant, Revoke and Truncate commands in SQL.

Explain the use of Rollback command in SQL.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Explain the use of Commit command in SQL.

May 2018 Explain the use of Commit, Rollback, Grant, Revoke and Truncate commands in SQL.
Explain the use of Grant command in SQL.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2018 Explain GRANT and REVOKE commands with examples.
Explain the use of Revoke command in SQL.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Explain the use of Truncate command in SQL.

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2022 Explain delete command in SQL.

Define DBMS.

Very Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2024 Define DBMS.

May 2022 Define DBMS.

Dec 2019 What is the full form of DBMS?

Dec 2019 What is the full form of DBMS

May 2018 Define the terms: DBMS

Dec 2018 DBMS stands for ________.

Dec 2010 DBMS stands for

Dec 2010 Define Database.

Dec 2010 Define DBMS.
Define Database schema.

Very Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2019 Schema of database

May 2018 Define the terms: Database schema

May 2017 Define the following term: Schema

May 2017 Define Schema.

May 2016 Define Schema.
Define Database state.

Very Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Define the terms: Database state
Define Data independence.

Very Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Define the terms: Data independence

Define Data model.

Very Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Define the terms: Data model

Dec 2010 Define Data.
What do you mean by relationship and degree of a relationship? Explain various mapping constraints with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Explain various types of DBMS users.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2020 Explain the various types of DBMS users?

May 2019 Explain the various users of the Database?

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.
Explain SQL data types with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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 2017 Explain the various data types used in SQL?

Explain DDL commands with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2022 Explain the following SQL Commands with their syntax.

May 2020 Explain DDL and DML 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 DML commands with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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 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 block structure of PL/SQL.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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.

Dec 2016 Write a short note on PL/SQL Block Structure.

May 2015 Explain PL/SQL block structure.
Explain the benefits of PL/SQL.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

What is the importance of normalization?

Short Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2017 What is normalization?
Explain 1NF with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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 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.
Explain 2NF with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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 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.
Explain 3NF with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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 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.

PL/SQL is a block-structured language. (T/F)

True / False 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 PL/SQL is a block-structured language.
Every relation in BCNF is also in 3NF. (T/F)

True / False 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Every relation in BCNF is also in 3NF.
The database schema and an instance of the database are the same thing. (T/F)

True / False 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 The database schema and an instance of the database are the same thing.
NULL value means absence of data. (T/F)

True / False 1 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 NULL value means absence of data.

Explain domain constraints, entity integrity constraints and referential integrity constraints.

Long Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2019 Explain the Entity Integrity and Referential Integrity rule of relation?

May 2008 Describe entity integrity and referential integrity. Give an example of each.
Explain the use of Commit, Rollback, Grant, Revoke and Truncate commands in SQL.

Long Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Explain the use of Commit command in SQL.

May 2018 Explain the use of Rollback command in SQL.
Define the terms: DBMS

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2024 Define DBMS.

May 2022 Define DBMS.

Dec 2019 What is the full form of DBMS?

Dec 2019 What is the full form of DBMS

May 2018 Define DBMS.

Dec 2018 DBMS stands for ________.

Dec 2010 DBMS stands for

Dec 2010 Define Database.

Dec 2010 Define DBMS.
Define the terms: Database schema

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2019 Schema of database

May 2018 Define Database schema.

May 2017 Define the following term: Schema

May 2017 Define Schema.

May 2016 Define Schema.

Define the terms: Database state

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Define Database state.
Define the terms: Data independence

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Define Data independence.
Define the terms: Data model

Short Answer 5 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Define Data model.

Dec 2010 Define Data.
Explain SQL data types, DDL and DML commands with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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.

Dec 2018 Discuss five SQL commands with examples.

Dec 2016 Explain five SQL commands with examples.

Explain the block structure and benefits of PL/SQL.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Explain the block structure of PL/SQL.

Dec 2018 Explain PL/SQL Block structure in detail.

May 2016 Explain PL/SQL Block structure with example.

Dec 2016 Write a short note on PL/SQL Block Structure.

May 2015 Explain PL/SQL block structure.
What is the importance of normalization? Explain 1NF, 2NF and 3NF with examples.

Long Answer 10 Marks May-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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.

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.

Explore all data

FAQ

Frequently Asked Questions

Answers about this subject, solved papers, and preparation.

Updated regularly

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.

Solved question paper for RDBMS May-2018 (DIPLOMA 3rd)

Relational database management system May-2018

Solved Questions

Explore all data

PTU

PU Chandigarh

PSBTE

PSEB(School)

BFUHS

PU-PATIALA

GNDU

HPTSB

GTU

MDU

MRSPTU

CBSE(School)

BSEH

UBSE

PTU DISTANCE EDUCATION

Frequently Asked Questions