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

Home
psbte
diploma
it
3rd
rdbms
Dec-2018

Solved Question Paper

Relational database management system Dec-2018

PSBTE • DIPLOMA • Information Technology • 3rd • Dec-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

DDL stands for ________.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2019 What is the full form of DDL?

Dec 2019 What is the full form of DDL

May 2016 DDL stands for __________ and DML stands for __________.

May 2016 DDL stands for __________________and DML stands for____________________.
DBMS stands for ________.

Fill in the Blanks 1 Marks Dec-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.

May 2018 Define the terms: DBMS

Dec 2010 DBMS stands for

Dec 2010 Define Database.

Dec 2010 Define DBMS.
PL/SQL is _________ language.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
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 2016 PL/SQL stands for ____________.
_________is the collection of interrelated data.

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

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

The_________ command is used to modify the information stored in a table.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
___________Model consists of a collection of records connected to one another through links.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The overall design of the database is called_________.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2016 The overall design of the database is called ____________.
DBA stands for _______.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2019 DBA stands for____________.

Dec 2015 Write full form of DBA.

A _________is the set of allowable values for one or more attributes.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2016 ____________ is a set of allowable values for one or more attributes.
BCNF stands for _________.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2017 Full form of BCNF is _________.

May 2017 Full form of BCNF is _________.
_________is a file that contains Meta data i.e. data about data.

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

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The number of tuples in a relation is known as ________.

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

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

Oracle is an object oriented database.

True / False 1 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2018 Oracle is an object oriented database. (T/F)
The Declare section ends a PL/SQL block.

True / False 1 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2018 The Declare section ends a PL/SQL block. (T/F)
All fields in a record must be of the same type.

True / False 1 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2019 All fields in a record must be of the same type.

Dec 2019 All fields in a record must be of the same type. (T/F)

Dec 2018 All fields in a record must be of the same type. (T/F)
What is DBMS? Explain main advantages of DBMS in brief.

Long Answer 6 Marks Dec-2018 • PSBTE DIPLOMA

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

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 DBMS architecture with diagram.

Long Answer 6 Marks Dec-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?

May 2018 Explain various levels of DBMS architecture.

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.
Discuss Relational Model in brief.

Short Answer 6 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Explain GRANT and REVOKE commands with examples.

Long Answer 6 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2018 Explain the use of Grant command in SQL.
What are the limitations of File based model?

Short Answer 6 Marks Dec-2018 • PSBTE DIPLOMA

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

Explain PL/SQL Block structure in detail.

Long Answer 6 Marks Dec-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.

May 2018 Explain the block structure and benefits of PL/SQL.

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.
Write a short note on database security?

Short Answer 6 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2016 What is database security? Discuss the various methods of database security.
Explain E-R model by giving a suitable diagram.

Long Answer 10 Marks Dec-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?

May 2018 Explain various components of an ER-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.
Discuss five SQL commands with examples.

Long Answer 10 Marks Dec-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.

May 2018 Explain SQL data types, DDL and DML commands with examples.

Dec 2016 Explain five SQL commands with examples.

Write down the PL/SQL code for Insertion and Deletion of rows in a Table.

Long Answer 10 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
What is Normalization? Explain 2NF and 3NF with example.

Long Answer 10 Marks Dec-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.

May 2018 What is the importance of normalization? Explain 1NF, 2NF and 3NF with examples.

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.
Write a short note on Integrity Constraints.

Short Answer Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2016 Write short note on integrity constraints.
Write a short note on DBMS interfaces.

Short Answer Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2016 Discuss the various DBMS interfaces.

Dec 2016 Write a short note on DBMS Interfaces.

Dec 2015 What are DBMS interfaces? Explain in brief.

Oracle is an object oriented database. (T/F)

True / False 1 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2018 Oracle is an object oriented database.
The Declare section ends a PL/SQL block. (T/F)

True / False 1 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2018 The Declare section ends a PL/SQL block.
All fields in a record must be of the same type. (T/F)

True / False 1 Marks Dec-2018 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2019 All fields in a record must be of the same type.

Dec 2019 All fields in a record must be of the same type. (T/F)

Dec 2018 All fields in a record must be of the same type.
Write a short note on the following.
i. Integrity Constraints
ii. DBMS interfaces

Short Answer 10 Marks Dec-2018 • PSBTE DIPLOMA

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

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 Dec-2018 (DIPLOMA 3rd)

Relational database management system Dec-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