PSBTE PAPER

PSBTEPAPER.COM

Question Papers & Solutions

Relational Database Management System RDBMS May 2016 CSE/IT Diploma Paper

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

Relational Database Management System RDBMS May 2016 CSE/IT Diploma Paper

                                      SECTION-A

Q1. Fill in the blanks.                                                      10×1.5=15

a. DDL stands for ____________ and DML stands for ____________ .
b. Define Information.
c. What do you mean by a weak entity set?
d. Name the different Joins.
e. Write the syntax of create command.
f. Expand DBMS and SQL?
g. Name the three levels in architecture of DBMS.
h. Define Schema.
i. Number of columns and rows in a relation is called ______ and ______ respectively.
j. _____________ and __________ commands are DCL commands.

                                      SECTION-B

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

a. What do you mean by data independence? Explain its types.
b. Discuss the various types of users.
c. Briefly describe the operators used in SQL.
d. Explain the various types of attributes in ER model.
e. What is the purpose of Where, Order by and Group by clause.
f. Discuss the various DBMS interfaces.
g. Define multi valued dependency and join dependency in normalization.
h. What are various data types in PL/SQL?

                                     SECTION-C

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

a. What are various advantages and disadvantages of DBMS? Explain.
b. What is normalization? Explain 1NF, 2NF and 3NF with examples.
c. What do you mean by data models? Explain various record based data models with examples.
d. Explain the various locking methods used for Data Security.
e. Explain PL/SQL Block structure with example.

Relational Database Management System RDBMS May 2016 CSE/IT Solved PSBTE Diploma Paper

                                      SECTION-A

Q1. Fill in the blanks.                                                      10×1.5=15

a. DDL stands for Data Definition Language  and DML stands for Data Manipulation Language .
b. Define Information.
c. What do you mean by a weak entity set?
d. Name the different Joins.
e. Write the syntax of create command.
f. Expand DBMS and SQL?

Sol. DBMS -Database Management System. 

         SQL-Structured Query Language

g. Name the three levels in architecture of DBMS.

Sol.Threee level of DBMS-Physical level, Conceptual level and External level 
h. Define Schema.
i. Number of columns and rows in a relation is called Degree  and Tuple respectively.
j.GRANT and REVOKE commands are DCL commands.

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 May 2016 CSE/IT Diploma Paper

DDL stands for

DDL stands for Data Definition Language 

DML stands for _______________

DML stands for Data Manipulation Language .

Define Information.

Information

What do you mean by a weak entity set?

Weak entity set.

Name the different Joins.

Different joins

Write the syntax of create command.

Syntax of create command.

Expand DBMS and SQL?

Sol. DBMS -Database Management System

 SQL-Structured Query Language

Name the three levels in architecture of DBMS.

Sol.Threee level of DBMS-Physical level, Conceptual level and External level .

Define Schema.

Schema.

Number of columns and rows in a relation is called ___________  and __________ respectively.

Number of columns and rows in a relation is called Degree  and Tuple respectively.

___________ and ____________ commands are DCL commands.

GRANT and REVOKE commands are DCL commands.

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 May 2016 CSE/IT Diploma Solved Paper Click Here

Section B :Relational Database Management System RDBMS may 2016 CSE/IT Diploma Paper

What do you mean by data independence? Explain its types.

Independence and its types.

Discuss the various types of users.

Various Types of users.

Briefly describe the operators used in SQL.

Describe the operators used in SQL.

Explain the various types of attributes in ER model.

Types of attributes in ER model.

What is the purpose of Where, Order by and Group by clause.

Purpose of Where, Order by and Group by clause.

Discuss the various DBMS interfaces.

DBMS interfaces.

Define multi valued dependency and join dependency in normalization.

Multi valued dependency and join dependency in normalization.

What are various data types in PL/SQL?

Various data types in PL/SQL.

RDBMS 3rd Semester CSE May 2016 Diploma Solved Paper Click Here

RDBMS 3rd Semester CSE may 2016 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 may 2016 Diploma Solved Paper

What are various advantages and disadvantages of DBMS? Explain.

Advantages and disadvantages of DBMS.

What is normalization? Explain 1NF, 2NF and 3NF with examples.

Normalization

Explain 1NF, 2NF and 3NF 

What do you mean by data models? Explain various record based data models with examples.

Models and various record based data models.

Explain the various locking methods used for Data Security.

Locking methods used for Data Security.

Explain PL/SQL Block structure with example.

PL/SQL Block structure with example.

RDBMS 3RD Sem CSE MAY 2016 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.