PSBTE PAPER

PSBTEPAPER.COM

Question Papers & Solutions

Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Paper

Download Previous Year Diploma Solved Question Paper of Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Paper

Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Paper

                                      SECTION-A

Q1. Fill in the blanks.                                                      15×1=15

a. DDL stands for ___________  .
b. DBMS stands for ______________ .
c. PL/SQL is _____________ language.
d. ___________ is the collection of interrelated data. 
e. The ___________ command is used to modify the information stored in a table. 
f. ____________ Model consists of a collection of records connected to one another through links. 
g. The overall design of the database is called ________________.
h. DBA stands for ____________ .
i. A ____________ is the set of allowable values for one or more attributes. 
j. BCNF stands for ______________ .
k. ______________ is a file that contains Meta data i.e. data about data.
l. The number of tuples in a relation is known as _______________.
m. Oracle is an object oriented database. (T/F) 
n. The Declare section ends a PL/SQL block. (T/F) 
o. All fields in a record must be of the same type. (T/F) 

                                      SECTION-B

Q2. Attempt any five questions.                                                                    5×6=30

i. What is DBMS? Explain main advantages of DBMS in brief.
ii. Explain DBMS architecture with diagram.
iii. Discuss Relational Model in brief.
iv. Explain GRANT and REVOKE commands with examples.
v. What are the limitations of File based model?
vi. Explain PL/SQL Block structure in detail.
vii. Write a short note on database security?

                                     SECTION-C

Q3. Attempt any three questions.                                                       3×10=30

a. Explain E-R model by giving a suitable diagram.
b. Discuss five SQL commands with examples.
c. Write down the PL/SQL code for Insertion and Deletion of rows in a Table.
d. What is Normalization? Explain 2NF and 3NF with example.
e. Write a short note on the following.
i. Integrity Constraints
ii. DBMS interfaces

Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Solved PSBTE Paper

                                      SECTION-A

Q1. Fill in the blanks.                                                      15×1=15

a. DDL stands for Data Definition Language .
b. DBMS stands for Database Management Systems.
c. PL/SQL is Procedural language. 
d. Database is the collection of interrelated data. 
e. The Alter command is used to modify the information stored in a table. 
f.A hierarchical database  Model consists of a collection of records connected to one another through links. 
g. The overall design of the database is called Database Schema .
h. DBA stands for Database Administrator .
i. A  Domain is the set of allowable values for one or more attributes. 
j. BCNF stands for Boyce–Codd Normal Form .
k. A data dictionary is a file that contains Meta data i.e. data about data.
l. The number of tuples in a relation is known as Degree .
m. Oracle is an object oriented database. (T/F) TRUE
n. The Declare section ends a PL/SQL block. (T/F) TRUE
o. All fields in a record must be of the same type. (T/F) TRUE

Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Paper


Get Started

https://www.youtube.com/watch?v=y_wJffQkeWo&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=6&t=0shttps://www.youtube.com/watch?v=mV41CMWonN4&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=7&t=0shttps://www.youtube.com/watch?v=M_RR6LVICp0&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=20&t=0shttps://www.youtube.com/watch?v=3BNQLUnbNpYhttps://www.youtube.com/watch?v=ZDkyNOzoG8A&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=8&t=0shttps://www.youtube.com/watch?v=s0LVPE0Q3LE&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=14&t=0s

Section aRelational Database Management System RDBMS Dec 2018 CSE/IT Diploma Paper

DDL stands for ___________________

DDL stands for Data Definition Language .

DBMS stands for _________________

DBMS stands for Database Management Systems.

PL/SQL is __________ language.

PL/SQL is Procedural language. 

_________ is the collection of interrelated data. 

Database is the collection of interrelated data. 

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

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

______________ Model consists of a collection of records connected to one another through links. 

A hierarchical database  Model consists of a collection of records connected to one another through links. 

The overall design of the database is called __________________

The overall design of the database is called Database Schema .

DBA stands for ___________________

DBA stands for Database Administrator .

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

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

BCNF stands for _________________

BCNF stands for Boyce–Codd Normal Form .

_________ is a file that contains Meta data i.e. data about data.

A data dictionary is a file that contains Meta data i.e. data about data.

The number of tuples in a relation is known as ______________

The number of tuples in a relation is known as Degree .

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

TRUE

The Declare section ends a PL/SQL block. (T/F)

 TRUE

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

TRUE

RDBMS Dec 2018 CSE/IT Diploma Solved Paper Click Here

Section B :Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Paper

What is DBMS? Explain main advantages of DBMS in brief.

DBMS and main advantages of DBMS.

Explain DBMS architecture with diagram.

DBMS Architecture with diagram.

Discuss Relational Model in brief.

Relational Model in brief.

Explain GRANT and REVOKE commands with examples.

GRANT and REVOKE commands with examples.

What are the limitations of File based model?

Limitations of File based model/.

Explain PL/SQL Block structure in detail.

PL/SQL Block structure.

Write a short note on database security?

Short note on database security.

RDBMS 3rd Semester CSE Dec  2018 Diploma Solved Paper Click Here

RDBMS 3rd Semester CSE Dec 2018 Diploma Solved Paper


Get Started

https://www.youtube.com/watch?v=UHX6f8TIvX8https://www.youtube.com/watch?v=M_RR6LVICp0https://www.youtube.com/watch?v=mV41CMWonN4https://www.youtube.com/watch?v=s0LVPE0Q3LE&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=14&t=0s

Section c :-RDBMS 3RD Sem CSE DEC 2018 Diploma Solved Paper

Explain E-R model by giving a suitable diagram.

E-R model by giving a suitable diagram.

Discuss five SQL commands with examples.

Five SQL commands with examples.

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

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

What is Normalization? Explain 2NF and 3NF with example.

Normalization and Explain 2NF and 3NF with example.

Write a short note on the following.i. Integrity Constraints

Integrity Constraints

ii. DBMS interfaces

DBMS interfaces

RDBMS 3RD Sem CSE DEC 2018 Diploma Solved Paper Contact Us
MY YOUTUBE CHANNEL

JK Smart Classes Upload Lecture for Degree classes like B.TECH,M.TECH in any stream like ECE,EE,ME and Civil Engineering
\"JK
JK SMART CLASSES
ER.JASWINDER KUMAR
\"JK
JK SMART LECTURE
ER.JASWINDER KUMAR
Engineering Classes Upload Lecture for Polytechnic Diploma classes in any stream like ECE,EE,ME and Civil Engineering
\"JK
ENGINEERING CLASSES
ER.JASWINDER KUMAR
\"JK
er.jaswinder kumar
Senior Lecturer

Leave a Comment

Your email address will not be published.